Databases Reference
In-Depth Information
Click on
Options
and click on
Associate
outline
or click on the
Associate
button in
the
Data Prep Editor
.
Step 3: Open data load file or the SQL data
source file
To update the database outline using the rules file, we need to have a data source
file. To build a rules file, we need to acquire an exact representative sample of the
actual data in order to map the data to our Essbase database outline.
The data sources can be files like text (
.txt
) files, Microsoft Excel spreadsheets,
or from relational database sources using a SQL query defined in the load rule.
To open a data source file or SQL data source in EAS, with the
Data Prep Editor
open.
After you've clicked on
File
, you should see the options
Open data file
or
Open SQL
shown as follows: