Clearing data and using the cross- dimensional operators in a calculation script

In this recipe, we will use the ClearData and ClearBlock commands to clear intersections of our data. We will also use an IF/ENDIF conditional statement to set data to #MISSING if it meets certain criteria. Clearing data is a task that you are going to conduct frequently, specifically if your data is transactional. We are also going to be using the cross-dimensional operator in our calculation frequently. The cross-dimensional operators point to specific intersections of member combinations and can be recognized by the hyphen followed by the right-angle bracket sign, which is ->. This recipe only applies to the BSO model.

Getting ready

To get started, click on the Start menu and navigate to Program | Oracle EPM System | Essbase | Essbase Administration Services | Start Administration Services Console. In the Log in menu, enter your Administration Server, username, and password, and click on the Log in button...