How to change Essbase INDEX and PAGING file location

When we create Essbase cube, the INDEX (.ind) and PAGING (.pag) files are by default created under the app-database directory. For example, if you have Essbase installed in “D” drive, and if I have an application.database named Khoonks.Nirmal, the INDEX and PAGING files would be located under \\servername\d$\HYPERION\ESSBASE\app\Khoonks\Nirmal.

The names of the files would be NIRMAL.IND and NIRMAL.PAG.

It is not a problem in the initial stages, however, as the database size keeps on increasing, it takes longer during database restructure, outline changes, calculations, etc. Therefore, it is a good idea to change the location of the INDEX and PAGING files.

This is how you can change the storage location. 

In this example, we are changing the location from “D” to “E” drive.

1             Export the database.

2             Clear ALL DATA.

3             Modify the database location.  

a.       Right-click the database -> Edit -> Properties. You will see DATABASE PROPERTIES dialog.

b.      Click on STORAGE tab.

c.       Under “DISK VOLUME” you will see text “Click here to add.” Click it.

d.      From the DROP-DOWN, choose E.

e.      Click “SET.” “APPLY” “CLOSE”

4            Restart the application.

5            Load data from the export you did in step 1.

6           Check the new STORAGE location by Right-clicking the database -> Edit -> Properties. You can see the     new file location – path like \\servername\e$\Hyperion\Essbase\APP\Khoonks\Nirmal

7            Agg the database.