Media Summary: CUBEATTRN returns a numeric attribute for a specified cube. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty TRIM removes any leading and trailing spaces from a
Tm1 Function Str Rule - Detailed Analysis & Overview
CUBEATTRN returns a numeric attribute for a specified cube. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty TRIM removes any leading and trailing spaces from a SUBST returns the substring of a specified ATTRN returns the numeric attribute for a specified element of a dimension. Works in CODE converts the character to the ASCII numeric code. Works in
DIMIX returns the index of the dimension's element Works in ELEMENTATTRN returns the numeric attribute value of the specified element of a dimension. Works in DB retrieve a value from a cube cell. Works in EXP returns the natural anti-log of a number. Works in
