Analysis Services
Dimensions
Returns the dimension specified by a numeric or string expression.
Syntax
Numeric
Dimensions(«Numeric Expression»)
Returns the dimension whose zero-based position within the cube is specified by «Numeric Expression».
Note The Measures dimension is always represented by Dimensions(0).
String
Dimensions(«String Expression»)
Returns the dimension whose name is specified by «String Expression».
Remarks
The string version of the Dimensions function is typically used with user-defined functions.
Example
If dimensions Time, Region, and Product are added to a cube (in the listed order), the following expression returns Region:
Dimensions(2)