Essbase - Loading a Subset of Records from a Data Source

Essbase Overview


You can load a subset of records in a data source during a data load or a dimension build.

For example, you can load records 250 to 500 without loading the other records of the data source.

How to

To load a subset of records:

  • Using a text-editing tool, number the records in the data source.
  • Set the rules file to ignore the column containing the record number. See Ignoring Fields.
  • Define a rejection criterion that rejects all records except those that you want to load.

For example, reject all records for which the ignored column is fewer than 250 or greater than 500. See Rejecting Records.

You cannot reject more records than the error log can hold. By default, the limit is 1000. You can change the limit by setting DATAERRORLIMIT in the essbase.cfg file.

Discover More
Essbase Overview
Essbase - Checking Error Log

If a data load or dimension build fails, the error log can be a valuable debugging tool. See Understanding and Viewing...
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 Overview
Essbase - essbase.cfg config file

essbase.cfg is a configuration file. With the essbase.cfg configuration file, you can customize your Essbase Server configuration. Settings specified in the essbase.cfg file usually apply to the entire...

Share this page:
Follow us:
Task Runner