Assigning Entity Types

To assign table types within a model version...

1. Select a version in the tree and select REPLACE WITH THIS IMAGE: Images/Common_Icons/sphere.png Assign table types from the Workflow pane.The Assign table types dialog is displayed.
2. Click REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png to specify the tables to be included or excluded using SQL wild cards and click Next.

REPLACE WITH THIS IMAGE: Images/Wizards/Assigning Entity Types_1.png

1. The tables matching the criteria in the last step are displayed. Move any specific tables not to be included to the Exclude tables list and click on Next.

REPLACE WITH THIS IMAGE: Images/Wizards/Assigning Entity Types_2.png

1. Assign the table type criteria and click Display.

REPLACE WITH THIS IMAGE: Images/Wizards/Assigning Entity Types_3.png

1. Deselect all other table types, leaving only the required table types selected. Click Finish to save your changes.

REPLACE WITH THIS IMAGE: Images/Wizards/Assigning Entity Types_4.png

1. In this example, the entity dim_date, previously only had a table type of Dimension, now it is assigned with table types of Dimension and Predefined.

REPLACE WITH THIS IMAGE: Images/Wizards/Assigning Entity Types_5.png