Essbase - Data Source

About

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:

Supported Data Sources

Essbase supports the following types of data sources:

Items in a Data Source

A data source comprises records, fields, field delimiters, formatting Characters

  • A record is a structured row of related fields.
  • A field is an individual value.
  • A delimiter indicates that a field is complete and that the next character in the record starts another field.

Essbase reads data sources starting with the first record at the top and proceeding from left to right.

Formatting Characters

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

Documentation / Reference


Powered by ComboStrap