What is the syntax for TM1ElList?
TM1ElList(TM1ServerName:Dimension, SetName, ElementList, AliasOverride, ExpandAbove, MDXOverride, IndentRate, IndentCharacter)
NOTE: There are three methods to set the list: SetName, ElementList and MDX. The order in precedence is MDX, ElementList then SetName
- TM1ServerName = Name of the TM1 Server
- Dimension = Name of the Dimension (REQUIRED)
- SetName = Set name (OPTIONAL)
- ElementList = An array of elements. For example {“4”;”40”;”400”} (OPTIONAL)
- AliasOverride = Name of an alias (OPTIONAL)
- ExpandAbove = A Boolean field. 1 for consolidations to expand above or 0 to expand below. As a default, it is set to 0 (OPTIONAL)
- MDXOverride = An MDX expression (OPTIONAL)
- IndentRate = Enter a number to indicate the indentation applied to each level. A value of 0 applies no indentation. As a default, the indentation of 1 is applied (OPTIONAL)
- IndentCharacter = Set a character for the indentation. As a default, a space is used. (OPTIONAL).