Tag Archives: Element

Changing Element Order in a TM1 Dimension

How to set the order of elements in a dimension in TM1, either manually via the Dimension Editor, automatically via TM1 Server Explorer or within a Turbo Integrator process – and why you should be very careful when using it!

This entry was posted in Elements and tagged Dimension Editor, Dimension Maintenance, dimension order, DimensionSortOrder, Element. Bookmark the permalink. | Tagged Dimension Editor, Dimension Maintenance, dimension order, DimensionSortOrder, Element | Leave a comment

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