Page Comparison

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

...

Alternate hierarchy refers to a situation where a single entity can have multiple parents and contribute differently to each parent. To accomplish this, the alternate hierarchy has shared members that refer to non-shared members of base hierarchies. When this option is enabled, you can identify a custom rollup for each level of the hierarchy. For example, with employee data, you can have data for different years. Year 1 is a parent of Year 2, and Year 2 is the parent of Year 3. When you select this option, the cube semantic model does calculations to support the alternate hierarchy when it is compiled.

...

1. From the Toolbox, click Semantic Models.

2. Select the semantic model (and dimension > hierarchy) for which you want to define an alternate hierarchy or add a new semantic model.

   1. Click the Actions menu ( ⋮ ) at the top of the Semantic Models column.

   2. Click Add Semantic Models.

   3. Enter a name for the semantic model.

   4. Select a Relationship from the list and click Add.
      You can enter a term in the search box to quickly find a name.

   5. Add a hierarchy and view the Hierarchy Properties on the right side of the page.

3. In the Hierarchy Properties, select Has alternate path to indicate that there are shared members within other hierarchies. 

4. Click Save to save your changes.
   

   

...