what is substitution  Variables & Where do you use them?

Posted on 2009-07-08
Last Modified: 2012-05-07
what is substitution  Variables & Where do you use them?
Question by:AJITPADHY
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

garycris earned 500 total points
ID: 24803570
Substitution variables are global placeholders for regularly changing information. Because changes to a variable value are reflected everywhere the variable is used, manual changes are reduced.

For example, many reports depend on reporting periods; if you generate a report based on the current month, you must update the report script manually every month. With a substitution variable, such as CurMnth, set on the server, you can change the assigned value each month to the appropriate time period. When you use the variable name in a report script, the information is dynamically updated when you run the final report.

You can use substitution variables with both aggregate storage and block storage applications in the following areas:


      Aggregate storage outline formulas


      Block storage outline formulas


      Calculation scripts (block storage databases only)


      Report scripts


      Data load rules file header definitions and field definitions. You can enter variable names for dimension and member names.


      Partition definitions


      Data source name (DSN) specifications in rules files for SQL data sources


      SELECT, FROM, or WHERE clauses in rules files for SQL data sources


      Security filters


      MDX statements


      Spreadsheet Add-in.

You can set substitution variables on the Essbase Server using Administration Services, MaxL, or ESSCMD. Set the variable at any of the following levels:


      Essbase Serverproviding access to the variable from all applications and databases on the Essbase Server

      Applicationproviding access to the variable from all databases within the application

      Databaseproviding access to the variable within the specified database

For further details, see the database administrators guide

Author Closing Comment

ID: 31600992

Author Comment

ID: 24825449

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Using a Sum as a group header 5 106
SSRS Expression 13 94
Crystal reports highlight Y axis label 1 89
SSRS show background behind table 5 67
Hi, In my previous Article  ( discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit If you want to manage em…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question