This category will contain all knowledge related items
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. … More TM1/PA REST API Part 5: Trivia on Base64 Encoding
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. … More TM1/PA REST API Part 4: Understanding Server Response
In this blog post, I will demonstrate 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. … More TM1/PA REST API Part 3: Execution – Making an API Call
This blog post, is second in series related to TM1/PA (#PlanningAnalytics) REST API. This post introduces you to an API client – Postman, to help you get started and to dip your toes in the water, to test out the TM1 REST API functionality.
#TM1 #TM1RESTAPI … More TM1/PA REST API Part 2: Introduction – Get started with POSTMAN
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. … More TM1/PA REST API Part 1: Introduction – Getting it Right
Detailed analysis on utilizing }StatsByRule cube for tracking your TM1 Rule effectiveness. Check out the trivia at the end! … More Tracking the Rule Performance
Continuing with last 2 posts on build efficient reports 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. … More Member Function Workaround in Cognos BI reports
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. … More BI and TM1 – Effect of member function on TM1 Server
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. … More BI with TM1 – Effect of tuple function on 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. … More User Driven Dynamic Formatting in TM1
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. … More Working with TM1 Attributes (Part 4) – Custom Format Attributes
This post details out the process flow of applying custom format on dimensional elements in an IBM Cognos TM1 model. … More Working with TM1 Attributes (Part 3) – Format Attributes
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. … More Working with TM1 Attributes (Part 2) – Using Aliases in Rules
This post delves deeper into Alias attribute of TM1, way to create, use and handle the values; measuring the memory impact. … More Working with TM1 Attributes (Part 1) – Alias attribute in IBM Cognos TM1
An attempt by me to capture the flow of Stargate View creation in an IBM Cognos TM1 Engine. … More TM1 Stargate View Creation Process Flow
Ever Analytics 