Creating and Saving an MDX Query

You can create an MDX query in the Manage and Execute Queries dialog box.

See the Oracle Essbase documentation for information on MDX syntax.

To create an MDX query:

1. In Excel, connect to an Essbase data source.
2. From the Essbase ribbon, select Manage and Execute Queries to display the Manage and Execute Queries dialog box.

   Figure 21-1 Manage and Execute Queries Dialog Box

   
   
   
3. Click Add Query and type a valid MDX statement in the text box at the right.

   For example:

   SELECT {[Sales], [Cogs]} on columns, Filter ([Product].Levels( 2 ).Members, AVG([Year].CHILDREN, 9001.0) > 9000.00) on rows

   Figure 21-2 MDX Query Syntax Entered in the Manage and Execute Queries Dialog Box

   
   
   
4. Click the Save Query button and, in the Save Query dialog box, enter a name and optional description for the query.

   The default name for queries is Query1 [n]. You can change this name.

   
   
   
5. Click Save to save the query.

   The newly-saved query is now listed in the left text box of the Manage and Execute Queries dialog box.

   Figure 21-3 Newly-Saved MDX Query Listed in the Manage and Execute Queries Dialog Box

   
   
   

   You may continue by executing this query or modifying the syntax or connection information.