Menu Options
File Menu
Option | Icon | Keyboard Shortcut | Select To... | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
New | ![]() | Ctrl+N | Open the Catalogue dialog to choose a database and create a new table. | ||||||||||||
Open | ![]() | Ctrl+O | Open a SuperCROSS project, saved table definition, or database file. | ||||||||||||
Open With | Ctrl+W | Open a saved table definition (TXD format file) in another database. You will be prompted to select the TXD file first and then the database you want to open. | |||||||||||||
Save | ![]() | Ctrl+S | Save the current table. See Output Formats and Saving for more information. | ||||||||||||
Save As | Save the current table with a new filename. | ||||||||||||||
Save All | Save all open tables. | ||||||||||||||
Close | Ctrl+F4 | Close the current cross tabulation. | |||||||||||||
Create Chart | ![]() | Create a chart based on the current table. | |||||||||||||
Create Map | ![]() | Create a map based on the current table. | |||||||||||||
Import | Import column-based data to be appended to a table. See Import and Append Data to a Table for more information. | ||||||||||||||
Create SAR File | Create a SuperSTAR archive file (.sar). This format packages the SXV4 database with its metadata and TXDs into a single archive format. This can then be provided to another user to open in SuperCROSS through the Local Access section of the database catalogue, or loaded into SuperTABLE. See Output Formats and Saving for more information. | ||||||||||||||
Search Over All Databases | ![]() | Search across all available databases. This option is only available if SuperCROSS has been configured for multilingual metadata. See Metadata and Multilingual Tables for more information. | |||||||||||||
| |||||||||||||||
Page Setup |
| ||||||||||||||
Client/Server Connection | Configure the SuperCROSS for batch processing. | ||||||||||||||
Client/Server Monitor | Display the client/server monitor, which is used when SuperCROSS is running in server mode for batch processing. | ||||||||||||||
SuperADMIN Connection | Configure the connection to a SuperSTAR Database server by entering your username and password and the server details. See Connect to SuperSTAR Database Server for more information. | ||||||||||||||
Production Utility | Access the Production Utility. | ||||||||||||||
Language | Change the user interface language. | ||||||||||||||
Table Language | Change the table language (this option is only available if your system has been configured for multilingual tables using metadata). | ||||||||||||||
Exit | Alt+F4 | Exit SuperCROSS. |
Edit Menu
Option | Icon | Keyboard Shortcut | Select To... | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Undo | ![]() | Ctrl+Z | Undo the last action. You can activate and deactivate the undo functionality, and configure how many undo steps are available by selecting Edit > Options > Duty of Care. | ||||||||||||
Redo | ![]() | Ctrl+Y | Redo the last action. | ||||||||||||
Copy | ![]() | Ctrl+C | Copy the table to the clipboard. | ||||||||||||
Select All | Select all cells in the table. | ||||||||||||||
Select Nothing | Deselect all cells in the table. | ||||||||||||||
Options | Access the SuperCROSS options. See Options for more information. | ||||||||||||||
Fonts | Change the fonts used in the table. | ||||||||||||||
Header |
| ||||||||||||||
Footer |
| ||||||||||||||
Table |
| ||||||||||||||
Data Area |
| ||||||||||||||
Select Table Method | ![]() | Apply a confidentiality table method to the table. This option is only available if confidentiality has been configured and you have permission to access the table methods. | |||||||||||||
Confidentiality | ![]() | Switch confidentiality on or off. Confidentiality is used to hide or disguise sensitive or confidential data. This option is only available if the administrator has given you permission to switch confidentiality on or off. | |||||||||||||
Formatting | ![]() | Switch formatting on or off. | |||||||||||||
Annotations | ![]() | Switch annotations on or off. An annotation is extra information about a particular area of the table. See Annotations for more information. | |||||||||||||
Calculation | Switch calculations (totals and percentages) on or off. |
Cross Menu
Option | Icon | Keyboard Shortcut | Select To... | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Define Fields | Create User Defined Fields. For more information, see User Defined Fields. | ||||||||||||||
ColourMatrix | ![]() | Activate ColourMatrix. For more information, see ColourMatrix. | |||||||||||||
Fields | ![]() | Ctrl+F | Display the Fields window. | ||||||||||||
Record type hierarchy graph | Display a graph showing the relationships between the fact tables in this SXV4. This is particularly useful if you have a complex database that has lots of interconnected fact tables. | ||||||||||||||
Cross-tabulate | ![]() | Ctrl+T | Run the cross tabulation for the current table. | ||||||||||||
Cross-tabulate All | Run the cross tabulation for all open tables. | ||||||||||||||
AutoRun | Activate or deactivate AutoRun for the current table. When the AutoRun feature is enabled, SuperCROSS automatically cross tabulates the data whenever you change a table. AutoRun is not recommended for large data tables due to the time taken to tabulate each time a table is altered. | ||||||||||||||
Records |
|
Calculations Menu
Use this menu to automatic totals or percentages to your table. The percentages are automatically calculated based on the totals you have added to your table.
Option | Select To... |
---|---|
Grand Total | Display both column and row totals to the table. |
Row Total | Display only row totals in the table |
Column Total | Display only column totals in the table. |
Replace Percent | Replace the values in the table with percentages. Only available when you have turned on either one of the total options (Grand Total, Row Total or Column Total). |
Append Percent | Append percentages to the table (display the percentages in addition to the values). Only available when you have turned on either Row Total or Column Total (but not Grand Total). |
Remove Percent | Remove the percentages from the table. |
Format | Format the percentages by displaying the % symbol. |
Reset | Reset the table by removing all totals and percentages. |
When a table has three or more fields, the calculation of automatic percentages is based on the inner most nested field.
The Calculations menu items are disabled if the table contains concatenated fields or derivations. This is to avoid double counting.
Window Menu
Option | Select To... |
---|---|
Cascade | Arrange the windows for all open tables in a cascade. |
Tile Horizontally | Arrange the windows for all open tables on top of each other as horizontal tiles. |
Tile Vertically | Arrange the windows for all open tables side-by-side on screen as vertical tiles. |
Arrange | Arrange the windows for all open tables on screen. |
Help Menu
Option | Keyboard Shortcut | Select To... |
---|---|---|
Online User Guide | F1 | Open the online user guide. |
Tutorial | Access a step-by-step tutorial for learning SuperCROSS. | |
Meta-Information | View or edit table metadata. See Metadata and Multilingual Tables for more information. | |
E-mail Support | Start a new message in your default email client that you can use to contact support. | |
WingArc Australia on the Web | Open the WingArc Australia website in your default web browser. | |
About | See information about the product version. |