Tm1 Function Subst Rule

SUBST

There are many different ways to write the lyrics in

CELLVALUES returns the string value of the specified element in a specified cube. Works in

SCAN searches the specified substring within a string and returns the starting position of the substring. Works in

CONSOLIDATEDAVG returns the average value in a consolidation. Works in

EXP returns the natural anti-log of a number. Works in

ATTRN returns the numeric attribute for a specified element of a dimension. Works in

DIMENSIONATTRS returns a string attribute for a specified dimension. Works in

ATTRS returns the string attribute for a specified element of a dimension. Works in

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 string.

MAX returns the largest number between two numbers. Works in

FEEDSTRINGS enables feeding of string cells. Works in

ATAN returns the angle, in radians, whose tangent is x. Syntax ATAN(x) X = The tangent of the angle we want to find. Demo Use ...

ELEMENTTYPE returns element type information of an element in the dimension. Works in

DB retrieve a value from a cube cell. Works in

ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.

UNDEF returns the undefined value. Works in

CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in