Member creation using Generation-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 Generations :- Click Here!!!

Loading our metadata using Generation reference method via Rule file-

Prepare the data as shown in figure in a notepad.
First column indicates the Generation 1 members , second 
indicates the Generation 2 and so on.
Note-It's not necessary to write Gen1 , Gen2 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 Generation 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 -
For the 1 generation select Ignore field option at the very bottom during
    dimension building as we have already defined it.
Click on next 

 1.select dimension name you want to add the members
 2.In field select the type of member in our case it's generation for all columns
 3.Number indicates the generation 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 Generation reference.

SHARE

Shubu

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