An Essbase database contains dimensions, members, and data values.
You can use data sources and rules files to add dimensions and members to databases. This process is called dimension building. Also, in Outline Editor, you can use dimension build rules files to update outlines and add dimensions and members dynamically.
You can use data sources, such as spreadsheets and SQL databases, to add data values to databases. This process is called data loading. You need rules files to load data from data sources that are not perfectly formatted.
To add data or dimensions and members to an Essbase database:
If necessary, set up the data source. For information about setting up the data source, see the Oracle Essbase Database Administrator's Guide.
If necessary, set up the data load or dimension build rules file.
“Understanding Data Loading and Dimension Building” in the Oracle Essbase Database Administrator's Guide
“Creating Rules Files” in the Oracle Essbase Database Administrator's Guide