Exploring Tm1 Function Long Rule
Exploring Tm1 Function Long Rule reveals several interesting facts.
- SUBST returns the substring of a specified string. Works in
- CONSOLIDATEDAVG returns the average value in a consolidation. Works in
- CUBEATTRN returns a numeric attribute for a specified cube. Works in
- DIMIX returns the index of the dimension's element Works in
- DATE returns the date in a string yy-dd-mm format. Works in
In-Depth Information on Tm1 Function Long Rule
LONG HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. CONSOLIDATEDMAX returns the maximum value in a consolidation. Works in ATTRN returns the numeric attribute for a specified element of a dimension. Works in
ELEMENTFIRST returns the first element of a specified dimension. Works in
Stay tuned for more updates related to Tm1 Function Long Rule.