Create Essbase substitution Variables from ESSBASE.SEC file!!!! 9

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.

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

9 thoughts on “Create Essbase substitution Variables from ESSBASE.SEC file!!!!