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.
HTH
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.
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.
This will help me with the re-create procedures which I find very tedious. Hopefully, I can execute one without fault.
Please let me know how it went, if any issues are there I can try to correct the utility.
It worked very well for our migration from 9.3 to 11.1.2.1. Point to mention is that value of var got cut off after character number 18, that a few of them needed to be modified and the double quotes "" got removed.
Best regards from Switzerland and greetings from Tim G – our consultant in the project.
Bernd
Hi Bernd
Thank you for the update, can you send me the filter line which caused the issue. I can try and fix that in the code.
Convey my regards to Tim G, you got a very good consultant there 🙂
Hi Celvin,
I am unable to unzip the Essbase_Subvar_Export.zip file. It says it is invalid. Can you help?
Thanks,
Sukanya
Hi Sukanya
I've added a separate link to download the zip file.
Thanks Celvin. I was able to run the .bat file. However I have a question here. It listed all the variables only for one particular application & database. There are a few other substitution variables defined in our system for "all apps" & "all dbs". How can I get them to be listed on the reprot as well?
Hi Sukanya
Please download the excel file again. Also please clear the values in Application and Database from the readme sheet and it'll list all the variables. More clarification read the readme
We are using Hyperion Planning 11.1.22, would this work for us too?
@tiffany it should work fine. Let me know if it is not.