Menu Options

File Menu

Option

Icon

Keyboard Shortcut

Select To...

New

File-New.png

Ctrl+N

Open the Catalogue dialog to choose a database and create a new table.

Open

File-Open.png

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

File-Save.png

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

File-CreateChart.png


Create a chart based on the current table.

Create Map

File-CreateMap.png


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

File-SearchAll.png


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.

Print




Print

File-Print.png

Print the current table.

  • If you have selected part of the table then only the currently selected cells will print.

  • If either all table cells are selected or no table cells are selected then the entire table will print. Use Edit > Select Nothing to clear the table selection.

Print All


Print all currently open tables.

Print Preview

File-PrintPreview.png

Open a print preview. Select this option again to close the preview and return to the table (if you click the close button this will close the table).

Print Setup


Open the Print Setup dialog where you can configure the printer settings.


Page Setup




Page Setup


Configure print settings such as the page margins, whether to print the page numbers, and whether to print the table annex. See

Printing

for more information.

Repaginate


Repaginate the print output. You may need to select this option after you having modified the page setup.

Table Annex

File-TableAnnex.png

Create and update a Table Annex document, which is designed to capture additional information and notes about your table (for example to include in a report). See

Printing

for more information about creating a table annex.


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

Edit-Undo.png

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

Edit-Redo.png

Ctrl+Y

Redo the last action.

Copy

Edit-Copy.png

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




Font

Select a different font for the table header.

Alignment

Change the horizontal alignment of the text in the table header. You can choose from Left, Centre and Right.

You can also select the Use As Default option to save the setting for the next time you create a table.

Meta-Information

Create or view table metadata. See

Metadata and Multilingual Tables

for more information.


Footer




Font

Select a different font for the table footer.

Alignment

Change the horizontal alignment of the text in the table footer. You can choose from Left, Centre and Right.

You can also select the Use As Default option to save the setting for the next time you create a table.

Meta-Information

Create or view table metadata. See

Metadata and Multilingual Tables

for more information.


Table




Clear Table

Edit-Table-ClearTable.png

Clear the current table

Transpose

Edit-Table-Transpose.png

Swap the rows and columns

Transpose Wafer and Row


Swap the rows and wafers

Transpose Wafer and Column


Swap the columns and wafers


Data Area




Data Area Font

Change the font used in the table data area. You can choose from the following options:

  • First - Use the first font set in the Fonts options (Edit > Fonts).

  • Row - Use the same font as the row header.

  • Column - Use the same font as the column header.

  • Priority - Display column, row or derivation label font headers in the same font as the assigned font selections, overriding the table data font display.

Annotate Cells

Manage cell annotations. See

Annotations

for more information.

Conceal Cells

Manually conceal the selected cells. See

Confidentiality

for more information about confidentiality in SuperCROSS.

Suppress Zeros

Suppress rows, columns, or wafers that contain only zeros.


Select Table Method

Edit-SelectTableMethods.png


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

Edit-Confidentiality.png


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

Edit-Formatting.png


Switch formatting on or off.

Annotations

Edit-Annotations.png


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

SX-ColourMatrix-Icon.png


Activate ColourMatrix. For more information, see

ColourMatrix

.

Fields

Cross-Fields.png

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

Cross-CrossTabulate.png

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




View Records

Open Record View for the selected cell (only available if the administrator has enabled Record View for this database and you have selected a cell). For more information, see

Record View

.

View Related Records

Open Related Record View for the selected cell (only available if the administrator has enabled Record View for this database and you have selected a cell). For more information, see

Related Record View

.

Flag Records

Flag records that meet certain criteria so that you can use them in cross tabulations. For more information, see

Flag Records

.

Export Records

Export records for the selected cell (only available if the administrator has enabled Record View for this database and you have selected a cell). For more information, see

Export Records

.

Segmentation

Create a segmentation recode based on the selected cell or cells. For more information, see

Segmentation

.

Analyse Segment

Create a new table based on the selected cell, so you can further analyse the records that contributed to that cell. For more information, see

Segmentation

.


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.