Data Model Maintenance

Once dimensions are available, they can be combined into one or more data models. A data model is a collection of dimensions where at the intersection of a member in each dimension, data can be stored. Data is stored in a fact table, one for each data model. Fact tables will have columns for each dimension in the data model that contain the key to the member in that dimension and values for each member in the measure dimension in each row of the fact table.

Adding a Data Model

To add a new data model:

1. In the Models module in the navigation pane, select the Models icon.
2. Click on the Add button on the toolbar.
   
3. Enter a name for the new data model and add dimension by clicking the Add icon.
   
4. Add as many dimensions as required to the data model. A measure type dimension must be included for all data models.
5. Select the Managed checkbox if you wish to automatically create an Analysis Services model for the data model.
6. To commit the changes, click the Process icon.

Editing Dimensions

To delete a dimension from a data model:

1. In the Models module in the navigation pane, select the Models icon.
2. Double-click on the model you wish to edit.
3. The Edit Model window appears.
4. Click on the Delete icon that corresponds to the dimension you wish to delete.
   
5. Click the Save button to save your changes.
6. To commit the changes, click the Process icon.

Deleting a Data Model

To delete the data model:

1. In the Models module in the navigation pane, select the Models icon.

2. Right-click on the data model to delete and select the Delete icon from the context menu.
   

   Alternatively, you may edit the data model and press the Delete button at the bottom of the Edit Model window.
   

3. To commit the changes, click the Process icon.