Tm1 Function Dimensionattrn Rule

DIMENSIONATTRN

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

FEEDSTRINGS enables feeding of string cells. Works in

ELEMENTATTRN returns the numeric attribute value of the specified element of a dimension. Works in

CUBEATTRN returns a numeric attribute for a specified cube. Works in

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

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

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

CONSOLIDATEDAVG returns the average value in a consolidation. 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

CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in

DIMNM returns an element's primary name based on an index in a dimension. Works in

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

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

DIMIX returns the index of the dimension's element Works in

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

CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in

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

ELISANC determines if an element is ancestor of another element or not. Works in