Changing dimensional modeling properties

You can change the dimensional model properties in the Properties view for dimensional-logical or dimensional-physical data models. You can modify the dimensional properties for dimensional modeling objects, such as tables, entities, columns, and attributes.

About this task

You can edit the properties of dimensional model objects in the Dimensional tab of the Properties view. You can specify the type of dimensional model object. For example, you can specify that a table is a dimension table.

Procedure

To change the dimensional model properties:

Select an object in your dimensional model in the Data Project Explorer. In the Properties view for the object, you can change the following properties:
Dimensional Object Property
Table You can change the dimensional table type. To change the dimensional table type, select the Change the dimensional table type check box, then select the type.
Entity You can change the dimensional entity type. To change the dimensional entity type, select the Change the dimensional entity type check box, then select the type.
Columns, measures, and attributes For columns in fact tables or fact entities, you can specify whether the column is a measure and the type of measure. To specify that the column is a measure, select the Is a measure check box, then select the type.

Feedback