Media Summary: LONG returns the length of the string. 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
Tm1 Function Code Rule - Detailed Analysis & Overview
LONG returns the length of the string. 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 CELLVALUES returns the string value of the specified element in a specified cube. 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聽... CUBEATTRN returns a numeric attribute for a specified cube. Works in
DIMIX returns the index of the dimension's element Works in CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in UNDEF returns the undefined value. Works in CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in ELEMENTISPARENT determines if an element is parent of another element or not. Works in ELEMENTCOUNT returns the number of components of the consolidated element. Works in
ATTRS returns the string attribute for a specified element of a dimension. Works in SUBST returns the substring of a specified string. Works in TIMST Returns a formatted date/time in a string format. Works in
