About Calculating Data in Essbase

Cloud data source types: Oracle Analytics Cloud - Essbase

On-premises data source types: Oracle Essbase

In Oracle Smart View for Office, you can use a calculation script to calculate a database in Essbase or Oracle Analytics Cloud - Essbase. 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.

• Oracle Analytics Cloud - Essbase only:

  • Detailed tracing information can be provided upon execution of an Essbase calculation script. The tracing information is displayed only if your Oracle Analytics Cloud - 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.

    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 Manage and Execute Queries dialog to execute multiple MDX queries at once. Instead, use 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 .

    • Oracle Analytics Cloud - Essbase:

      Using Oracle Analytics Cloud - Essbase, Calculate Cubes

      Using Oracle Analytics Cloud - Essbase, Analyze and Move Data with MDX

      Technical Reference for Oracle Analytics Cloud - Essbase, MDX

      For Oracle Analytics Cloud - Essbase documentation, go to the Oracle Help Center here:

      https://docs.oracle.com/en/cloud/paas/analytics-cloud/books.html

    • Essbase on-premises:

      Oracle Essbase Database Administrator's Guide, "Calculating Data" chapter

      Oracle Essbase Technical Reference, "MDX" chapter

      Find your Essbase version on the Oracle Help Center here:

      https://docs.oracle.com/en/applications/enterprise-performance-management/index.html

  • Oracle Analytics Cloud - Essbase: To define Essbase calculation scripts so that Smart View users can work with runtime prompts, refer to Oracle Cloud Designing and Maintaining Essbase Cubes, Using Runtime Substitution Variables in Calculation Scripts Run in Smart View.

  • For information on writing scripts for to calculate asymmetric regions in a database, see the Oracle Analytics Cloud - Essbase documentation.