Skip to Content
avatar image
Former Member

Using all hierarchies in EPM Embedded

Hello,

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

  • 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.

  • Get RSS Feed

1 Answer

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

    Gerd

    Add comment
    10|10000 characters needed characters exceeded