I’m writing this entry, because I had to re-create all the substitution variables (more than 100) when they were lost.
There was an issue with our development Planning server (security was getting corrupted) and we were advised to re-create all the applications.
In the process somebody forgot to copy the Substitution variables and all the subvars were lost!!!!!
There were more than 100 substitution variables and we don’t have a clue what they were.
So how to get them back……
Luckily Essbase stores the substitution variable information in the SEC file. If you open essbase.sec file in an Editor you can see that it stores the user information, which cubes they can access, filters…and substitution variables.
You can find the subvar information after **** Substitution Variables: heading in the SEC file.
The information stored in the SEC file will be similar to the one shown below
We had a backup of essbase.sec file from previous night and I found out a way to add them back in Essbase. If you don’t want to add them manually in EAS console and if you like MaxL (like me :)) you can make use of the EXCEL file I created.
You can download the file here, with the help of this file you can recreate the Substitution variables with minimum effort.
You have to copy the values in SEC in a required format so that the MaxL can be generated. Read the instructions given in the EXCEL sheet.
If you have any queries please let me know.