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 will also be created. When the page file reaches 2 GB, it creates another file 

, and so on. Same with the 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 a rules file

2. Free-form data loading

3. Through Excel Lock and send (or through analyzer