Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 27, 2014 at 03:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 27, 2014 at 03:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 27, 2014 at 07:25 PM

    Hi Sri,

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

    Vadim

    Add comment
    10|10000 characters needed characters exceeded