About Calculating Data in Essbase

Data source types: Oracle Essbase

In Oracle Smart View for Office, you can use a calculation script to calculate a database in Oracle Essbase on-premises or cloud. Calculation script types can be Essbase or MDX.

Additionally:

• Essbase and MDX calculation scripts are created by your Essbase administrator for your specific system.

• When launched, Essbase and MDX calculation scripts can prompt you to enter variable information, called runtime prompts.

• Essbase and MDX calculation scripts are supported for aggregate storage and block storage databases.

• MDX calculation scripts can contain multiple MDX queries.

• To change the solve order of a member POV before running a calculation, see Changing the Solve Order of a Selected POV.

• Essbase cloud only:

  • Detailed tracing information can be provided upon execution of an Essbase calculation script. The tracing information is displayed only if your Oracle Essbase administrator has configured the calculation script for tracing.

  • You can run calculations on asymmetric grids. To do this, your administrator must first prepare calculation scripts that specify selected tuples to calculate. See Calculating Asymmetric Grids Using Tuples.

• Administrators:

  • Do not use the Smart View Manage and Execute Queries dialog to execute multiple MDX queries at once. Instead, select an MDX script and run it from the Calculation Scripts dialog.

  • Refer to the following guides for information on writing Essbase and MDX calculation scripts:

    • Using Oracle Essbase, Calculate Cubes

    • Using Oracle Essbase, Analyze and Manage Data with MDX

    • Calculation and Query Reference for Oracle Essbase, MDX

    For Essbase 21c and 19c documentation, go to the Oracle Help Center here:

    https://docs.oracle.com/en/database/other-databases/essbase/index.html

  • Essbase cloud: To define Essbase calculation scripts so that Smart View users can work with runtime prompts, refer to Database Administrator's Guide for Oracle Essbase, Using Runtime Substitution Variables in Calculation Scripts Run in Smart View .

  • For information on writing scripts to calculate asymmetric regions in a database, see Calculate Selected Tuples in Using Oracle Essbase.