what is substitution Variables & Where do you use them?

what is substitution  Variables & Where do you use them?
AJITPADHYIT operation leadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

garycrisCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AJITPADHYIT operation leadAuthor Commented:
thanks
0
AJITPADHYIT operation leadAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.