Tm1 Function Attrn Rule

ATTRN

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

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

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 ...

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

FEEDSTRINGS enables feeding of string cells. Works in

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

CONSOLIDATEDAVG returns the average value in a consolidation. Works in

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

CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in

HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.

CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in

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

ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. 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

DB retrieve a value from a cube cell. Works in