Menu Options

Create a new SuperCHANNEL project.

You will be prompted to save the current project, if it contains unsaved changes.

Open a saved SuperCHANNEL project file.

If the saved project requires a username and password to connect to the source or target database, you will be prompted to enter the credentials.

If you close SuperCHANNEL after having built a SuperSTAR database, and then subsequently open the project again, SuperCHANNEL will detect that the target database exists and will open it in "update mode". Existing columns in the target database will be greyed out. You will be able to add new mapped columns, and update the data in the existing target database, but you will not be able to modify the settings for previously mapped and built columns or rebuild the entire target database.

If you wish to edit the existing mappings and rebuild the database, you must remove or rename the existing SXV4 file before you open the project in SuperCHANNEL.

See Rebuild an Existing SXV4 for more information.

Save the current SuperCHANNEL project.

This option is only available once you have connected to a source and target database.

Add the currently selected table or tables from the Source View to the Target View. SuperCHANNEL will attempt to automatically determine which type of table it is, but you will be able to modify this afterwards if it is not right.

If the selected tables have foreign key links to other tables then the linked tables will also be added.

Add the currently selected table(s) from the Source View to the Target View as fact tables.

If the selected tables have foreign key links to other tables then the linked tables will also be added.

Add the currently selected table(s) from the Source View to the Target View as classification tables.

If the selected tables have foreign key links to other tables then the linked tables will also be added.

Add the currently selected table(s) from the Source View to the Target View as plain tables.

If the selected tables have foreign key links to other tables then the linked tables will also be added.

Add the currently selected table(s) from the Source View to the Target View.

This option is the same as Add Table, except that linked tables will not be added.

Set the currently selected item in the Target View to be the default summation for this database.

This option is only available if the currently selected item is either a fact table (in which case the default summation will be a count of the records in the fact table), or a measure.

Remove the selected table or tables from the Target View.

This does not delete or modify the table in the source database in any way; it simply removes the table from the target database.

Update all tables in the target database.

Resume building all tables in the target database, starting from the last commit point (only available if a build has been stopped).

Stop the current build (only available when a build is in progress).

You can review the Build Logs pane to see how much of the build has completed, as well as any error messages.

Display the Preferences pane.

Although this tool will allow you to make changes to the SuperCHANNEL configuration, you are recommended to make any required changes by editing the configuration file directly, rather than using the SuperCHANNEL GUI. See config.txt for more information.