Options

You can set various options and settings for the SuperCROSS client from the Options window (Edit > Options).

This section explains the options available on each tab.

You can use the Set As Default check box to save your settings as the defaults for the next time you use SuperCROSS.

General

Setting

Description

Guide Lines

Specifies whether to display the column and row guide lines.

Startup

Sets the default action when SuperCROSS starts:

Create New Table	Open the Catalogue to create a new table.
Open File	Open a file browser where you can select a saved table.
Do Nothing	SuperCROSS will do nothing and wait for your input.

Table Background

Changes the table background colour.

Field List Box

Changes the font used in the Fields window.

Table Labels

Sets:

The organisation name (displayed in the table header).
The indentation displayed on sub items in the Define Recode window.

Level

Sets the amount of error/warning messages displayed in SuperCROSS.

Novice	Displays all error and warning messages.
Experienced	Displays fewer warning and error messages.
Advanced	Displays only the most serious warnings.
Expert	Displays very few error and warning messages.

Status Bar Help

Select this option to display help messages in the application status bar.

Display Fields Dialog Automatically

Select this option to display the Fields window automatically when you open a database.

Use As Default

Select this option to save your settings as the defaults for next time you use SuperCROSS.

Always Allow Cross-tabulation

Select this option to always allow re-tabulation even if the table has not changed.

Totals

Setting

Description

Recode Total

Sets the default position of recode totals in a table.

Field Derivation

Sets the default display position of field derivation totals in a table:

First	New field derivations will be added as the first field in the axis.
Last	New field derivations will be added as the last field in the axis.
Cursor Position	New field derivations will be added to the right of the field you clicked on (if you are adding a derivation to a column) or below the field you clicked on (if you are adding a derivation to a row or wafer).

Grand Total

Adds an automatic grand total to all tables, either as the First field or the Last field.

Axis Derivation

Sets the default display position of axis derivation totals in a table:

First	New axis derivations will be added as the first field in the axis.
Last	New axis derivations will be added as the last field in the axis.
Cursor Position	New axis derivations will be added to the right of the field you clicked on (if you are adding a derivation to a column) or below the field you clicked on (if you are adding a derivation to a row or wafer).

Labels

Sets the default label for the derivation and recode table totals. If you create a derivation by adding all the values to the expression, SuperCROSS will automatically populate the label with this value.

Use As Default

Select this option to save your settings as the defaults for next time you use SuperCROSS.

Data

Setting

Description

Data Storage

Controls how data is stored when creating large tables. These settings determine memory usage:

Dense Matrix	All table data is stored in memory (approximately 10 bytes of memory is required per cell).
Sparse Matrix	Only non-zero data values are stored in memory (no memory is allocated to zero value cells). Slightly more memory (approximately 14 bytes) is required for each non-zero cell, but this reduces the amount of memory used overall. This setting will slightly decrease tabulation performance as the memory allocation is performed "on the fly".
Prefer Dense	SuperCROSS will use a dense matrix until the memory is full and then switch to the sparse matrix. This is the recommended setting and the default.

Data Font

Sets the font used to display table data:

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.

Large Axes

Use this setting to allow the creation of tables with a very large number of values. When you create a very large table, SuperCROSS will switch to "large axes mode". In this mode, only the first two items in the large axis display while you are constructing the table. This makes it easier to create the table. The full set of values will be retrieved when you run the cross tabulation.

To activate large axes mode, select the Allow Very Large Axes check box and choose whether you want to activate the mode when:

There are more than X items in an axis; or
There is no more physical memory.

If you are going to be building very large tables, then you may want to select the After X Items In Axis option and set it to a very low number (e.g. After 6 Items In Axis). This will make it much quicker to construct your table, as SuperCROSS will not need to display the full axis until you run the cross tabulation.

Data Strings

Controls the strings used to represent various data values:

Zero String	The string used to represent cells where the result is zero.
No Contributors String	The string representing a cell that has no records contributing to its value.
Confidentiality String	The string representing confidential table cell data.
Suppress Total String	The string representing a suppressed cell.

Use As Default

Select this option to save your settings as the defaults for next time you use SuperCROSS.

Format

Setting Description

Data Layout

Sets the default display of columns, rows, and wafers (in points):

Column Width	The default column width.
Row Width	The default row width.
Auto Row Width	Overrides the row width setting; if you select this option the row width will be set automatically to fit the field name.
Row Indentation	The spacing used to indent nested fields in rows.
Row Wrapping	The spacing used to indent wrapped text in rows.
Wafer	The spacing used to indent nested fields in wafers.
Annotation Width	The width of annotations at the right of data cells. If annotation symbols cannot fit in the space, they display a symbol on the left of the data. For example * 12345. If this is set to 0 the annotation is added just before the cell text. If this is set to a positive value the annotation is added the specified number of characters to the right of the cell text. If this is set to a negative value the annotation is added the specified number of characters to the left of the cell text.

