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.