Previous Topic: Snowflake SchemaNext Topic: Data Movement Rules


Convert an Entity Relationship Model to a Dimensional Model

The Dimensional modeling feature is available in a physical model when you select the Dimensional check box on the General tab in the Model Editor. You can convert an entity relationship model to a dimensional model.

To convert an entity relationship model to a dimension model

  1. Open an entity relationship model and select Model Properties from the Model menu.

    The Model Editor opens.

  2. On the General tab, in the Modeling Features section, select Is Dimensional and click OK.

    The entity relationship model is converted to a dimensional model.