Export (0) Print
Expand All

Dimensions

SQL Server 2000

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)
Show:
© 2014 Microsoft