Export Substitution Variables from Essbase and Re-Create 10

This is also on the similar to the post about export filters from server and re-create.
I created an easier way to take an export of all substitution variables from Essbase server and re-create them as needed.


You can download the file from here. (If the embedded zip file is corrupted, please download the zip file from here.)


Steps to perform (please read the EXCEL instructions)


  • Download the zip file from EXCEL, extract the contents to C Drive (if you opt another location, please update it in the bat file)
  • Update Essbase user name, Password, Server Name in the bat file
  • Run the bat file, and this will extract the filters into a file called Essbase_Subvars.txt (in folder driveletter:Essbase_Subvar_Exportsubvars)
  • Copy the contents of this file to EXCEL, Click on convert text to column button.
    • If you want to re-create all substitution variables leave the highlighted area BLANK
    • If you want to re-create all  system level substitution variables enter Application Name & Database Name as SYSTEM
    • If you want to re-create all application level substitution variables enter Application Name in the cell provided and leave Database Name BLANK
    • If you want to re-create all database level substitution variables enter Application Name and Database Name in the cells provided
  • Click on Re-create Add Maxl to add the substitution variables which are not present in system, this will error-out for ones which are already present. This step is to make sure that all substitution variables are present before the “set” command.
  • Click on Re-create Set Maxl to set the variable values.

Sunday, March 18 2012

Update: Utility is updated to solve the issue where substitution variable values of more than 18 characters were not getting created.

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.

10 thoughts on “Export Substitution Variables from Essbase and Re-Create