Tag Archives: DIMENSIONELEMENTCOMPONENTDELETE
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!
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
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