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.
To change the dimensional model 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. |