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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

627 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