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

Using @XREF functions to move data between BSO cubes

In this recipe, we will use the XREF function in a calculation script to pull data from a source to the target Block Storage database. The value of this XREF function is obvious when you consider that you can assign calculation execution access to your power users and empower them to pull data from another database on demand. This function also gives you the option of sharing between databases instead of replicating load processes. Moreover, the XREF function does not require that outlines be identical so you can pull data from outlines with completely different dimension structures and hierarchies.

Getting ready

To get started, click on the Start menu and navigate to Programs | Oracle EPM System ...

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