GET.HIERARCHY.PER.ID
Each dimension has an internal ID. This formula returns the name of a hierarchy from a specified numerical ID. The ID is zero-based. For example, these are the six dimensions of the Analysis cube in the Best Practices sample with their IDs:
Dimension | ID |
---|---|
Measure | 0 |
Period | 1 |
POS | 2 |
Product | 3 |
Region | 4 |
Channel | 5 |
Valtype | 6 |
Syntax
=MDX.GET(Database Alias, Cube, "Dimensions(ID).Name")
Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.
Example
This formula returns VALTYPE
=MDX.GET("Best Practices OLAP", "ANALYSIS", "Dimensions(6).Name")