Media Summary: SUBST returns the substring of a specified string. Works in FEEDSTRINGS enables feeding of string cells. Works in One of the top 5 most watched presentations from Horizon in 2020. A step by step demonstration on implementing business聽...
Tm1 Function Trim Rule - Detailed Analysis & Overview
SUBST returns the substring of a specified string. Works in FEEDSTRINGS enables feeding of string cells. Works in One of the top 5 most watched presentations from Horizon in 2020. A step by step demonstration on implementing business聽... CELLVALUES returns the string value of the specified element in a specified cube. Works in CUBEATTRN returns a numeric attribute for a specified cube. Works in CONSOLIDATEDAVG returns the average value in a consolidation. Works in
DIMIX returns the index of the dimension's element Works in TIMST Returns a formatted date/time in a string format. Works in TIMVL returns a formatted date/time in a string format. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. LONG returns the length of the string. 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 ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in UNDEFVALS changes the default value for the cube from zero to a special undefined value. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in
