for MDX Built-in Functions - Dimension Functions

View source

From SQLServerPedia

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in one of the groups: Users, Administrators.

You can view and copy the source of this page:

See Also: [[Main_Page]] - [[Database Administration]] - [[Analysis Services]] - [[MDX with Analysis Services]] - [[MDX Built-In Functions]]

Dimension Functions allow retrieval of dimension, hierarchy and level metadata.

==Dimension==
Dimension function returns the dimension that contains the specified member, hierarchy or level. Syntax is hierarchy.dimension, member.dimension, or level.dimension. For example, "[cy 2001].dimension" would return date dimension.

==Dimensions==
Dimensions function returns a hierarchy that is identified by the specified number or string. The syntax is Dimensions(number OR string). For example, the following returns product categories' hierarchy because that is the parent hierarchy of [category] level:

<pre class='SQL'>SELECT  dimensions('category') ON COLUMNS  FROM [adventure works]</pre>

The following retrieves customers dimension:

<pre class='SQL'>SELECT  dimensions('country') ON COLUMNS  FROM [adventure works]</pre>

Measures dimension is identified by number zero.

==Hierarchy ==
Hierarchy returns the hierarchy to which the specified member or level belongs. The syntax is member.hierarchy or level.hierarchy. For example, the following returns customers' hierarchy:

<pre class='SQL'>SELECT  country.hierarchy ON COLUMNS  FROM [adventure works]</pre>

==Level==
Level returns the level of a given member. The syntax is member.level. For example, the following returns "category" level:

<pre class='SQL'>SELECT  [bikes].level ON COLUMNS  FROM [adventure works]</pre>

==Levels==
Levels function returns the level specified by the string or number. The syntax is dimension.hierarchy.Levels(string or number). The number argument is zero based identifier for the level. For example, [date].[calendar].levels(3) will return quarters. The string argument is the level name, for example [date].[calendar].levels('month') will return months.

Return to MDX Built-in Functions - Dimension Functions.

Retrieved from "http://sqlserverpedia.com/wiki/MDX_Built-in_Functions_-_Dimension_Functions"

SQLServerPedia

View source

From SQLServerPedia

Editor In Chief

Iain Kick

Subscribe

Top Searches