MDX Queries

Data source types: Oracle Essbase

MDX users can bypass the Query Designer interface and enter MDX commands in the query sheet or in the Execute MDX dialog box.

To execute MDX queries:

  1. In Excel, connect to an Essbase data source.
  2. From the Essbase ribbon, select Query, then Execute MDX.
  3. In Execute Free Form MDX Query, enter the MDX query.

    For example:

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