In this recipe, we will control the calculation flow and apply conditional logic to a calculation by using
IF\ENDIF. We will also learn how to aggregate and calculate the database using the
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.
To get started, click on the Start menu and Program | Oracle EPM System | Essbase | Essbase Administration Services| Start Administration Services Console ...