Number Format

Sets the formatting of large numbers in cell values. You can choose:

Whether or not to show a thousand separator, such as a comma (the character used as the separator is determined by your system settings).
How many decimal places to show. You can specify a value from -9 to 9 inclusive:
- Set this to a positive value to show that number of decimal places.
- Set this to 0 to show no decimal places.
- Set this to a negative number to apply integer rounding (for example if you set this to -1 then the value 15.151 would be rounded up to 20).

The number of decimal places configured by this setting applies to all values in tables except for grand total percentages (activated by selecting Calculations > Grand Total followed by Calculations > Replace Percent). Grand total percentages use the OtherDataDecimalPlace setting defined in the super.ini configuration file.

Type

Sets the default table display of decimal places. The cell uses the largest of the settings when all the dimensions have different settings, and commonly used values are listed.

0	Displays the power of ten units at zero.
3	Displays the power of ten units at thousands.
6	Displays the power of ten units at millions.
9	Displays the power of ten units at billions.
Other	Enter a number.

Automatic

Set automatic formatting:

Table Formatting	Sets table formatting options automatically after cross tabulation.
Confidentiality	Select this option to apply confidentiality rules to tables automatically.

Use As Default Select this option to save your settings as the defaults for next time you use SuperCROSS.

Lines

Setting	Description
Default Settings	Controls whether lines are displayed on tables. Use the drop-down list to select whether to change the settings for the column headings, row headings, table body, etc and then use the check boxes to turn the individual lines on or off.
Lines Around Empty Axis Headings	Select this option to display the lines for the row, column and wafer headings even if there is no heading in that axis.
Use As Default	Select this option to save your settings as the defaults for next time you use SuperCROSS.

Suppression

Setting

Description

Zero Suppression

Activates zero suppression. You can use this feature to hide (suppress) any columns, rows, or wafers that only contain zeros.

Reveal All First	All cell values will display initially, before zero suppression occurs.
Suppress Rows	Any rows that contain only zero values will be suppressed.
Suppress Columns	Any columns that contain only zero values will be suppressed.
Suppress Wafers	Any wafers that contain only zero values will be suppressed.

Fast Zero Suppression

Select this option to enhance the performance of the suppression process (the performance of the cross tabulation process will be slightly decreased).

Use As Default

Select this option to save your settings as the defaults for next time you use SuperCROSS.

Date/Time

Setting	Description
Date Format	Sets the date format to use throughout SuperCROSS.
Time Format	Sets the time format to use throughout SuperCROSS.
Use As Default	Select this option to save your settings as the defaults for next time you use SuperCROSS.

Duty of Care

It is quite common for a SuperSTAR database to contain multiple fact tables in a parent-child (one-to-many) type relationship. When a result table contains classifications from both fact tables, it is very important that the user understands where the cell counts come from (the parent table or the child table).

The duty of care settings are designed to prevent you from creating potentially erroneous tables, and to ensure that you will always know what is being counted in the cross tabulation.

Setting

Description

Counting

This setting is designed to protect you against unintentionally counting from the wrong table for databases with two or more fact tables. You can get incorrect table results if the default count is not associated with the correct fact table. Choose from the following options:

Use default count	Use the first field value in the Summation Options table (for example a default database count/measure) irrespective of the type of fact tables added to the table.
Use count from table	Use the count associated with the fact table that corresponds to the added fields.

Multiple Tables

Controls what happens when a database contains multiple count/measure fact tables:

Use default count when fields from multiple table	The default count is always used.
Select count when fields from multiple tables	The user will be prompted to choose the fact table count.

Multi Response

Ensures that all parts of a multi-response field are added to the table together. When this option is selected, if one part of a multi-response field is dragged into a table (either the question or the answer), then the other part of the multi-response field is automatically added into the table too.

This setting is only applicable to situations where the multi-response table has separate fields for the question and the answers. For example, the following multi-response question consists of two fields; one contains the question (the methods of transport) and the other contains the positive responses. These fields need to be added to the table together in order to see meaningful results.

If the multi-response field is structured differently in the SXV4 (i.e. there is no separate field containing answers), then this setting does not need to be enabled.

When you activate this option, you can select where to place the other field by selecting one of the following radio buttons:

Place added field in the opposite axis
Place added field in the same axis

See Multi-Response Questions in Survey Data for more information about building SXV4 databases with multi-response data.

Undo

Select this option to enable the undo feature, and set the number of available levels of undo.

Use As Default

Select this option to save your settings as the defaults for next time you use SuperCROSS.

Configuration

The configuration tab controls various configuration settings. Select the area from the Settings drop-down list and then select a setting to change it.

When you select a setting from the list, the Description area provides information about the setting.