1. User's Guide
  2. Query Designer and MDX Queries
  3. Working with MDX Queries
  4. Executing MDX Queries

Executing MDX Queries

You can execute saved MDX queries or instantly execute a query you have just entered.

To execute an MDX query:
  1. In Excel, connect to an Oracle Essbase data source.
  2. From the Essbase ribbon, select Manage and Execute Queries to display the Manage and Execute Queries dialog box.

    Figure 21-4 Manage and Execute Queries Dialog Box


    Manage and Execute Queries dialog box. In the left text box, the first query in the list is selected by default. In the right text box, the query syntax associated with the selected query is displayed.
  3. Perform an action:

    • To execute a saved MDX query, select the query from the list in the left frame and click Execute.

    • To execute an MDX query dynamically, click Add Query, type the MDX query in the text box at the right, and click Execute.

      The query you enter dynamically will not be saved.

    The dialog box closes automatically and the query results appear on the sheet.

Note:

When executing an MDX query with a calculated member (WITH MEMBER...) in Excel, the calculated values appear successfully, but, if the grid is refreshed, then the column is converted to a comment column and all calculated values are lost. This occurs whether you are using the Execute MDX command in the Essbase ribbon, or the VBA function, HypMDXExecute.