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")