You use the Update Outline dialog box to load members into a block storage outline and, thus, to build dimensions.
In the Type group, you select SQL (to use a SQL database as the data source) or “Data files” (to use a file as the data source). Then, you perform one of the following actions:
If you selected SQL, in the 'SQL user” and “SQL password” boxes, you enter your username and password on the SQL database.
If you selected the “Data files" option, you locate and select one or more data files.
Any file that you select is listed in the “Data files” box. When selecting data files, keep the following in mind:
To locate a file that is stored on Essbase Server, click the Find Data File button.
A data source that is saved on Essbase Server and the database into which you are loading data must be located in the same directory.
To locate a file that is not saved on Essbase Server, use the File System tab.
You delete a file by selecting it and clicking the Delete button.
Because the outline is being updated dynamically using a rules file, the “Use rules” option is selected and cannot be cleared. If an outline were not being updated dynamically, you could select the option and, thereby, enable dynamic updating.
The path and name of the selected rules file is displayed in the Rules file box. As you select a rules file, keep the following in mind:
To locate a rules file that is saved on Essbase Server, click the Find Rules File button.
A rules file that is saved on Essbase Server and the database into which you are loading data must be located in the same directory.
To locate a file that is not saved on Essbase Server, use the File System tab.
To specify how errors are handled, you can perform the following actions:
Specify, in the “Error file” box, the location to which errors are written. This action is available to you because the “Use rules file” option is selected. If the option were not selected, errors would be written to the aaspath\client directory on the machine where Administration Services Console is installed.
Select the Overwrite option. You selection to overwrite the contents of error files enables you to correct an outline and use the error file as a data source to load previously rejected records.