Skip to Content
0

2 hirarchies in multiple reports in one worksheet

Nov 28, 2017 at 05:28 PM

38

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Nov 28, 2017 at 07:21 PM
0

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!

Show 2 Share
10 |10000 characters needed characters left characters exceeded

You're going to hell for refusing helping a saint! :d

0

Hell is already here :)

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

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"


ew9rv.png (7.2 kB)
Show 1 Share
10 |10000 characters needed characters left 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!

0