About Calculating Data in Essbase

Data source types: Oracle Analytics Cloud - 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.

• 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.

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

• 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, Calculating Cubes

      Using Oracle Analytics Cloud - Essbase, Analyzing and Moving Data with MDX

      Technical Reference for Oracle Analytics Cloud - Essbase, MDX

    • Essbase on-premises:

      Administering Oracle Analytics Cloud - Essbase, "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.