Skip to main content
Skip table of contents

Menu Options - SuperCHANNEL

The File menu allows you to connect to the source and target databases, and save and reopen project files.

OptionIconKeyboard ShortcutSelect To...
New Project
Ctrl+N

Create a new SuperCHANNEL project.

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

Open Project
Ctrl+O

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 - SuperCHANNEL for more information.

Save Project
Ctrl+S

Save the current SuperCHANNEL project.

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

Save Project As  Save a copy of the current SuperCHANNEL project.
Save Logs As  Save the current contents of the build logs to a file.
Connect to Source Ctrl+DConnect to a source database. This option is only available if you are not currently connected to a source database.
Disconnect From Source  Disconnect from the currently connected source database. This option is only available if you are not currently connected to a target database.
Connect to Target Ctrl+TConnect to a target database (i.e. an SXV4 file). This option is only available if you are not currently connected to a target database.
Disconnect from Target  Disconnect from the currently connected target database. This option is only available if you are currently connected to a target database.
Recent File List
  Open a recent SuperCHANNEL project.
Exit  Exit SuperCHANNEL.
OptionSelect To...
Status BarShow or hide the status bar at the bottom of the SuperCHANNEL window.
ToolbarShow or hide the various toolbars.

The Source menu options are not available until SuperCHANNEL has been connected to a source and target database. The options allow you to add tables to the target view.

OptionKeyboard ShortcutSelect To...
Add TableCtrl+A

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 as Fact TableCtrl+F2

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 as ClassificationCtrl+F3

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 as Plain TableCtrl+F4

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 as Single TableCtrl+Shift+A

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.

Add All TablesCtrl+BAdd all the tables in the Source View to the Target View.

Tip

You can also add tables from the Source View to the Target View by dragging and dropping.

The Target menu options are not available unless SuperCHANNEL is connected to a source database and to a target database, and one or more tables have been added to the target database. The available options depend on the object that is highlighted in the Target View.

OptionIconKeyboard ShortcutSelect To...
Set to Fact Table F2Change the currently selected table(s) in the Target View into fact tables.
Set to Classification F3Change the currently selected table(s) in the Target View into classification tables.
Set to Plain Table F4Change the currently selected table(s) in the Target View into plain tables.
Create Reference Ctrl+RStart creating a reference, based on the currently selected field in the Target View.
Create Classification Ctrl+LCreate a classification based on the currently selected field in the Target View.
Set Primary Key / Remove Primary Key
 Ctrl+PMake the currently selected field in the Target View a primary key (or remove the primary key status if it is currently designated as a primary key).
Exclude Column / Include Column
 Ctrl+HInclude or exclude the currently selected field in the Target View from the build.
Set Default Summation Ctrl+M

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.

Delete Del

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.

Build Table
 Build the selected table in the target database.
Update Table
 Update the selected table in the target database.
Revise Table
 Revise the fact table in the target database, based on the values in the source for the selected column.
Resume Table
 Resume insert on the selected table in the target database from the last commit point (only available if a build has been stopped).
Update All
 

Update all tables in the target database.

Build All
F5Build all tables in the target database.
Resume All
 

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

Stop Building
Ctrl+Break

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.

OptionIconKeyboard ShortcutSelect To...
Source Tool
Alt+1Display the Source View pane. This shows the tables and columns in your source database.
Attributes Tool
Alt+2Display the Target Attributes pane. This allows you to view and change various attributes for your target database tables and columns, such as the labels to display in the SuperSTAR clients and the column data types and usages.
Logs Tool
Alt+3Display the Build Logs from the most recent build of the target database.
Data Type Mapping Tool
Alt+4Display the Data Type Mapping pane. This allows you to customise the default mapping between data types in the source and target databases.
Preferences
Alt+5

Display the Preferences pane.

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

Target Tool
Alt+6Display the Target View pane.
Grouping Tool
Alt+7Display the Grouping tool. You can use this tool to create groupings of fields and change the order they display in the SuperSTAR clients.
Classification Editor  Open the classification editor. This tool is only available when the target database has been previously built and saved.
OptionSelect To...
Online User GuideOpen the SuperCHANNEL user guide.
TutorialOpen the SuperCHANNEL tutorial.
E-mail SupportStart a new message in your default email client that you can use to contact Space-Time Research Support.
Space-Time Research On The WebOpen the Space-Time Research website in your default web browser.
AboutSee information about the product version.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.