Data Load Dialog Box

Execute in background check box

Executes the data load or dimension build in the background so that you can work as the load or build processes. When you run a process in the background, you can exit the console but you cannot shut down Administration Server until the process is completed. After you execute a load or build in the background, you can check its status in the Background Process Status window.

You cannot execute a data load and a dimension build in the background from the same data file at the same time.

Deferred-restructure dimension build check box

Select this check box to perform a deferred-restructure dimension build, also known as an incremental dimension build. A deferred-restructure dimension build reads the data sources listed in this dialog box for dimension builds and delays restructuring until all data sources have been processed. The data sources are processed in the order in which they are listed in the dialog box.

Deferred-restructure dimension builds in Administration Services verify the outline after each data source is processed.

This check box is available only if Build only is selected from the Mode drop-down list.

Data load values drop-down list

Select one of the following options to determine how values are loaded:

Ignore missing values check box

Ignores missing values in the data source.

Ignore zero values check box

Ignores zero values in the data source.

Create new slice check box

Creates a new slice when committing the data to the database.

Aggregate use last check box

Loads data with the MaxL aggregate_use_last option.

Data Source Type column

Click in this column to select one of the following data source types to use to load data or build dimensions:

Mode column

Click in this column to select to set the mode for the data load or dimension build.

Data Source column

Displays selected data files. To select a data file, click in this column and then click the Find Data File button.

Rules File column

Displays selected rules files. To select a rules file, click in this column and then click the Find Rules File button.

Abort on Error column

Select the check box in this column to stops the data load if an error occurs. This option is available only if you are loading data.  

Error File column

After you have selected a data source and rules file, you can click in this column to specify the full path to the file where Essbase should write errors. If no location is specified, errors are written to aaspath\client\dataload.err on the machine where Administration Services Console is running.

This column is not available when the following options are selected:

Overwrite column

Select the check box in this column to overwrite the contents of an existing error file. This enables you to correct the outline and use the error file as a data source to load the earlier rejected records.

This column is not available when the following options are selected:

SQL User Name column

Click in this column to enter your user name on the SQL database. This column is available only if you selected SQL in the Data Source Type column.

SQL Password column

Click in this column to enter your password on the SQL database. This column is available only if you selected SQL in the Data Source Type column.

Find Data File button

Select a row in the table and then click this button to locate a data source to use to perform a data load or dimension build.

If you are performing a dimension build, and if you are using a data source that is saved on Essbase Server, the data source must be stored in the same database directory as the database to which you are loading data. To use a data source that is stored in a different location, use the File System tab to locate the data source.

Find Rules File button

Select a row in the table and then click this button to locate a rules file to use with the data source to perform a data load or dimension build.

If you are performing a dimension build, and if you are using a rules file that is saved on Essbase Server, the rules file must be stored in the same database directory as the database to which you are loading data. To use a rules file that is stored in a different location, use the File System tab to locate the file.

Insert button

Click this button to insert a new row in the table that contains most selections from the previous row as defaults.

Delete button

Click this button to delete the selected row(s) from the table.

Open button

Click this button to populate the data sources table with information from a previous data load/dimension build. The information is stored in an XML file on the client file system. See Save button.

Save button

Click this button to save the current information in the data sources table to an XML file on the client file system. If you perform data loads and dimension builds and you use the same data source files and rules files each time, you can save the source and rules file options specified in this dialog box and reuse them later.

By default, the file options are saved in the ARBORPATH directory on the client in an XML file that you name. When you want to use a file of saved options, you can open the file by clicking the Open button. The saved files and their options are added to the list in the currently open in this dialog box.