Tm1 Function Subst Rule

Summary

CUBEATTRN returns a numeric attribute for a specified cube. Works in ATTRN returns the numeric attribute for a specified element of a dimension. 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 UNDEF returns the undefined value. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in ATTRS returns the string attribute for a specified element of a dimension. Works in NOW returns the current Time in a serial number format. Works in CODE converts the character to the ASCII numeric code. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. 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 HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.