Essbase - Rules File

Essbase Overview


A rules files tells Essbase what changes to make to :

during :

You have then two type of rules files :

For the operation: You use the rule file: To:
data load Data load rules files load the data
dimension build Dimension build rules files automate the creation (or building) / updating of an outline : dimension and members

One rules file can be used for both.

Rules File

Rules are stored in rules files. A rules file defines which build method to use, whether data values or members are sorted or are in random order, and how to transform data values or members before loading them.

It is best to create a separate rules file for each dimension.

Essbase reads the data values or members in the data source, changes them based on the rules in the rules file, and loads the changed data values into the database and the changed members into the outline.

Although, you can load data to a database without using rules files, you must use them when you want to use an external data source to update dimension and member.

Rules files are split into :

  • a raw data frame
  • and a rules frame

You can use a single rules file :

that requires the same set of rules

Rules files have a .rul extension and can be edited with Essbase - Data Prep Editor


Essbase Rules File

For example, using rules files, you can :

  • Ignore certain fields in the data source
  • Manage header information (for example, ignore extraneous header)
  • Change the order of fields by moving, joining, splitting or creating fields
  • Format Essbase - Members names
  • Scale data values
  • Create accept-or-reject criteria for records

Creation of a simple rules file

  1. Open a sample data_source with a data files or SQL data sources
  2. Define field header
  3. Validate the rules files

Copying Rules Files

You can copy rules files to applications and databases on any Essbase Server, according to your permissions. You can also copy rules files across servers as part of application migration.

Tool Topic Location
Administration Services Console Copying a Rules File Oracle Essbase Administration Services Online Help
MaxL alter object Oracle Essbase Technical Reference
ESSCMD COPYOBJECT Oracle Essbase Technical Reference

Printing Rules Files

You can print the entire contents and properties of a data load or dimension build rules file. You can also specify properties and settings to print.

Documentation / Reference

Discover More
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 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 - Database (cube)

An Essbase database is a data repository that contains a multidimensional data storage array. Essbase Database is also commonly referred to as cube (as in Essbase Studio console) Files that are related...
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...
Essbase Data Source Kinds Of Fields
Essbase - Dimension Field

Dimension Field is a component of a which can contain also : , Dimension fields identify the dimensions of the database, such as Market. Use dimension fields to tell Essbase the order of the...
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 Overview
Essbase - Outline Creation and Management using Outline Editor

This article provides an overview of creating outline using Outline Editor. For information Outline Editor, see the Oracle Essbase Administration Services Online Help. All examples in this chapter are...
Essbase Overview
Essbase - Rules file used for data loads and/or dimension builds ?

Before building a rules file, you must decide whether the rules file will be used for : data load and dimension build, or for only data load, or for only dimension build. Use the same rules...

Share this page:
Follow us:
Task Runner