Using Cube and Subcube Expressions

You often use cube and subcube expressions with Multidimensional Expressions (MDX) statements to define, manipulate, or retrieve data from a cube or subcube.

Cube Expressions

A cube expression contains either a cube identifier or the CURRENTCUBE keyword. Many MDX statements use the CURRENTCUBE keyword to identify the current cube context instead of requiring a cube identifier.

A cube identifier appears as Cube_Name.

SubCube Expressions

A subcube expression can contain a subcube identifier, a subcube function, or an MDX statement that returns a subcube. The MDX SELECT statement, for example, returns a subcube and can be used where subcube expressions are allowed.

A subcube identifier appears as Subcube_Name.

See Also

Concepts

Expressions (MDX)

Help and Information

Getting SQL Server 2005 Assistance