Below are the archives of my blog posts:
| Sl No | Date | Title with brief description |
|---|---|---|
| 42 | 2021, March 6 | TM1/PA REST API Part 5: Trivia on Base64 Encoding This post is a trivia on Base64 encoding. We will see the significance of number 64, why there are sometimes one or two equal to signs. |
| 41 | 2021, February 21 | TM1/PA REST API Part 4: Understanding Server Response In this post, we will continue our journey in understanding the TM1 Rest API. We will understand server response, map it with the EDM structure. I will share some tricks to cutdown the payload received from the server. |
| 40 | 2021, February 17 | TM1/PA REST API Part 3: Execution – Making an API Call This post demonstrates a detailed example to make a TM1 REST API Call – specifically GET method of an HTTP request. We will see how to form the URL, put proper settings in Postman and ensure we get the result we want from TM1/PA server |
| 39 | 2021, February 14 | TM1/PA REST API Part 2: Introduction – Get started with POSTMAN This post, is second in series related to TM1/PA (Planning Analytics) REST API. This blog post introduces you to an API client – Postman, to get started with testing TM1 REST API calls. |
| 38 | 2021, February 7 | TM1/PA REST API Part 1: Introduction – Getting it Right There are few things to understand before getting into the weeds of working with the TM1 REST API. This post is an absolute introduction to shed some light on the pre-requisites, for interacting with TM1 REST API. |
| 37 | 2018, February 26 | Tracking the Rule Performance Detailed analysis on utilizing }StatsByRule cube for tracking your TM1 Rule effectiveness. Check out the trivia at the end! |
| 36 | 2018, January 21 | Member Function Workaround in Cognos BI This post delves deeper into the workaround available for member function. By leveraging the methods described here, you can reduce the queries sent to TM1 server. |
| 35 | 2017, December 1 | BI and TM1 – Effect of member function on TM1 Server A query item using member function in nested rows/columns can cause significant overhead to TM1 server. See this post to understand, effect of member function on TM1 server & way to optimize it. |
| 34 | 2017, November 21 | BI with TM1 – Effect of tuple function on TM1 A tuple with multiple elements from more than one dimension causes overhead. See this post to understand, effect of tuple function on TM1 server & way to optimize it. |
| 33 | 2017, October 31 | User Driven Dynamic Formatting in TM1 Once a custom format is defined, we can see the string in the attribute cube. We will use this knowledge and take a leap further to show how users can drive the formatting. This post sketches the outline required to do this and explain how the pieces fit in the puzzle. |
| 32 | 2017, September 24 | Working with TM1 Attributes (Part 4) – Fun with Custom Formats We will explore in depth the custom format option for both character and numeric values in TM1. We will see some fun ways these custom formats can be used to display character/numeric values in CubeViewer. |
| 31 | 2017, September 16 | Working with TM1 Attributes (Part 3) – Format Attributes This post details out process flow of applying format attributes on dimension elements in IBM Cognos TM1. |
| 30 | 2017, August 21 | Working with TM1 Attributes (Part 2) – Using Aliases in Rules This post shows a trick to use Alias attribute, which makes the rule file easier to understand. In addition, I will cover additional tips in working with the attributes in IBM Cognos TM1. |
| 29 | 2017, August 10 | Working with TM1 Attributes (Part 1) – Alias attribute in IBM Cognos TM1 This post delves deeper into Alias attribute of TM1, way to create, use and handle the values; measuring the memory impact. |
| 28 | 2017, July 28 | TM1 Stargate View Creation Process Flow An attempt by me to capture the flow of Stargate View creation in an IBM Cognos TM1 Engine. |
| 27 | 2016, Jun 30 | Ground reality of US Consular working in Chennai, India Ground reality of how US Consulate in Chennai operates. This post should help you prepare mentally and physically, of the torment you have to go through. |
| 26 | 2016, May 26 | What happens when VMM Threshold is reached in TM1? This post delves on the details of IBM Cognos TM1 server behavior when VMM threshold for a cube is reached. |
| 25 | 2016, March 22 | Deep dive into TM1 Stargate views This post focuses on the subtlety of Stargate view creation and deeper dive into its working. Some tips to make them work with Cognos BI. |
| 24 | 2016, March 7 | In-depth look at VMM & VMT Settings in Cognos TM1 An in-depth look at VMM & VMT setting, how they can be used to control caching in TM1 Server. |
| 23 | 2016, February 17 | Recursive function call in an IBM Cognos TM1 Server Illustrating the implementation & limitation of Recursive Function call in IBM Cognos TM1 server with an example. |
| 22 | 2016, February 12 | Cascading style picklist in IBM Cognos TM1 This post describes way to create a cascading style picklist in Cognos TM1 model. |
| 21 | 2016, January 20 | IBM Cognos TM1 Picklist … continued This post is in continuation from last one. It also covers the ways to create picklist in an IBM Cognos TM1 model. |
| 20 | 2016, January 6 | Choosing IBM Cognos TM1 Picklist This explains need for picklist, its types and considerations when using IBM Cognos TM1 Picklist. |
| 19 | 2015, December 2 | Closer look at the DimensionSortOrder function in Cognos TM1 A detailed explanation on using Cognos TM1 DimensionSortOrder function to order elements within the dimension. |
| 18 | 2015, October 31 | TM1 Dimensions – Find memory used & a sneak peek at parent child relationship A closer look at creating parent-to-child relationship in Cognos TM1 dimension. Find memory usage as well. |
| 17 | 2015, October 19 | Dynamic SQL Queries in Turbo Integrator (TI) Read further to make SQL query used in TI dynamic, by using parameters |
| 16 | 2015, October 11 | Working with Undefined (Null) Values in an IBM Cognos TM1Cube Default value of Cognos TM1 cube is 0. Check out how to work with a null value (missing data) |
| 15 | 2015, September 27 | Catalogue your dimension creation processes in Cognos TM1 Are you at the helm of maintaining a very large TM1 model? Learn how to catalogue your dimensions |
| 14 | 2015, September 15 | Manage User Sessions on your IBM Cognos TM1 Server Being a TM1 administrator, at times we are required to manage user sessions on the system. Find out more about it. |
| 13 | 2015, September 07 | Cognos TM1 Chores: Single Commit vs Multiple Commit Illustrating the difference between Single Commit vs Multiple Commit in IBM Cognos TM1 |
| 12 | 2015, August 20 | Accomplish Attibute Update in Cognos TM1 Smartly! Update your dimension attributes the smarter way in IBM Cognos TM1 |
| 11 | 2015, August 11 | Clean up Log directory in IBM Cognos TM1 Read further to know a method to clear the unnecessary files from Log directory as well as retaining required files |
| 10 | 2015, August 04 | Clearing the air around IBM Cognos TM1’s VMM setting In case you are rolling your eyes and thinking, why we need yet another blog talking about VMM, you may want to read for some new information. |
| 9 | 2015, July 29 | Add dummy data to a cube or muddle data to make it unintelligible I will describe how we obfuscated data in an existing cube or data arbitrary data. |
| 8 | 2015, July 26 | Create a very large dimension in Cognos TM1 using Turbo Integrator (TI) This post outlines approach used to create a dimension in Cognos TM1 which has close to half a million random elements in it! |
| 7 | 2015, July 23 | Write to tm1server.log file from Turbo Integrator (TI) process in Cognos TM1 This post shows us the new Logger options available, which aid in writing to tm1server.log file |
| 6 | 2015, July 15 | How to order/sort data in cube view used as a data source in Turbo Integrator (TI)? Ever had the need to work with Ordered/Sorted data from cube view? Check out your options for performing this. |
| 5 | 2015, July 05 | Cognos TM1 Rand() function – it is NOT quite random after all! Check the post to see how random are TM1’s Rand () function output. They start to become predictable! |
| 4 | 2015, July 02 | Using ODBO as datasource in Cognos TM1 Turbo Integrator (TI) Process Need to copy TM1 cube data from one server to another … Happy ODBOing! |
| 3 | 2015, June 25 | IBM Cognos TM1 Import source in SPSS reads incorrect data from TM1 Cube – How to fix it? Fix the issue of incorrect data read in SPSS using Cognos TM1 Cube |
| 2 | 2015, June 21 | Read IBM Cognos TM1 Data in IBM SPSS Modeler Bring in the synergy between 2 IBM products – powerful in-memory OLAP database with predictive analysis tool. We will look at part one, bringing data from Cognos TM1 into IBM SPSSs Modeler |
| 1 | 2015, June 18 | IBM Cognos TM1 and Stored Procedures Want to run a stored procedure in IBM Cognos TM1’s TI? Consider these tips … |
Ever Analytics 