Essbase Metadata Load

 Metadata is defined as data about data. Metadata is a record of all information of database. Suppose in relational database you have tables and their properties. Relational database has Columns and every column has their attributes like data type and size. Metadata for multidimensional database is information of database type, number of dimension and dimension properties.

Metadata Load through Rule File

1. Generation Reference
2. Level Reference
3. Parent Child
4. Add alias through rule file
5. Rejecting Metadata
6. Metadata load with Consolidation property
7. Metadata load with member formula
8. Metadata load with select and reject property
9. Metadata load through RDBMS
10. Metadata load with User Define Attribute

Generation Reference Method 

 
You need to build rule file to update outline structure in a particular field. You require a source file and one rule file which

Example:-
How to load new member in “Product” dimension?
Open the rule file.

First you should have one text file; there should be specific outline structure. This is the source file for generation reference.

 

Go to File >> New >> Rule File

Browse data file and open it on rule file.

Set delimiters as it in text file, it may be comma, Tab or All spaces. Through delimiters Essbase server understands difference between two fields.

Go to Field Properties and set field properties.

 

Select the dimension on which you want to update Metadata. Set field type as generation because when Metadata structure is in top to bottom level then use generation reference.

 There is number option where you need check generation level number or set generation in some case.

 “Dimension Build Setting” has meta data load methods.

Select right dimension and then select Use generation references in Build Method. If you select wrong build method you will have error at the time of Metadata load.
 

 

First validate all settings. If it shows warning or error you can correct.

 

Save the rule file, it will use while loading Metadata.

Now you have data text file rule file. To load metadata through rule file Right click on data base select “Load data” option.  Select loading Metadata mode will be Build only, because you are loading Metadata only. 

Browse and Select data file or source file then select respective rule file. Each rule file has one associated data file. 

Checks below information should correct path of data file and rule file.

 Click “OK”

This is final massage of Metadata load. If status is success then your Metadata load success fully . If it shows warning or error massage follow error massage shown in white panel.