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 Analytics Cloud - Essbase data source.
2. From the Essbase ribbon, select Manage and Execute Queries to display the Manage and Execute Queries dialog box.

   Figure 11-4 Manage and Execute Queries Dialog Box

   
   
   
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.