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:
For example:
SELECT {[Sales], [Cogs]} on columns, Filter ([Product].Levels( 2 ).Members, AVG([Year].CHILDREN, 9001.0) > 9000.00) on rows
Scripting on this page enhances content navigation, but does not change the content in any way.