Media Summary: 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 TIMST Returns a formatted date/time in a string format. Works in
Tm1 Function Attrn Rule - Detailed Analysis & Overview
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 TIMST Returns a formatted date/time in a string format. 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 ... CELLVALUES returns the string value of the specified element in a specified cube. Works in ELEMENTATTRN returns the numeric attribute value of the specified element of a dimension. Works in
CONSOLIDATEDAVG returns the average value in a consolidation. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. DIMENSIONATTRS returns a string attribute for a specified dimension. Works in CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in DIMENSIONATTRN returns a numeric attribute for a specified dimension. Works in FEEDSTRINGS enables feeding of string cells. Works in
UNDEF returns the undefined value. Works in ELEMENTATTRS returns the string attribute value of the specified element of a dimension. Works in CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in ELEMENTTYPE returns element type information of an element in the dimension. Works in CUBEATTRS returns a string attribute for a specified cube. Works in ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in
