Data model stores data at the intersection of members from each dimension. Data is stored in a fact table, with one table per data model. Fact tables have columns for each dimension in the data model. These columns have the key to the member in that dimension and values for each member in the measure dimension in each row of the fact table.

Add a data model

To add a new data model:

  1. Navigate to Models module and select the Models icon.
  2. Select Add from the toolbar.
  3. Enter a name and add dimension for the new data model.
  4. Add as many dimensions as required to the data model. Measure type dimension must be included for all data models.
  5. Select the Managed checkbox to automatically create an Analysis Services model for the data model.
  6. Select Process to commit the changes.

Edit dimensions

To delete a dimension from a data model:

  1. Navigate to Models module and select the Models icon.
  2. Double-click the model to edit.
    The Edit Model window displays.
  3. Select the Delete icon that corresponds to the dimension you wish to delete.
  4. Select Save to save your changes.
  5. Select Process to commit the changes.

Delete a data model

To delete the data model:

  1. Navigate to Models module and select the Models icon.
  2. Right-click 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. Select Process to commit the changes.