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 CONSOLIDATEDMAX returns the maximum value in a consolidation. Works in CONSOLIDATEDMIN returns the minimum 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 DB retrieve a value from a cube cell. Works in ELCOMP returns the name of child of a consolidated element. 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 ELEMENTCOUNT returns the number of components of the consolidated element. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.