Tag Archives: DIMENSIONELEMENTCOMPONENTDELETE

DimensionElementDelete Function TM1: Syntax and Use

Here is how to simply delete a single element from a dimension in TM1. Note DimensionElementDelete permanently deletes the element from the dimension and all associated data from any cube the dimension is used in – so please be careful!

This entry was posted in TI Functions and tagged DIMENSIONELEMENTCOMPONENTDELETE, DimensionElementDelete, DimensionElementInsert, dimix, IF. Bookmark the permalink. | Tagged DIMENSIONELEMENTCOMPONENTDELETE, DimensionElementDelete, DimensionElementInsert, dimix, IF | 1 Comment

DimensionElementComponentAdd TM1 Function: Use and Syntax

DimensionElementComponentAdd adds an existing element of a dimension in TM1 into a hierarchy as a child of another existing element.  With this function you can define what the weight of the element is to determine if the values are to be added or subtracted from the parent. Syntax of DimensionElementComponentAdd The syntax is: DimensionElementComponentAdd (DimName, ConsolidatedElName,ElName, ElWeight); where: DimName is the dimension you want to work with. ConsolidatedElName is the element to which … Continue Reading

This entry was posted in TI Functions and tagged DimensionElementComponentAdd, DIMENSIONELEMENTCOMPONENTDELETE, DimensionElementInsert, dimix. Bookmark the permalink. | Tagged DimensionElementComponentAdd, DIMENSIONELEMENTCOMPONENTDELETE, DimensionElementInsert, dimix | 3 Comments

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