ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 28-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
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>