?
Solved

what is substitution  Variables & Where do you use them?

Posted on 2009-07-08
3
Medium Priority
?
1,306 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 1500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I 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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

719 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