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

Creating a load rule for SQL data load using substitution variables

In this recipe, we will be creating an ODBC connection to the TBC database created in the recipe Creating TBC database and connecting to the data source in Chapter 2. We will set up substitution variables for the SQL load rule and create a load rule that uses our SQL data source. This recipe was created using Window XP and may be a slightly different version of Windows or Linux. Consult your network administrator for specific instructions on setting up an ODBC.

Getting ready

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

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