To populate the query fields on all entities in a model version, group or schema, right click on it in the tree (or right click in the diagram) and select Model>Populate entity queries.
The following dialog will be shown. Select an option and click Next.
Note
The options Populate DW queries and Delete all DW queries only display if DW queries are enabled in this category.
Populate Queries
If you selected Populate queries the following dialog is displayed.
- Enter the following details:
Fields
Description
Populate
Select whether you want to ignore or overwrite existing queries from the drop-down list.
Template
Select a template from the drop-down list. The Default Template option will use the template that is set on the entity; otherwise, when there is no template set on the entity, the default provided data or DW template will be used.
Force chosen template
Select this checkbox to override any templates set on the entity with the template selected above. The checkbox is enabled if a template other than the default template is selected.
Show report
Select to display a report of the changes made and any errors.
- Click Next > to populate the entities' query fields.
Note
Any data transformations stored on the table is included in the generated query, refer to Entering a Transformation for an Entity for details.
Delete all Queries
If you selected Delete all Queries you are asked to confirm your choice. Clicking OK clears all entities' query fields.
Populate DW Queries
If you selected Populate DW queries the following pane is shown.
- Enter the following details:
Fields
Description
Populate
Select whether you want to ignore or overwrite existing queries from the drop-down list.
Template
Select a template from the drop-down list. The Default Template option will use the template that is set on the entity; otherwise, when there is no template set on the entity, the default provided data or DW template will be used.
Force chosen template
Select this checkbox to override any templates set on the entity with the template selected above. The checkbox is enabled if a template other than the default template is selected.
Encapsulate fully qualified name
Enter characters in these text fields to be used to encapsulate database, schema, entity, and attribute names in the query.
Copy WHERE clauses from query tab
Select this checkbox to copy the clauses from the query to the DW query, so when an entity already has a query defined, any WHERE, GROUP BY and ORDER BY clauses of that query is added to the generated DW query.
Show report
Select to display a report of the changes made and any errors.
- Click Next > to populate the entities' DW query fields.
Delete all DW Queries
If you selected Delete all DW queries you will be asked to confirm your choice. Clicking OK clears all entities' DW query fields.