ONLY FOR NEW IMPLEMENTATIONS!
Introduction
It is possible to create a mapping with dimensions with multiple hierarchies in SSAS models (SAPBPC, Analysys Servicies). Via the configuraotr configurator, there is a setting available to allow user to map not only different dimension's hierarchies but dimension with all hierarchies too.
...
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.
...
Source System Manager
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.
- Single hierarchy mapping: select [Entity].[H1] or [Entity].
...
...
- [H2]
- Multiple hierarchy mapping: select [Entity]
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.
...