When you create a new Essbase application, one task that needs to be performed is creating substitution variables. This is usually done one at a time, selecting the application, selecting the database, entering the variable name and the corresponding value. This task gets really tedious when there are so many to add.
Additionally, one of the many tasks Essbase administrators perform on a routine basis is updating the Substitution Variable values. Many applications contain several variables and the task of updating them based on the upcoming cycle/month. The more variables there are, the more tedious this becomes as you manually edit them one by one.
An easy way to update the variables is by writing a MaxL script that creates or updated substitution variables. When creating the syntax for the MaxL script, remembering the syntax to use based on the variables parameter is often a head scratcher.
Remembering when to use “Alter System”, when to use “Alter Application”
Do you include the app name and database name with a period in between? How do you deal with a value with spaces like “Net Income” or even a member name that starts with a number? Wouldn’t it be nice if there was something that created the syntax needed? Many administrators I have talked to say they try to make their jobs easier by creating something, but time usually gets in the way.
Good news! We have a tool just for you. The Subvar Updater tool now generates a MaxL script based on a few inputs. The tool is an Excel spreadsheet that allows you to copy and paste and lighten your burden. You can update this tool each month then simply paste the syntax into the MaxL editor within the Essbase Administration Console and execute the script.
If the ability to generate a script to make your monthly update tasks easier is your cup of tea, click here to download a copy of the Subvar Updater Tool.
Want to meet us in person at KScope? Join us!