At times, the “value” of the parent element needs to be referred to, to determine how a calculation applies to a specific element. A simple everyday example would be of Balance Sheet Vs. Income Statement across the time dimension. The QTD for Balance Sheet Accounts is the balance of the last completed month in the quarter […]
Gaurav Jain
Blogs from this Author
Dimensions – Part 1
Dimensions are the building blocks of OLAP tools like TM1. This underscores the need to have correct dimensions for the specific purpose intended. Dimensions can be classified in the following categories. Based on Functionality: Master / Reporting Dimensions The master dimensions are used to create other dimensions, which are mathematical subsets of the master dimension […]
SwapAliasWithPrincipalName – Using Alias as Dimension Element
In TM environments that have models to plan employee-based salaries, dummy names are used as placeholders. As positions are filled, the intention is to replace the place holders with the actual employee code or names. This is only an isolated example. Similar needs would exist in multiple ways within an implementation. To support this, TM1 has […]