How to select all children of a dimension

      How to select all children of a dimension

      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

      Post was edited 1 time, last by “rtindru” ().