How to derive a Base level from Parent member in EPM Report?

[former_member288225]

Hi,

Could you please provide some insights on the below issue.

BPC Version - 10.1

BPC Cons Model - Cost centre IFRS

I have a report where I need to display Dimensions Account and Cost center in multiple columns for as shown below.

Required Layout:

Layout that I managed to get

Questions:

1. For example, the below-nested formula would help to derive Parent hierarchy of base member. =EPMMemberProperty(,EPMMemberProperty(,$D$18,"PARENTH1"),"PARENTH1")

Similarly, is there a way to derive base level based on Parent?

2. How to insert a Local Member column in between different Account and Costcenter dimensions?

Is Local Member, the only option? If so, I had tried but it is collapsing the layout. Any insights and suggestions would be helpful

Regards,
Mohammed

[former_member186338]

Sorry, but you are answering questions for additional info and do not accept correct answers...

[former_member186338 · Accepted solution]

Absolutely easy!

Just duplicate row axis member id's in local members:

=EPMMemberProperty(,$D$18,"ID")

...

Then you will have 4 local members and you can select a proper order of local members:

First - before column axis

Second - after first local member

...

Hide row axis

[former_member288225 · Accepted solution]

Thank you so much, I will try and let you know.