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: