Member creation using level reference via Rule file in Essbase - Hyperion

Before proceeding you should be clear with what exactly is rules file :-Check this to know more about rules file

Go through this document to know more about Levels :- Click Here!!!

Loading our metadata using Level reference method via Rule file-

Prepare the data as shown in figure in a notepad.
First column indicates the Level 0 members , second indicates 
level 2 members and so on.
Note-It's not necessary to write Lvl0 , Lvl1 and so on as shown
in our textfile.It's only for our reference.We will be ignoring
first row while loading metadata.
You can use any delimiter like tab,comma,spaces,etc. In our case we have used tabspacing.

Create a rule file and load our text file to define the rules for builing.

Setting Source properties :-

        We need to manage our source data properly. Various thing needs to be taken into consideration.

Click on the data source properties as shown in the below figure.

In the designer section specify the delimiter you used in your text file.

In header section mention the lines(rows) you want to skip.

Now click on the Dimension build icon.
In that go to dimension build settings.
In build method, mention the method you are using.
In our case select Level reference.

Now go to Field properties icon to define rule for each column of our textfile

Blue mark in the table shows the column we are working on
Right now we are at the first column

In  the field defination -
 1.select dimension name you want to add the members
 2.In field select the type of member in our case it's level for all columns
 3.Number indicates the level number, give the appropriate number.
Click on next 

Marker will correspond to next column.
Again select the dimension and appropriate field and number(generation number).

Repeat this procedure for all columns.

and click on ok.

Save your rule file.
So we are done with creation of rule file.

Check the header of each column. You will notice the changes that took place.

Loading the members i.e. data file with the help of rule file to add members to our application.

Here we are...............

So here we have successfully completed loading members using Level reference.

SHARE

Shubu

Hi. I’I hope this post was helpful for you.