Use the Insert New Query dialog box to select the master data model for a relational query. Additionally if the Interactive Reporting document file (BQY) contains a query associated with an Essbase data source, you can select the Interactive Reporting database connection file (.oce) .
Note: | If the Interactive Reporting document file (BQY) contains only a relational query and no master data model, the Insert New Query dialog box is not available. In the case where a Interactive Reporting document file (BQY) contains a relational query linked to a master data model, and an Interactive Reporting database connection file (oce) associated with a CubeQuery, all options on the Insert New Query dialog box are available. Note that master data models are not available for a multidimensional Interactive Reporting database connection file (.oce). |
To insert a new query with a master data model:
Select Actions, then Insert, and then Query.
The Insert New Query dialog box is displayed.
Check Master Datamodel and select the master data model to link to the query.
The master data model is a prebuilt, custom view of a database. The benefit of data models is that any changes to the master data model gets propagated to all dependent queries that are based on the master data model.