on 12-27-2014 12:05 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sri,
You have to describe the user selection... then the solution based on property may work.
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.