Databases Reference
In-Depth Information
What are we talking about? Why use an Essbase data load rules file? Because we
want to make input data Essbase-friendly, of course. Here are some the reasons
why we use data rule files:
• Automatically cleanse the input data to ilter out any errant values
• Remove the header and trailer from the input iles
• Reject invalid data records
• Concatenate two ields into one ield
• Dynamically add new members to the database outline
• Add aliases or update other member properties
• Transform or manipulate data
• Concatenate two ields or any other cleansing operations
• And many more
Data load rules files are something very special as you can see. You can practically
build a complete Essbase database outline from scratch using nothing more than
a properly configured data load rules file and your input data.
Next, we take you through the steps required to create a Dimension Build data
rules file.
Step 1: Start the Data Prep Editor
The
Data Prep Editor
is the tool with which you will create your custom Essbase
data load rules files. The tool is built right in to the already amazing Essbase
Administration Services tool.
1.
In EAS, click on the
File
menu pick.
2.
Select
Editors
and click on the
Data Prep Editor
or Click on
New
, on the
New
dialog go to the
Scripts
tab and select
Rules File
and click on
OK.
3.
The
Data Prep Editor
will open as shown in the following figure.
4.
The moment the
Data Prep Editor
is opened, the menu items in the EAS
will change.