DWD Main Menu Options and Icons

This section describes all main menu options and all icons used in DWD.

Main Menu Options

The following table describes the DWD menu options in the main menu and in all right-click menus.

Note: In the option column of the following table, (open) means open a dialog or wizard.
Option Menu Use to
Background jobs (open) Execution Run background jobs in full or stepped mode. You can filter the jobs according to the following options:

  • Running

  • Failed

  • Completed

  • Waiting

  • DWD Jobs Only
DWD administrators (open) Administration Add, edit or delete DWD administrators.
Check repository Administration Open the maintenance and repair wizard.
Column property view (set) View Select normal or extended view of column properties.
Compare system metadata Metadata Compare metadata across systems.
Compilation manager (open) Compile Compile objects in the correct order.
Compilation options (open) Compile Access the settings in the compilation tab of the preferences dialog.
Compile all pending objects Compile Compile all pending objects.
Compile all (designer) Right click designer component. Compiles the designer component.
Configuration wizard (open) Metadata Open Configurator to manage connections, filters.
Create a new (designer component) Design or right click on a designer component. Create a designer component. Different options open different dialogs or wizards.

Composers (and tables) open the Create a New Composer (or table) dialog. Decoder opens the same dialog.

Normalizer and de-Normalizer both open a wizard.

Merger opens a Merger wizard; Splitter opens a Splitter dialog.
Create new data mart Design Create a data mart.
Create new model Design Create a model using a wizard.
Create new model group Design Create a model group using a wizard.
Cut

Copy

Paste

Delete

 Edit Cut, copy, paste, delete selected objects.
Data management (access) Administration Correct exception management rows, edit slowly changing dimensions and rollback an ETL session.

Active with compiled objects that contain extracted data.

Database platforms (open) Administration View, add, edit, delete database platforms.
Design options (open) Design Access the settings in the design options tab of the preferences dialog.
Display object by status Metadata List objects according to their status.
Display options View Access the settings in the display tab of the preferences dialog.
Edit dictionary structure Metadata Personalize the dictionary structure.
ETL profiles Execution Change the way the ETL process extracts and loads data.
ETL statistics (open) Execution Show statistics groups.
Event log viewer Administration View event logs and messages.
Exit File Exit or logoff the DWD Designer.
Export metadata Metadata Export metadata for use in other DWD installations.
Filter metadata Metadata Make selected metadata objects visible or invisible.
Import custom DTS and stored procedures Metadata Open a wizard to import custom DTS and stored procedures created outside DWD.
Import metadata Metadata Import metadata from a data source to a system and schema.
Index wizard Design Create and edit indexes using a wizard.
Install measurement module File Open install script wizard to install a BMM.
Job manager (open) Execution Create, edit, delete jobs.
Languages Administration Add and edit languages for use in DWD.
Measure Statistics Execution Show Measure Statistics for fact tables.
Microsoft management console File Start the local Microsoft management console.
New data source system File Create a new data source.
Object ownership Administration Modify the object owner by transferring objects from one user to another.
Object production status Administration Lock or unlock objects.
Object property view View Select normal or process options view of object properties.
Object usages Administration Switch or modify the way an object is used.
ODBC administrator (local) File Start the local ODBC administrator.
Online ETL execution Execution Execute an ETL process for selected tables.
Options Administration Access the settings in the repository properties tab of the preferences dialog.
Preferences File Access the settings in the general tab of the preferences dialog.
Print File Print the current view.
Refresh (screen) View Refresh the display.
Relations manager (open) Design Create and edit relationships between objects.
Remap unmapped columns Metadata Find and remap columns that are not mapped.
Search Metadata Search for metadata objects in the repository.
Security Administration Change the access security to DWD. This feature is password protected.
Server messages Administration Displays the DWD Event Viewer which shows DWD event logs and error messages.
Set company/division filter Metadata Edit general filters.
Shortcuts to designers (use) View Access existing components in each design component group.
Show extended properties View Turn extended properties on or off.
SQL server current activity (view) View View the current activity of the SQL server.
SSIS Property Settings Administration Change the default settings for SIS package properties. Properties include Isolation Levels, Transaction Options, and Encryption Options.
Status bar (show) View Turn on or off the status bar at the bottom of the DWD Designer user interface.
System connections (manage) Administration View, add, edit, delete system connections.
System property view (view) View Select normal or extended view of system properties.
Toolbar (show) View Change the toolbar at the top of DWD Designer.
Transform to catalog Metadata Transform (import) objects from a data source to a catalog.
Update catalog Metadata Update selected catalog objects.
User defined code Design Edit user-defined code.
Variables Administration Manage variables.
Wizards Administration Access all wizards.

Wizards Menu

To locate the Wizards Menu, navigate to Administration > Wizards.

Option Use to More Information
Maintenance and Repair Perform consistency checks in the repository.
Process Import and Maintenance Import DTS packages and stored procedures created outside DWD.
ETL Job Wizard Define how the ETL jobs are created. Define ETL jobs
Index Wizard Manage table indexes Work with indexes

DWD Icons

Certain DWD icons can be overlaid with an icon mask.

Icon Description
White check mark on blue disc. Object has been compiled into SQL format.
Black exclamation mark on yellow. Once compiled objects that need to be re-compiled because of changes.
Dotted underline. Objects that have never been compiled.

Export to File

To export data into a file, click the icon at the upper-right corner of the DWD main panel.

Export into Microsoft Excel Workbook (XLS):

Export into Comma Separated Values (CSV):

Note:  The icons will appear if there are data available for export.