Monthly Archives: December 2011

Use Case: Removing the Structure from a Dimension

The Problem: Often when writing dimension update processes from a datasource which is updated automatically we use a standard procedure. Delete all the Elements Add Top Level Consolidations Cycle through (Metadata) Adding Elements and Element Components Cycle through (Data) Adding Aliases But in some cases we are only given a partial data feed.  For example we may be reporting off 3 years sales but the datasource for the Product dimension is broken … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Bedrock, Chores, Consolidation, Dimension, DIMENSIONELEMENTCOMPONENTDELETE, DIMNM, DIMSIZ, ELCOMPN, Element, IBM Cognos TM1, Maintenance, TI Process. Bookmark the permalink. | Tagged Bedrock, Chores, Consolidation, Dimension, DIMENSIONELEMENTCOMPONENTDELETE, DIMNM, DIMSIZ, ELCOMPN, Element, IBM Cognos TM1, Maintenance, TI Process | 3 Comments

Guest Post: Solving a TM1 Performance Problem – Wim Gielis

One of our major customers was facing severe performance problems. The problems related to 2 cubes, in which we wanted to execute a rather tricky elimination. Please follow along while we discuss the cube architecture. We have an allocation cube with the following dimensions: Financial code (10 n elements) Year (2008, 2009, 2010, 2011, 2012) Month (12 months plus YTD consolidations) Scenario (actuals, budget rounds) Allocation phase (7 phases, populated … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged IBM Cognos TM1, TI Process, TM1 Performance, Wim Gielis. Bookmark the permalink. | Tagged IBM Cognos TM1, TI Process, TM1 Performance, Wim Gielis | 1 Comment