O'Reilly logo

Oracle Essbase 11 Development Cookbook by Jose R. Ruiz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required