Using UDAs and Calc Two Pass in calculation scripts
In this recipe, we will use the @UDA function to list the members that we want to include in our calculation. We will also set up a formula using the @ISUDA Boolean function to retrieve the shares of the total Payroll for each Major Markets in the Market dimension. Finally, we will accomplish this same task by using an outline formula and Calc Two Pass instead. This recipe only applies to the BSO model.
Getting ready
To get started, click on the Start menu and Program | Oracle EPM System | Essbase | Essbase Administration Services | Start Administration Services Console. In the Log in menu, enter your Administration Server, Username, Password, and click on the Log in button.
How to do it...
Drill down on the Essbase Server in EAS, expand the Applications node, drill down on the Sample application and Basic database, right-click on the Outline, and select Edit from the drop down.
Drill down on the Measures dimension and the Ratios hierarchy....
