Query and Data Model Sections—EPM Workspace Limitations

Interactive Reporting functions related to query and data model sections that EPM Workspace does not support:

Access to data model sections from the user interface (Sections can be accessed through the object model.)
Programmatic application of variable filters (Filters can be applied non-programmatically.)
Query canceling
Query log and custom SQL options
Addition of subqueries
Creation of local result tables or derived queries (Local results and derived queries can be displayed.)
Creation of union queries

Ways in which Interactive Reporting functions related to query and data model sections behave differently in EPM Workspace.

For Interactive Reporting documents that contain union queries, the first query is displayed. For union queries, the request and filter panes in data layout are read-only, and there is no union controller line.
Subqueries are indented in the Sections pane but displayed as regular queries in the content area.
For queries that contain multiple join paths, EPM Workspace defaults to the first join path.

Users cannot open Interactive Reporting document (BQY) in EPM Workspace bthat contains only a data model section.