More insight on Data load to essbase cube using rule file

Summary

More insight on Data load to essbase cube using rule file

Content

Hi,

I created a dimension build rule file and built an outline. Below is the file i should use to build dimension and load data as well.

 

Account,Year,Country,State,city,street,Description,Value

0558,2016,India,Kar, Blore ,, XYZ, 213

0559,2016,India,Tam, chen ,brigade, PQR, 216

 

I have created a dimension build rule file to add as child-of  method to build Account,Year,Descripton and genration reference to build location.

My outline looks like this after build process:

 

Account

  >0558

  >0559

Loaction

  >India (Gen2)*

     >Kar (Gen3)*

        >Blore (Gen4)*

     >Tam (Gen3)*

         >chen (Gen4)*