Databases Reference
In-Depth Information
3. The first tab is the
Delimiter
tab.
4.
Select or create the appropriate data delimiter.
Step 6: Updating the Data Load Settings
With this load rule setting, you can tell Essbase how to load the new data into
the Essbase database and also, if necessary, how to load the new data in relation
to the data that already exists in the database. In some cases, you need to load on
a day-to-day basis. If there are adjustments to the data, how you will handle them?
In the rules file data load setting, you can tell Essbase how to load the data into
the Essbase cube, define the headers, flipping of the numeric signs, clear specific
data combinations, add to existing values, subtract from existing values, and so on.
Step 7: Setting the Data Load Values
To set the Data Load Values:
1. In EAS, open the
Data Prep Editor
.
2. Click on
Options
and then click on the
Data Load Setting
.
3. The first tab is the
Data Load Values
tab.
4.
There are three things that can be achieved in this tab setting:
Data values
,
Sign
lip
, and
Global select/reject Boolean
.