Alternate hierarchies in MDX and schema requests

Appropriate information is returned in schema rowsets that contain a HIERARCHY_NAME or HIERARCHY_UNIQUE_NAME column.

Each dimension returned in MDX queries and XMLA schema requests has at least one hierarchy.

It is not possible to calculate a cell that refers to multiple elements of a dimension, even when these elements belong to different hierarchies. If an MDX query is sent that violates this rule, error 21262 is returned (A dimension cannot be put onto more than one axis).

The hierarchy unique names are the combination of the dimension name and the hierarchy name ([Dimension].[Hierarchy]). The only exception is the implicit hierarchy. It has the same name as the dimension. Usually those dimensions were converted from older versions. This hierarchy unique name contains only the dimension name ([Dimension]).

The generated unique names of elements contain the hierarchy unique name and the element part. Received unique names are resolved into the hierarchy noted in the unique name.