Tm1 Function Consolidatedcount Rule

Summary

CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in CONSOLIDATEDAVG returns the average value in a consolidation. Works in CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in CONSOLIDATEDMAX returns the maximum value in a consolidation. Works in ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in DB retrieve a value from a cube cell. Works in ELCOMP returns the name of child of a consolidated element. Works in CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in CUBEATTRS returns a string attribute for a specified cube. Works in ELEMENTCOMPONENT returns the name of child of a consolidated element. Works in ELEMENTISCOMPONENT determines if the element is child of a consolidation or not. ELEMENTCOUNT returns the number of components of the consolidated element. Works in CAPIT capitalize the first letter of every word in a string. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in