From the Blog
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
Read more →
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
Read more →
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:
Read more →
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
Read more →
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?
Read more →
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
Read more →
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
Read more →
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
Read more →
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.
Read more →
IBM Big Data Hub Blog
- Feed has no items.
TM1 Tutorials
- DAY TM1 Function: How to Use, Syntax and Exampleby John on September 13, 2021 at 1:29 am
The TM1 DAY function extracts the Day of Month number from a string based date. For example, DAY ('21-09-18') will return the number 18.
- DimensionDestroy: How to Delete a Dimension in TM1by John on September 3, 2021 at 5:50 am
Sometimes we want to just delete a dimension from TM1. We get lots of failed searches on our site for DimensionDelete – but unfortunately that doesn’t exist. IBM, in their wisdom, have called the function DimensionDestroy, rather than the logical DimensionDelete. Syntax of DimensionDestroy The syntax is very easy: DimensionDestroy(DimName); Where DimName is the name…
- How to Install or Upgrade Planning Analytics for Excel Add-in up until 2.0.64by John on August 3, 2021 at 4:15 am
Updated for PAX 2.0.63. How to install or upgrade IBM Planning Analytics for Excel (PAX) onto a users PC. Detailed instructions with screenshots and warnings about keeping PAX, PAW and PA versions up to date.
