Databases Reference
In-Depth Information
In this screenshot, the upper screen frame shows the data source file in its original
form. The lower screen frame shows how Essbase will interpret the data before
it gets loaded into your Essbase database.
In the example above, we discussed updating the outline from the input data
source file. In the next chapter, we will talk about how to import data using
the second method which is directly loaded from the RDBMS SQL Data Source.
Step 4: Set the Data Source Properties
While plenty of your data will be entered manually from user interaction, a good
deal of it will likely come from external systems. Before Essbase can process any
data file, we need to define the data to Essbase in the rules file.
Is the data in a comma separated file or tab delimited file? For some feeds, we need
to ignore the header records which are usually the first row in the input file. These
settings can be set in the
Data Source Properties
.
Delimiter
: Data delimiters are used to separate individual fields in the data source.
The types of delimiters available in Essbase are given as follows:
•
Comma
: This is for a comma separated data source file.
•
Tab
: This is for a tab delimited data source file.
•
All spaces
: The fields will be delimited by empty white spaces.
•
Custom
: The common delimiter which is agreed with the source systems.
For example, colon (:) or any other single character.
•
Column width
: The data columns have specific widths. For example,
the rules file will separate the data into columns based on all columns
being ten characters in width.
To open an input data source file in EAS, with the
Data Prep Editor
open:
1. Click on
Options
, and then click on the
Data Source Properties
.
2. The first tab is the
Delimiter
tab as shown in the following screenshot:
