Maintenance Tasks

Start the Maintenance & Repair Wizard

This option allows you to perform troubleshooting analysis through system checks.

For more information, see Running the Maintenance and Repair Wizard.

Show Objects Grouped by Their Status

This option allows you to view the status of objects by group.

For more information, see Showing Objects by Status.

Update the Catalog

After importing a new metadata from a data source, this option allows you to perform the following actions:

• Remap Catalog Composers to a new data source

• Remap Catalog source objects, Splitters, and Decoders to a new data source

• Update the Catalog with modified data source metadata

• Update the Catalog Composers

• Update the Data Mart tables

• Update the column data types for the entire solution based on a data source system

For more information, see Updating a Catalog.

Install a Business Measurement Model (BMM)

This option allows you to add a new business measurement model.

For more information, see Installing a BMM.

Detect and remove obsolete BMM metadata

This option allows you to locate and remove obsolete BMM metadata.

For more information, see Removing obsolete BMM metadata.

Show SQL Server Activity

This option allows you to monitor the SQL Server activity.

For more information, see Viewing SQL Server Activity.

Change Company and Division Filter

This option allows you to modify the company and division filter.

For more information, see Changing Company/Division Filter.

Compare Systems

This option allows you to view and compare two systems.

For more information, see Comparing Systems.

Show and Correct Unmapped Columns

This options allows you to view and correct unmapped columns.

For more information, see Managing Unmapped Columns.

Define Indexes

This option opens the Indexing Wizard, which can show current indexes and suggest new indexes to create.

For more information, see Defining Indexes with the Indexing Wizard.

Compile All Pending Objects

This option allows you to compile all pending objects.

Edit ETL Profiles

This option allows you to change the behavior of your ETL processes.

For more information, see Editing ETL Profiles.

Lock Compiled Objects to Production Status

This option allows you to lock specific objects.

For more information, see Locking Compiled Objects.

Edit System Connections

This option allows you to edit system connections.

For more information, see Creating System Connections.

Change User Defined Code

This option allows you to change user defined code properties such as Company Number, Staging, and Data Mart database names.

For more information, see Editing User Defined Code.

Configuration Wizard

This option launches the DWD Configurator, which allows you to edit connection information, filters, and data warehouse content.

For more information, see Running the Configuration Wizard.