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

Technology Partners: 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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hello, In my precious Article  ( saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL ( and MongoDB (…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor ( Top Charts is a view in which you can set seve…

728 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