Solved

what is substitution  Variables & Where do you use them?

Posted on 2009-07-08
3
1,295 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 500 total points
Comment Utility
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
Comment Utility
thanks
0
 

Author Comment

by:AJITPADHY
Comment Utility
thanks
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

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…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now