A data source is external data that is loaded into an database with the help of one this two process :
Data sources contain the information that you want to load into the Essbase database. A data source can contain:
Essbase supports the following types of data sources:
A data source comprises records, fields, field delimiters, formatting Characters
Essbase reads data sources starting with the first record at the top and proceeding from left to right.
Essbase views some characters in the data source as formatting characters only. Essbase ignores the characters listed in the table below :
Character | Description |
---|---|
== | Multiple equal signs, such as for double underlining |
– | Multiple minus signs, such as for single underlining |
_ _ | Multiple underscores |
== | Multiple IBM PC graphic double underlines (ASCII character 205) |
_ _ | Multiple IBM PC graphic single underlines (ASCII character 196) |
Ignored fields do not affect the data load or dimension build.
For example, Essbase ignores the equal signs in the following data source and loads the other fields normally.
East Actual "100-10"
Sales Marketing
===== =========
Jan 10 8
Feb 21 16