If you use TM1 Architect / Perspectives and need a temporary consolidation which does not exist in dimension structure, you can insert user defined consolidation into existing subset. Follow steps […]
Creating TM1 Dimension Calculation in Performance Modeler
You can use dimension calculation if you have a calculation that will be used in all the cubes that contain the dimension. Dimension calculation can be done at leaf level […]
Creating TM1 metrics cube for Scorecarding
Metrics cube is an essential part of a scorecarding application, this cube uses icons to show how each metric is performing. A metrics cube has to contain at least following dimension: […]
Adding dimensions to TM1 cubes
Using Performance Modeler we can add dimension to an existing cube without rebuilding it. Double click on the cube. Drag and drop the dimension from list to cube area or […]
Creating TM1 Drill-through
In Performance Modeler we can easily create a drill-through from a link. Refer here for creating link. Double click the link and in properties window select Yes for Generate Drill through objects? […]
Returning values from Turbo Integrator processes
Introduction The two cornerstone features of any generic programming platform are encapsulation and reuse. These related ideas are simply the ability to write a piece of code once and then […]
Adaptive Modelling – An Item-based Approach
Introduction Working on projects over the years, there was a confluence of “classical” TM1 model design and an approach that was often used to implement Cognos Planning. This occurred when […]
Creating TM1 Pick List in Performance Modeler
Pick List is used to validate data typed into cell against a set of predefined elements. These elements can be based on static list or from dimension subset. Using Performance […]
Moving TM1 Objects using Performance Modeler
In Performance Modeler there’s a functionality to Transfer Out and Transfer In TM1 objects. We can use this functionality to move objects between environments for example from development to testing environment. […]
Using TM1 Data Spread
Data spread will be helpful for entering data in TM1. There are 11 data spread methods available in TM1, below are the examples on how to use them. 1.To populate […]