A query may be promoted to a master data model. This essentially separates the data model from the query, enables multiple queries to be based on a single master data model, and creates a new data model-only section in the Interactive Reporting document file. Master data models do not contain Request lines.
The benefit is that any changes to the master data model get propagated to all dependent queries that are based on the master data model. Each time a new query is inserted into a Interactive Reporting document file that contains a master data model, you are prompted to link the new query to the master data model. When a query is promoted to a master data model, it is added to the Section pane as a new section. Once you promote a query to a master data model, you cannot undo it.
To promote a query to a master data model:
Select DataModel, then Promote to Master Data Model.
Data models in Query sections that are linked to the master data model are locked and cannot be changed. They display with a gray background and the message: “Locked Data Model.”
Note:
To keep the master data model locked for web users, deploy the Interactive Reporting document file in “Query and Analyze” mode and not in “Data Model” mode.