Essbase - Data Source

Essbase Overview


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.

Essbase Data Source Record Fields

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

Discover More
Essbase Overview
Essbase - (Dimension|Outline) Build

Building dimensions (known also as building outline) is the process of loading dimension and members data into an Essbase database outline by using a data source and a dimension build rules file. When...
Essbase Overview
Essbase - Artifacts/Objects

Files that are related to are called : artifacts or objects. Database artifacts perform actions against one or more Essbase databases, such as : defining or reporting against data. In...
Essbase Overview
Essbase - Build Method

The build method has to be choose to perform a dimension build. The build method that you select : depends on the type of data in the data source and determines the algorithm that Essbase uses...
Essbase Overview
Essbase - Data Load

Loading data is the process of adding data values to an database from a data source. If the data source is not perfectly formatted, you need a data load rules files to load the data values. You can load...
Essbase Data Load Rules Files
Essbase - Data Load Rules Files

Data Load Rules file is the second type of rules files which is involved in the data load process. A data source for data load must contain : not only the values that you want to load but also identification...
Essbase Rules File
Essbase - Data Prep Editor

Data prep editor permit to edit . When it open, the menu in the change. The upper screen frame shows the file in its original form. The lower screen frame shows how Essbase will interpret the data...
Essbase Data Source Kinds Of Fields
Essbase - Data fields

Data fields are a component of data source which contain also : , Either the data source or the rules file must contain enough information for Essbase to determine where to put each data value....
Essbase Overview
Essbase - Data files

Data files are data source file for Essbase You can with : open it : File > Open Data File define its properties : Options > Define property validate it : Options > Validate
Essbase Overview
Essbase - Dealing with Missing Fields in a Data Source during data load

Each record in the data source must have the same number of data value fields to perform a data load. If data values are missing, the data load processes incorrectly. For example, the following file is...
Essbase Data Source Record Fields
Essbase - Delimiters

A file delimiter is the character (or characters) used to separate fields in the data source. You must separate fields from each other with delimiters. By default, a rules file expects fields...

Share this page:
Follow us:
Task Runner