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 Server, Username, Password, and click on the Log in button.
How to do it...
On your Essbase Windows server, click on the Start menu, click on Settings, click on Control Panel, select Administrative Tools, and double-click on Data Source(ODBC...
