Tm1 Function Long Rule Net Net Worth 2026: Salary, Income & Wealth

LONG

CUBEATTRN returns a numeric attribute for a specified cube. Works in

DIMIX returns the index of the dimension's element Works in

HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.

CONSOLIDATEDAVG returns the average value in a consolidation. Works in

DATE returns the date in a string yy-dd-mm format. Works in

TIMST Returns a formatted date/time in a string format. Works in

CODE converts the character to the ASCII numeric code. Works in

UNDEF returns the undefined value. Works in

DB retrieve a value from a cube cell. Works in

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

CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in

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