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 configurator, there is a setting available to allow user to map not only different  dimension's hierarchies but dimension with all hierarchies too. 

...

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]

Image Added

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])

...