Skip to Content

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

Filter based on two dimensions

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

Tags:
Not what you were looking for? Ask a question