Data Source Wizard

Data Source Wizard

The Data Source Model Editor allows you to change relational and multidimensional data models to make your data more accessible. The model editor displays if you choose to customize your model in the last step in the Data Source Wizard, or if you edit the data source later by clicking Manage Data Sources, selecting a data source, and clicking the Edit icon.

Data Source Wizard

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.

You can edit the models with the Data Source Model Editor or use Schema Workbench or 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