Skip to Content
avatar image
Former Member

2 hirarchies in multiple reports in one worksheet

hi

I have a requirement to show same member from two different parent hierarchies, although parent hier2 is a copy of parent hier1 in one report.

parent heir1

hier1

mem1

mem2

parent hier2

hier1

mem1

mem2

now I want to

display mem1 and its parent hier1 name as well as "hier1"

and

display mem1 and its parent hier2 name as well as "hier1"

how to achieve this?

thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 28, 2017 at 07:21 PM

    If you want an answer, please use your real name instead of Saint bpc

    Please read the forum rules: https://www.sap.com/community/about/rules-of-engagement.html

    And provide a screenshot of the required report, your explanation is unclear!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 28, 2017 at 09:36 PM

    Yes Vadim changed the name. thank you for the advice.

    regarding my question.

    I have one dimension and two hierarchies in it. I am displaying them using two report ids.

    the default report: I am using epmmemberproperty to display the members and it is working fine, but when I bring another report within the same worksheet and use epm member property to display the higher level hierarchy I get an error " the member requested doesnot exst in the hierarchy"

    Add comment
    10|10000 characters needed characters exceeded

    • "I am using epmmemberproperty to display the members" - sorry, but not clear! No formulas visible on screenshot!

      And please remove also "bpc" from your user name!