Authorities
and privilegesUse the OLAP Server: Load data from SQL table with load rules (ESSDATA3) program to load data from an SQL source into a multidimensional OLAP Server database using load rules. The OLAP Server can be a DB2 OLAP Server or an Essbase server.
The OLAP Server: Load data from an SQL table with load rules program uses the user ID and password defined for the source database for the step in the Steps notebook.
When you select a step that uses this program, link a source table to the step, but do not link the step a target.
To load data from an SQL source into a multidimensional OLAP Server database using load rules:
Specify information for your step:
In the Name field, you can type a new name for the step. Otherwise, you can keep the name that the Data Warehouse Center automatically supplied for the step. This field is required.
In the Administrator field, type the name of the person who is responsible for the maintenance of this step. This field is optional.
In the Description field, type a business description for your step. This description can be a maximum of 255 characters. This field is optional.
In the Notes field, type detailed information that might be helpful to users who can access this step. This field is optional.
On the Parameters page, in the OLAP Server system name field, type the name of the OLAP Server to use.
In the OLAP Server application name field, type the name of the OLAP Server application to use.
In the OLAP Server database name field, type the name of the OLAP Server database that has the default calc script to call.
In the OLAP Server user ID field, type the user ID to use to connect to the OLAP Server database.
In the OLAP Server password field, type the password for the user ID.
In the Verify OLAP Server password field, type the password again.
In the Load rules file name field, type the name of the load rules file that you want the program to use. If the file is on the OLAP Server, the file name cannot have an extension. If the file is located on the agent site, you must specify the fully qualified file name.
In the Load rules file location flag area, click the location of the rules file.
In the OLAP Server utility abort flag area, select whether to stop the OLAP Server utility if there is an error.
On the Processing Options page, in the Agent Site list, select an agent site where you want your step to run. The selections in this list are agent sites that are common to the source tables, the target table, and the transformer or program that you are defining.
If you want to have the option to to run your step at any time, select the Run on demand checkbox. Your step must be in test or production mode before you can run it.
Optional: Select the Populate externally check box if the step is populated externally, meaning that it is invoked in some way other than by the Data Warehouse Center. The step does not have to have any other means of running in the Data Warehouse Center in order to change the mode to production.
If Populate externally is not selected, then the step must either have a schedule, be linked to a transient table that is input to another step, or be started by another program in order to change the mode to production.
In the Retry area, specify how many times you want the step to run again if it needs to be retried and the amount of time that you want to pass before the next run of the step.
Click OK to save your changes and close the step notebook.
Related information