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