Media Summary: MAX returns the largest number between two numbers. Works in FEEDSTRINGS enables feeding of string cells. Works in CELLVALUES returns the string value of the specified element in a specified cube. Works in
Tm1 Function Exp Rule - Detailed Analysis & Overview
MAX returns the largest number between two numbers. Works in FEEDSTRINGS enables feeding of string cells. Works in CELLVALUES returns the string value of the specified element in a specified cube. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in ATTRN returns the numeric attribute for a specified element of a dimension. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.
DB retrieve a value from a cube cell. Works in TIMST Returns a formatted date/time in a string format. Works in SUBST returns the substring of a specified string. Works in DIMIX returns the index of the dimension's element Works in CONSOLIDATEDAVG returns the average value in a consolidation. Works in DATE returns the date in a string yy-dd-mm format. Works in
ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in CUBEATTRN returns a numeric attribute for a specified cube. Works in ELEMENTISCOMPONENT determines if the element is child of a consolidation or not. ELPARN returns the number of parents of an element. Works in CODE converts the character to the ASCII numeric code. Works in
