Menu Options - SuperCHANNEL
File Menu
The File menu allows you to connect to the source and target databases, and save and reopen project files.
Option | Icon | Keyboard Shortcut | Select 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+D | Connect 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+T | Connect 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. |
View Menu
Option | Select To... |
---|---|
Status Bar | Show or hide the status bar at the bottom of the SuperCHANNEL window. |
Toolbar | Show or hide the various toolbars. |
Source Menu
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.
Option | Keyboard Shortcut | Select To... |
---|---|---|
Add Table | Ctrl+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 Table | Ctrl+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 Classification | Ctrl+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 Table | Ctrl+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 Table | Ctrl+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 Tables | Ctrl+B | Add 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.
Target Menu
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.
Option | Icon | Keyboard Shortcut | Select To... |
---|---|---|---|
Set to Fact Table | F2 | Change the currently selected table(s) in the Target View into fact tables. | |
Set to Classification | F3 | Change the currently selected table(s) in the Target View into classification tables. | |
Set to Plain Table | F4 | Change the currently selected table(s) in the Target View into plain tables. | |
Create Reference | Ctrl+R | Start creating a reference, based on the currently selected field in the Target View. | |
Create Classification | Ctrl+L | Create a classification based on the currently selected field in the Target View. | |
Set Primary Key / Remove Primary Key | Ctrl+P | Make 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+H | Include 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 | F5 | Build 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. |
Tools Menu
Option | Icon | Keyboard Shortcut | Select To... |
---|---|---|---|
Source Tool | Alt+1 | Display the Source View pane. This shows the tables and columns in your source database. | |
Attributes Tool | Alt+2 | Display 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+3 | Display the Build Logs from the most recent build of the target database. | |
Data Type Mapping Tool | Alt+4 | Display 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+6 | Display the Target View pane. | |
Grouping Tool | Alt+7 | Display 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. |
Help Menu
Option | Select To... |
---|---|
Online User Guide | Open the SuperCHANNEL user guide. |
Tutorial | Open the SuperCHANNEL tutorial. |
E-mail Support | Start a new message in your default email client that you can use to contact Space-Time Research Support. |
Space-Time Research On The Web | Open the Space-Time Research website in your default web browser. |
About | See information about the product version. |