Tm1 Function Consolidatedcount Rule

Summary

CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in CONSOLIDATEDAVG returns the average value in a consolidation. Works in CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in CONSOLIDATEDMAX returns the maximum value in a consolidation. Works in ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in ELCOMP returns the name of child of a consolidated element. Works in CUBEATTRN returns a numeric attribute for a specified cube. Works in ELEMENTCOMPONENT returns the name of child of a consolidated element. Works in DB retrieve a value from a cube cell. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in ELEMENTCOUNT returns the number of components of the consolidated element. Works in ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.