Essbase - Data Load Rules Files

Essbase Overview

About

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 of the location to which Essbase should load the values: a data address that includes one member from every standard dimension in your outline.

In addition to mapping metadata in data source to your dimension, rules files enable you to transform data upon loading in the following way :

  • scale data
  • change the sign of data
  • Overwrite, add to, or subtract from existing data

Process for Creating Data Load Rules Files

To create a data load rules file:

  • Determine whether to use the same rules file for data loads and dimension builds.
  • Create a rules file.
  • Set the file delimiters for the data source.
  • Map each rules file field to the data source and define field properties.
  • If necessary, set record, field, and data operations to change the data in the data source during loading.
  • Validate and save the rules file.

Defining Data Load Field Properties

You must map each rules file field to the corresponding outline member, or as a data field or ignored field. Other field characteristics may also apply.

For duplicate member outlines, you must specify the method (level reference, generation reference, or parent-child reference) that Essbase uses to map the field.

  • Level and generation references: The data source contains multiple fields within the duplicate member dimension to uniquely identify duplicate members.
    • Use the level reference method when fields within a dimension are organized bottom-up in the data source.
    • Use the generation reference method when fields within a dimension are organized top-down in the data source. For example:
gen2,Market, gen3,Market, Product, Year, Measures, Scenario, *data*
            State,"New York","100-10",Jan,Sales,Actual,42
            City,"New York","100-20",Jan,Sales Actual,82
            State,Texas,"100-10",Jan,Sales,Actual,37

  • Dimension reference: If an outline contains a duplicate member name in different dimensions—for example, a member name such as Other can be meaningful in different dimensions—you can use the dimension reference method. When you set a field to use the dimension reference method, you also identify the dimension to which members in that field belong. When the dimension reference method is specified for a field, Essbase checks to ensure that members in the field belong to the dimension specified for the field.

Requirements for Valid Data Load Rules Files

For a data load rules file to validate, all of the following questions must be answered “yes.”

  • Is the rules file associated with the correct outline?
  • Does each record in the data source contain only one member from each dimension?
  • Are all member and dimension names spelled correctly?
  • Are all members surrounded by quotation marks if they contain numbers or file delimiters?
  • Are there no extra delimiters in the data source?
  • Is the member that each data field maps to spelled correctly in the rules file?
  • Are the file delimiters correctly placed?
  • Is the member in the field name a valid member?
  • Is the dimension name used in only one field (for example, not in a field name and the header)?

You can map a single data value to only one set of members.

  • Is only one field defined as a data field?
  • Is the Essbase - UDA used for sign flipping in the associated outline?





Discover More
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 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 - 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,...
Rules File
Essbase - Rules File

A rules files tells Essbase what changes to make to : the data source to load and the outline to build during : a data load or a dimension build. You have then two type of rules files : ...



Share this page:
Follow us:
Task Runner