How to select all children of a dimension

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • 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

      The post was edited 1 time, last by rtindru ().