Tm1 Function Attrs Rule

ATTRS

ATTRN returns the numeric attribute for a specified element of a dimension. Works in

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

ELEMENTATTRS returns the string attribute value of the specified element of a dimension. Works in

STET cancels the effect of

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

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

CUBEATTRN returns a numeric attribute for 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

ELEMENTPARENT returns the parent of an element in the dimension. 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

LONG returns the length of the string. Works in

DB retrieve a value from a cube cell. Works in

DIMENSIONATTRN returns a numeric attribute for a specified dimension. Works in

CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. 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 ...

UNDEF returns the undefined value. Works in

ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.