The Data Source Model Editor guides you through editing relational and multidimensional models created using the Data Source Wizard. The Data Source Model Editor gives you the ability to move fields by dragging them to the appropriate location, mix and match fields from different tables, add fields to more than one category, or remove a field altogether.
Note: You can edit the models with the Data Source Model Editor or use Pentaho Schema Workbench or Pentaho Metadata Editor for more advanced modifications. Relational and multidimensional models that have been edited in Metadata Editor and Schema Workbench can no longer be edited in the Data Source Model Editor.
The following tasks are things you can do to refine your relational and multidimensional data models with the Data Source Model Editor. Also included are some things that you can do specifically to refine your multidimensional data models, including:
- Assign Geographic Properties
- Assign Time Dimension Properties
- Use Ordinal Columns
- Properties of Time Dimension Levels