Modeling Features › Model Properties › Set General Model Properties

Set General Model Properties

You use the options in the General tab in the Model Properties dialog to specify the model name, author, data warehousing properties, transform defaults, and to review the model type and target server.

To set general model properties

1. Click Model Properties on the Model menu.

   The Model Properties dialog opens, on the General tab.

2. Complete the following fields:

   Name

   Defines the title of the model. This text is used in other dialogs when it is necessary to identify a model by name, for example, in the Complete Compare and Design Layer wizards.

   Author

   Defines the name of the person who is responsible for creating the model.

   Enable Modeling Features:

   Dimensional

   Activates dimensional modeling functionality in your model. When you select this check box, you enable the following functionality: table roles (dimension, fact, outrigger), table icons, two display levels (collapse fact, collapse dimension), table display option (display dimensional icons), and the selection of the type of a slowly changing dimension.

   Data Movement

   Specifies that you want to enforce data movement rules and sources. This enables you to import and create data sources, data source tables, and columns, assign data source columns to model columns, and to enter a transform comment for a column.

   Transform Options (for Logical/Physical models)

   Show source objects in logical, target objects in physical

   Specifies that you want to set this display default. For new transforms in a Logical/Physical model, the transform source objects display on the logical side of the model, and the transform target objects display on the physical side. If you clear this check box, the target objects display on both the logical and physical side (default).

   Auto apply Many-to-Many transform

   Specifies that you want to automatically resolve all many-to-many relationship in the logical/physical model. A transform is applied to each many-to-many relationship in the logical model and inserts an association table in the physical model.

   Auto apply Supertype-Subtype Identity transform

   Specifies that you want to automatically resolve all subtype relationships in the logical/physical model. A transform is applied to each subtype relationship in the logical model and creates identifying relationships in the physical model between each supertype entity and its subtype entities.

   Click OK.

   Your selections are saved and the Model Properties dialog closes.