cancel
Showing results for 
Search instead for 
Did you mean: 

EPM member selector option - Filtering

sridevi_p
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

bhagyesh_ravange
Active Participant
0 Kudos

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

Answers (2)

Answers (2)

former_member186338
Active Contributor
0 Kudos

Hi Sri,

You have to describe the user selection... then the solution based on property may work.

Vadim

former_member186338
Active Contributor
0 Kudos

One question - how many members you have in Dimension 2?

bhagyesh_ravange
Active Participant
0 Kudos

Hello Sri,

Does all your Member in Dimension 1 starts with A or B and in Dimension 2 with C or D.

Regards

Bhagyesh Ravange

sridevi_p
Active Contributor
0 Kudos

Yes.  IT starts that way.

Thanks,

Sridevi

bhagyesh_ravange
Active Participant
0 Kudos

Have you tried doing the same as mentioned below.