Tm1 Function Db Rule

Summary

CUBEATTRN returns a numeric attribute for a specified cube. Works in DBRA is used to retrieve and write back a value or text to a dimension's attribute. Use in Excel. Syntax ... ATTRN returns the numeric attribute for a specified element of a dimension. Works in UNDEF returns the undefined value. Works in CELLVALUES returns the string value of the specified element in a specified cube. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in DIMENSIONATTRN returns a numeric attribute for a specified dimension. Works in TIMST Returns a formatted date/time in a string format. Works in ATTRS returns the string attribute for a specified element of a dimension. Works in CODE converts the character to the ASCII numeric code. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.