Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Introduction

It is possible to create a mapping with dimensions with multiple hierarchies in SSAS models (SAPBPC, Analysys Servicies). Via the configuraotr is a setting available to allow user to map not only different  dimension's hierarchies but dimension with all hierarchies too. 

Configurator

In the configurator the option for an SSAS Connection: Enable multiple hierarchies". User should be able to set value to "true" or "false". True gives the option to create multiple hierarchies. 

Design Studio (not web based)

If configuration setting "SSAS Connection: Enable multiple hierarchies" is set to "false", user can select only one of dimension's hierarchies. You can see in the list "[Entity] [H1]" or "[Entity] [H2]", in this example.

In case the configuration setting "SSAS Connection: Enable multiple hierarchies" is set to "true", user can select one of dimension's hierarchies or dimension with multiple hierarchies. You can see in the list "[Entity]", "[Entity] [H1]" and "[Entity] [H2]", for example.

 

Designer

After mapping the dimensions with multiple hierarchies, the cube calculations can only be created on one hierarchy. See the example below, even the dimension Entity is mapped to the complete dimension, cube calculations can only be created on particular hierarchies ([Enitity].[H1] and [Entity].[H2])

 

Web application

When a cockpit dimension is mapped to the dimension with multiple hierarchies, root members from all the hierarchies are shown in the POV. In this example, All Entity. H1 is the only root member on hierarchy [Enitity].[H1], All Entity. H2 is the only root member on hierarchy [Enitity].[H2]. In case of cube calculations with no parent defined follow the real members. First, all cube calculations with no parent from the 1st hierarchy, then all the cube calculations with no parent from the 2nd hierarchy.

...