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.

Migrate Substitution Variables

We can migrate substitution variables from one environment to another by using the EAS console. Say for example, that you want to copy substitution variables from Development to Production environment.

These are the steps that you can follow:

1         Log in to EAS.
2.       On the navigation panel, expand Enterprise View > Essbase Servers > Server_name (for example EssbaseCluster-1, or whatever server name you have).
3.       Right-click the Server > Edit > Variables.
4.       On the right, you will see a list of all the Substitution variables in the environment. You can see columns – Application, database, variable, Value.
5.       Choose the one(s) that you would like to migrate. You can make use or CTRL / SHFT key to make multiple selection.
6.       Click the “COPY” tab.
7.       A “Copy Substitution Variables” window pops open.
8.       Choose the following

a.       Under Essbase Server, choose the target Server from the drop-down.

b.      Under Application, choose application from the drop-down.

c.       Under Database, choose database from the drop-down.

d.      You can see check boxes under the “COPY” column.

e.      Check the ones that you want to COPY.

f.        Check the “Overwrite existing variables” check box if you want to overwrite the existing variables.

g.       Click OK.

h.      You are all set. Check and verify that the variables have migrated and are available in the target environment.