Solved

what is substitution  Variables & Where do you use them?

Posted on 2009-07-08
3
1,303 Views
Last Modified: 2012-05-07
what is substitution  Variables & Where do you use them?
0
Comment
Question by:AJITPADHY
[X]
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
3 Comments
 
LVL 5

Accepted Solution

by:
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
http://download.oracle.com/docs/cd/E12825_01/epm.111/esb_dbag/frameset.htm?launch.htm
0
 

Author Closing Comment

by:AJITPADHY
ID: 31600992
thanks
0
 

Author Comment

by:AJITPADHY
ID: 24825449
thanks
0

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  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we 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 (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
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 (https://www.adremsoft.com/). 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