Data Model Manager

Within the Materialized Data Manager, use the data model manager to manage data models and set model security. Users do not have rights to manipulate any details of the models unless they added the model themselves to the system.

Using the Data Model Manager

Use the server tree on the left (blue box below) to find and select the data model you wish to manage. You can use the drop down to filter the data source type and quick search to find items by name.


Once you have the model selected, you'll see the following items on the general tab.

General information: (red highlight)
  • Created by: view the user that created the data model
  • Create Date: the date the data model was initially created
  • Last Processed Date: the date the data model was last processed
  • Description: any description added by the designer.
Process Actions (green highlight)

In this section you can reprocess the data model.

  • Process Type: Before clicking the Process button, select to re-execute all the data flow and data model steps select "Master Flow" . Otherwise select "Model Only" to reprocess the data model without the data flow and manipulation processing.
  • Process Now: runs the reprocessing immediately by adding it to the queue.
  • Schedule Processing: setups a schedule to reprocess the model.
Model Management (orange highlight)
  • Save as: choose this option to extract and save the definition of the materialized data model, and its ETL to the content system. This is useful if the data model's ETL was deleted or if you wish to extract the latest definition.
  • Export: export the definition of the materialized data model and its ETL to a PIE file .
  • Delete: delete the materialized data model. Note that the underlying database will not be deleted.

When finished, click Apply to save your selections.

Use the two cache buttons at the bottom to clear the current metadata cache or the query for the specific model immediately.


For the selected data model, select the Security tab to manage access to this model by role.

  • Select the roles that should be assigned to the data model.
    • Read: users will be able to query the data model
    • Write: user will be able to change the specific data model using the data modeling tools