Media Summary: TIMST Returns a formatted date/time in a string format. Works in SCAN searches the specified substring within a string and returns the starting position of the substring. Works in ATTRS returns the string attribute for a specified element of a dimension. Works in
Tm1 Function Codew Rules And - Detailed Analysis & Overview
TIMST Returns a formatted date/time in a string format. Works in SCAN searches the specified substring within a string and returns the starting position of the substring. Works in ATTRS returns the string attribute for a specified element of a dimension. Works in DIMIX returns the index of the dimension's element Works in CONSOLIDATEDMIN returns the minimum value in a consolidation. 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 CELLVALUES returns the string value of the specified element in a specified cube. Works in ELEMENTISPARENT determines if an element is parent of another element or not. Works in CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in CONSOLIDATEDAVG returns the average value in a consolidation. Works in DAY returns the day from a date in a numeric format. Works in
DIMENSIONATTRS returns a string attribute for a specified dimension. Works in CAPIT capitalize the first letter of every word in a string. 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 HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.
