Tm1 Function Subst Rule

Summary

CUBEATTRN returns a numeric attribute for a specified cube. Works in NOW returns the current Time in a serial number format. Works in 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 CONSOLIDATEDAVG returns the average value in a consolidation. Works in SCAN searches the specified substring within a string and returns the starting position of the substring. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in UNDEF returns the undefined value. Works in ATTRS returns the string attribute for a specified element of a dimension. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in DB retrieve a value from a cube cell. Works in DBRA is used to retrieve and write back a value or text to a dimension's attribute. Use in Excel. Syntax ... HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.