About Working with MDX Queries

Cloud data source types: Oracle Essbase

On-premises data source types: Oracle Essbase

MDX users can bypass the Query Designer interface and create and manage MDX query commands using the Manage and Execute Queries dialog box.

In Manage and Execute Queries, you can perform the following tasks:

• Create a query

• Modify an existing query

• Save a query

• Modify a query's connection information

• Delete a query

• Execute a query

  You can execute one MDX statement per query.

  To execute multiple MDX queries at once, Essbase must create an MDX script, described in the Oracle Essbase Technical Reference. Oracle Smart View for Office users then run the script from the Calculation Scripts dialog, as described in Running Essbase Calculations.