Default elements

Each alternate hierarchy has one default element that can be specified by an administrator.

If the default element is not specified the first root element of a hierarchy is used as default element. Due to different visibility of elements the first root element can be different for different users.

If the default element is specified, this element is used for all users. If the user does not have rights to view the element, the error code 21216 ("The unique name […] could not be resolved ") is returned.

The administrator can set default elements by using OLAP element names. If an OLAP element has several parents, then the first occurrence in XMLA dimension is used as a default element.

The specified default element is stored in the dimension properties XML structure and can be set on the Edit Database dashboard or with the Dimension PutProperties XML function.

Example

This example sets a default element:

<Alea:Request RequestID="001" Class="Dimension" Method="PutProperties">
   <Alea:Dimension Name="Region">
      <Alea:Properties>
         <Alea:DefaultMember Name="Canada" />
      </Alea:Properties>
   </Alea:Dimension>
</Alea:Request>