Essbase - Delimiters

Essbase Overview

About

A file delimiter is the character (or characters) used to separate fields in the data source.

Essbase Data Source Record Fields

Valid Delimiters

You must separate fields from each other with delimiters.

With a rule file

Essbase Delimiter Data Source Properties

By default, a rules file expects fields to be separated by tabs.

If you are using a Essbase - Rules File, delimiters can be any of the following:

  • Tabs (default)
  • Spaces
  • New lines
  • Carriage returns
  • Commas
  • Fixed-width column
  • Custom value.

Acceptable custom values are characters in the standard ASCII character set, numbered from 0 through 127.

You can set them with the Essbase - Data Prep Editor in the data source properties option of the tool menu.

Without a rule file

If you are loading data without a Essbase - Rules File, you must use spaces to delimit fields.

Extra Delimiter

One more … ?

With a rule file

In data sources that are loaded with a rules file, Essbase reads extra delimiters as empty fields. For example, if you try to use a rules file to load the file below into the Sample.Basic database, the load fails. Essbase reads the extra comma between East and Cola in the first record as an extra field. Essbase then puts Cola into Field 3. In the next record, however, Cola is in Field 2. Essbase expects Cola to be in Field 3 and stops the data load.

East,,Cola,Actual,Jan,Sales,10
East,Cola,Actual,Feb,Sales,21
East,Cola,Actual,Mar,Sales,30

To resolve the problem, delete the extra delimiter from the data source.

Without a rule file

In data sources that are loaded without a rules file, Essbase ignores extra delimiters. In the following example, the fields are separated by spaces. Essbase ignores the extra spaces between the fields.

East   Cola   Actual   Jan   Sales   10
East   Cola   Actual   Feb   Sales   21
East   Cola   Actual   Mar   Sales   30





Discover More
Essbase Data Source Record Fields
Essbase - Data Source

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...
Essbase Dimension Build Rules Files
Essbase - Dimension build rules files

When you create dimension with thousands of member or with many alternate hierarchy, you want to automate the process to add the member. You use Dimension build rules files to map dimension and member...
Essbase Data Source Kinds Of Fields
Essbase - Essbase-friendly/free-form Data Sources (Don't Need a Rules File during data load)

If a contains all of the information required to load the data values in it into the database, you can load the data source directly in afree-form data load (without rule file) To load a data value successfully,...



Share this page:
Follow us:
Task Runner