Skip to Content
author's profile photo Former Member
Former Member

Using all hierarchies in EPM Embedded


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.

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on 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,


    Add comment
    10|10000 characters needed characters exceeded