Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

EPM member selector option - Filtering

Dear friends,

Need your help on below query -

Dimension #1:

A1

A2

A3

B1

B2

Dimension #2:

C1

C2

D1

D2

Apart from this I have the 'Time' dimension.

Now I need to build report with -

Row axis:  Dimension # 1 & #2

Column axis: Time

However, my requirement is -

If my Dimension#1 starts with A*, then applicable Dimension#2 are C1 & C2

If my Dimension#1 starts with B*, then applicable Dimension#2 are D1 & D2

I have 20K rows in Dimension#1 and it is really not possible for me to do Keep & exclude manually.

Also, I tried VBA code to delete rows.  This is very time consuming.

Is there any way to handle this scenario within epm add in?

Pl. help.

Thanks.

Regards,

Sri

Former Member replied

Hello Sri,

Maintain One property each in Dimension 1 & Dimension 2

In Dimension 1, maintain property as 1 for those members that starts with A and maintain property as 2 for those members that starts with B

In Dimension 2, maintain property as 1 for those members that starts with C and maintain property as 2 for those members that starts with D

Now while preparing report, create First report and in Row axis select member by giving property filter as 1 for Dimension 1 and Dimension 2 and then Create Second report by sharing the Page axis and Column axis of First report and in Row axis select member by giving property filter as 2 for Dimension 1 and Dimension 2.

Tried my best any other better way of doing it, then its welcome..

Regards

Bhagyesh Ravange

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question