Types of queries in Integrated Operational Planning:
MDX (Multidimensional Expressions)—Uses standard MDX and Integrated Operational Planning extensions to query multidimensional cubes. MDX queries return subsets of the base data or scenario data in the Integrated Operational Planning database.
Overlay—Uses Integrated Operational Planning tools in Excel to create a planning worksheet layout. The layout sets the level to which a dimension hierarchy or list of measures is expanded or collapsed and focuses the view to display specific measures and dimension members.
RSQL (Row Source Structured Query Language)—Uses SQL to return row source data. Row source data is transactional, component-level data (for example, sales order details) loaded into relational tables in the Integrated Operational Planning database from an execution database.
Select an option from the menu at the top right of the Queries screen to define the type of queries to display.