What is a Rules File :-
A rules files tells Essbase what changes to make to :
- the data source to load
- the outline to build
- a data load
- a dimension build.
You have then two type of rules files :
We use 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 a best practice 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.
You can use a single rules file :
Rules files have a .rul extension and can be edited with Essbase - Data Prep Editor.
We use Rules file
- to load the data
- automate the creation (or building) / updating of an outline(dimension and members)
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 a best practice 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.
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.
0 comments:
Post a Comment