I have a cube with 13 dimensions one of which is say "Name"
Let us say my dimension Name has the dimelements A, B, C, D & 'No Name'
The hierarchy is
Name
A
B
C
D
No Name
I need a rule that puts the value of NoName to be 1 if there is atleast the value 1 in any of the four mentioned above - A, B, C or D
Also, in future I may have new dim elements E, F & G.
I need the rule to be dynamic - since I cannot edit it for every new dim element addition
I'm hope this conveys what I am trying to say.
Cheers
Let us say my dimension Name has the dimelements A, B, C, D & 'No Name'
The hierarchy is
Name
A
B
C
D
No Name
I need a rule that puts the value of NoName to be 1 if there is atleast the value 1 in any of the four mentioned above - A, B, C or D
Also, in future I may have new dim elements E, F & G.
I need the rule to be dynamic - since I cannot edit it for every new dim element addition
I'm hope this conveys what I am trying to say.
Cheers
The post was edited 1 time, last by rtindru ().