DIMENSIONS.COUNT
This formula returns the number of dimensions in a cube which you specify.
Syntax
=MDX.GET(Database Alias, Cube,"Dimensions.Count")
Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.
Example
This example returns 7:
=MDX.GET("Best Practices OLAP", "ANALYSIS", "Dimensions.Count")