Creating a Data Load Rules File

Data load rules files tell Essbase how to handle data-source values that are loaded into Essbase databases.

  To create data load rules files:

1. Create a rules file.

2. Set file delimiters for the data source.

3. If necessary, set record, field, and data operations to modify data-source values during loading.

4. Validate the rules file.

5. Save the rules file.

Note:

If Administration Services is running under UNIX, data loads from .XLS files are not supported.

Note:

You need not set file delimiters for SQL data. File delimiters set for SQL data are ignored.

Related Information

• “Creating Rules Files” in the Oracle Essbase Database Administrator's Guide

• Setting Field Types (Loading Data)

• About Data Prep Editor