0 Replies Latest reply on Jul 5, 2007 12:31 AM by 3004

    How to aggregate until parent member?

      Hello all,<BR><BR>How to calculate the parent member of the current member?<BR><BR>Background: I want to offer users a limited dimension aggregation option. This to reduce the calculation time. Users are most interested in calculation of the level just above the input level. Therefore, I want to create the possibility to calculate the parent of the current member which is given with a prompt in Business Rules. <BR><BR>I have been exploring the possibility of @PARENT or @ANCESTOR but I could not find a possibility (since I can not use them in a Fix statement).<BR><BR>Do you see a possibility here?<BR><BR>Philip Hulsebosch<BR>Trexco<BR><BR><BR>