Using control flow commands, conditional, and logical operators
In this recipe, we will control the calculation flow and apply conditional logic to a calculation by using FIX\ENDFIX and IF\ENDIF. We will also learn how to aggregate and calculate the database using the AGG and CALC DIM commands. Moreover, we will use the SET CREATEBLOCKONEQ command to make sure that blocks are created for our calculated measure. Finally, we will review the logical operators that you can use in the calculations and discuss the @RETURN function new to 11.1.2.x. 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, right-click on...
