Loading Data using Rules file, Free form method, Excel lock& send methods.

                   

                                        LOADING DATA INTO ESSBASE DATABASE

To load data into the database, we must build all dimensions first. The data will be loaded into a 

page file and indexes also will get created. When page file reaches 2 GB, it creates another file 

and so on. Same with index file. The files are created in the following path.

ARBORPATH/APP/app-name/db-name/ESS00001.PAG

ARBORPATH/APP/app-name/db-name/ESS00001.IND

Loading data can be done using any of the following methods.

1. Loading data using rules file

2. Free form data loading

3. Through excel lock and send (or through analyzer