Exploring Tm1 Function Subst Rule
Exploring Tm1 Function Subst Rule reveals several interesting facts.
- HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.
- CONSOLIDATEDAVG returns the average value in a consolidation. Works in
- CODE converts the character to the ASCII numeric code. Works in
- CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in
- CELLVALUES returns the string value of the specified element in a specified cube. Works in
In-Depth Information on Tm1 Function Subst Rule
SUBST SCAN searches the specified substring within a string and returns the starting position of the substring. Works in ATTRN returns the numeric attribute for a specified element of a dimension. Works in CUBEATTRN returns a numeric attribute for a specified cube. Works in
UNDEF returns the undefined value. Works in
Stay tuned for more updates related to Tm1 Function Subst Rule.