Media Summary: 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 DIMENSIONATTRS returns a string attribute for a specified dimension. Works in
Overview

Tm1 Function Cubeattrn Rule - Detailed Analysis

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 DIMENSIONATTRS returns a string attribute for a specified dimension. Works in CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in ATTRN returns the numeric attribute for a specified element of a dimension. Works in ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.

ELISANC determines if an element is ancestor of another element or not. Works in CONSOLIDATEDMAX returns the maximum value in a consolidation. Works in FEEDSTRINGS enables feeding of string cells. Works in CUBEATTRS returns a string attribute for a specified cube. Works in DB retrieve a value from a cube cell. Works in TIMST Returns a formatted date/time in a string format. Works in

CAPIT capitalize the first letter of every word in a string. Works in CONSOLIDATEDCOUNT returns the number of values in a consolidation. Works in ELEMENTTYPE returns element type information of an element in the dimension. Works in 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

Gallery

Photo Gallery

Related

Related Shipments