Skip to Content

Using all hierarchies in EPM Embedded

Feb 19, 2017 at 03:16 PM


avatar image
Former Member


Let's suppose that I have a dimension Category which have different members: 0, A, B, A01, A02, B01, B02...

I can have a first hierarchy [H1] with this elements:

  • Parent: 0
  • Childs: A01, A02, B01, B02

And I also have a second hierarchy [H2] with the following elements:

  • Parent: A
  • Child: A01
  • Parent: B
  • Child: B01

In BPC Standard we could have all hierarchies of a dimension in a report, so I was able to have the following in my report:

O [H1]

A [H2]

However in BPC Embedded, when I create the query I have to choose a hierarchy, is there any possibility to be able to see all hierarchies and use them in a report (like in the standard version)?

Thank you.

10 |10000 characters needed characters left characters exceeded
Former Member

You are working with Analysis for office?

Former Member
Former Member

Hi Priyanka,

I am working with the EPM Plug-in in Analysis for Office, but I think the problem is in the BEx Query Designer, where I can only choose one hierarchy.

Thank you.

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gerd Schoeffl
Mar 01, 2017 at 01:23 PM

Hi Christina,

By design you can only use one (or no) BW Hierarchy at a time for a certain characteristic/dimension in a BW query and thus in a BPC Embedded query. This behavior is independent of the chosen front end (Analysis for Office, EPMplug-in, Design Studio,...).

Best regrads,


10 |10000 characters needed characters left characters exceeded