About Working with MDX Queries

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