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.
