on 12-27-2014 11:26 AM
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
Hi Sri,
Kindly explain the requirement with the help of desired screen shot.
Shrikant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.