Tm1 Function Long Rule - Detailed Analysis
HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. DATE returns the date in a string yy-dd-mm format. Works in CUBEATTRN returns a numeric attribute for a specified cube. Works in CODE converts the character to the ASCII numeric code. Works in 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
DIMENSIONATTRS returns a string attribute for a specified dimension. Works in DIMIX returns the index of the dimension's element Works in TIMST Returns a formatted date/time in a string format. Works in DB retrieve a value from a cube cell. Works in ATTRN returns the numeric attribute for a specified element of a dimension. Works in ATTRS returns the string attribute for a specified element of a dimension. Works in
CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in CONSOLIDATEDAVG returns the average value in a consolidation. Works in ELEMENTTYPE returns element type information of an element in the dimension. Works in CONSOLIDATEDMAX returns the maximum value in a consolidation. Works in DAY returns the day from a date in a numeric format. Works in
Photo Gallery
