Essbase - Data Source

1 - 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:

3 - Supported Data Sources

Essbase supports the following types of data sources:

  • Text files (flat files) from text backups or external sources (named data_files)
  • External databases, such as SQL data sources (using a SQL query defined in the load rule)
  • Essbase export files (export files do not need a rules file to load)
  • Microsoft Excel spreadsheet files
  • Spreadsheet audit log files (Error files generated by Essbase during a data load or dimension build)
  • Oracle BI Enterprise Edition (dat:obiee)

4 - 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.

4.1 - 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

5 - Documentation / Reference

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap