Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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)