Media Summary: FEEDSTRINGS enables feeding of string cells. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in TIMST Returns a formatted date/time in a string format. Works in
Tm1 Function Tabdim Rule - Detailed Analysis & Overview
FEEDSTRINGS enables feeding of string cells. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in TIMST Returns a formatted date/time in a string format. Works in DIMIX returns the index of the dimension's element Works in ATTRN returns the numeric attribute for a specified element of a dimension. Works in ELEMENTATTRN returns the numeric attribute value of the 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. DB retrieve a value from a cube cell. Works in CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in DIMNM returns an element's primary name based on an index in a dimension. Works in CAPIT capitalize the first letter of every word in a string. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in
ATTRS returns the string attribute for a specified element of a dimension. Works in TIMVL returns a formatted date/time in a string format. Works in DBRA is used to retrieve and write back a value or text to a dimension's attribute. Use in Excel. Syntax ... UNDEF returns the undefined value. Works in DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format. Works in