About Calculating Data in Essbase

Cloud data source types: Oracle 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 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: