Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

what is substitution  Variables & Where do you use them?

Posted on 2009-07-08
3
Medium Priority
?
1,309 Views
Last Modified: 2012-05-07
what is substitution  Variables & Where do you use them?
0
Comment
Question by:AJITPADHY
  • 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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…
How to increase the row limit in Jasper Server.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

886 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