Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SettingDescriptionEquivalent Setting in SuperCROSS Client
AfterPhysMemoryUsed

This setting applies if AllowLargeAxes is set to 1.

0Use MaxNumItemsLargeAxis as the trigger for large axes mode.
1Use AfterPhysMemoryUsed as the trigger for large axes mode.
Edit > Options > Data > Large Axes > Allow Very Large Axes
AllowLargeAxes

Whether or not 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.

0Do not allow large axes.
1Allow large axes.

This option works in conjunction with the MaxNumItemsLargeAxis and AfterPhysMemoryUsed settings, which indicate whether to activate the mode when:

  • There are more than X items in an axis; or
  • There is no more physical memory.
Edit > Options > Data > Large Axes > Allow Very Large Axes
AllowLocalAccessMode

Whether or not to allow access to local SXV4 databases in the Catalogue - Select Database or Table dialog.

0Do not show the Local Access section in the database catalogue.
1Show the Local Access section. This is the default and will be used if the setting does not appear in the super.ini configuration file.
Edit > Options > Configuration > SXV4 and Local Access > LocalAccess Mode
AnnotationWidth
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.
Edit > Options > Format > Annotation Width
AutoDataRounding

Whether to apply automatic data rounding:

0Do not automatically apply confidentiality.
1Automatically apply confidentiality to the table.
Edit > Options > Format > Confidentiality
AutoFitCellLimit

A threshold that controls use of the autofit function in Excel downloads.

Since version 9.0 SuperCROSS has been using a particular formatting function from a third-party library when generating Excel files. This function adjusts the row height in the downloaded Excel file to fit the text in the row. This function has been found to cause performance issues when downloading very large tables.

SuperCROSS now runs the function only once per row when downloading very large tables, so in some cases it may be necessary to manually adjust the row height in the downloaded Excel file in order to see the full heading text.

This setting controls the threshold for the new behaviour. Its value is the table cell count in millions.

For example, setting this to AutoFitCellLimit=90 means that:

  • Any table under 90 million cells will use the auto formatting option on every header cell.
  • Any table above this size will not have any custom row heights applied. You may need to manually adjust the row heights in the downloaded Excel file.
 
AutoFormatOn

Whether to apply automatic table formatting:

0No automatic table formatting after cross tabulation.
1Table formatting options will be applied automatically after cross tabulation.
Edit > Options > Format > Table Formatting
AutoGroupNameString

The string to display when multiple values of a field are selected in the Recode dialog.

The default is - (this applies if the setting does not appear in the super.ini configuration file).

Edit > Options > Configuration > Recode > Auto Group Name String
ColumnAutoAxisTotal
If this is set to 1, then SuperCROSS will automatically add a grand total to the column. If this is set to any other value (or not present) then the grand total will not be added. 
ColumnJustify

The alignment of the column headings:

0Centre (default; this setting is also used if the parameter is not specified in super.ini).
1Left.
2Right.
Format > Alignment on the right-click menu.
ColumnWidth
The default column width.Edit > Options > Format > Column Width
ConcatenatedSpanner

Whether to enable a menu option that allows users to display individual field labels for concatenated fields.

By default, when users right-click a field in the table, they can choose the Spanner Label option, which adds the field name to that axis. For concatenated fields, SuperCROSS displays a single label listing all of the concatenated fields. For example, Gender then Marital Status:

If you add this setting to super.ini and set its value to 0, then users will be able to choose between two right-click menu options: Spanner Label > Concatenated, which is equivalent to the above default behaviour, and Spanner Label > Individual, which shows individual field labels for each concatenated field:

0Users will be able to choose between Spanner Label > Concatenated and Spanner Label > Individual when adding labels to their table.
1Users will only be able to add a concatenated spanner label (default; this setting is also used if the parameter is not specified in super.ini).
 
CustomSaveFormatFirst

This setting controls the position of the custom save formats in the drop-down list in the File > Save As dialog.

  • If this is set to 1, then the save formats listed in the Output section of SuperModule.ini will appear first in the Save As options.
  • If this is set to any other value (or not present in super.ini) then the built in SuperCROSS formats appear first.
 
DataFollow

The font used for the data area of the table. This setting can also be changed using the Edit > Data Area > Data Area Font option in the SuperCROSS client.

0FirstUse the first font set in the Fonts options (Edit > Fonts).
1RowUse the same font as the row header.
2ColumnUse the same font as the column header.
3PriorityDisplay column, row or derivation label font headers in the same font as the assigned font selections, overriding the table data font display.
Edit > Options > Data > Data Font
DataStoreKind

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

0Dense MatrixAll table data is stored in memory (approximately 10 bytes of memory is required per cell).
1Sparse MatrixOnly 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".
2Prefer DenseSuperCROSS 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.
Edit > Options > Data Storage
DBPath
The path to the databases that will be available in the Local Access section in the Catalogue - Select Database or Table dialog. 
DecimalPlaces

The number of decimal places used for table data. Can be any value from -9 to 9 inclusive. A positive value means that number of decimal places, 0 means no decimal places and a negative value applies integer rounding.

Note: If you select grand total percentages, then your table will used the OtherDataDecimalPlace setting instead.

Edit > Options > Format > Number Format > Decimal Places
DefaultPowerTen

The default table display of decimal places. For example:

0Displays the power of ten units at zero.
3Displays the power of ten units at thousands.
6Displays the power of ten units at millions.
9Displays the power of ten units at billions.
Edit > Options > Format > Type
DisplaySaveProgress

Whether to display progress when saving a table:

0Do not display.
1Display progress (this is the default and applies if the setting does not appear in the super.ini configuration file).
Edit > Options > Configuration > Output Module > Display Saving Progress
E-mail Support

The link to support accessed through the Help > E-mail Support menu option.

This can be either:

  • A link to a web page (such as a web support form). This must be a fully qualified URL, including the http:// part. For example:

    Code Block
    languagetext
    E-mail Support=http://www.mywebsite.com/support/
  • An email address, in which case a new email message will open with the To address pre-set. For example (note that you must include mailto: before the email address):

    Code Block
    languagetext
    E-mail Support=mailto:support@mycompany.com

If this setting does not appear in super.ini, then by default it will be set to mailto:support@spacetimeresearch.com

 
EnableMultiResponseFields

Whether to

show the fact tables for

enable multi-response fields in SuperCROSS.

0Do not
show fact tables for
enable multi-response fields in SuperCROSS.
1
Show

Enable multi-response fields. When this setting is activated:

  • Multi-response fields can be used in User Defined Fields (UDFs)
  • The fact tables for multi-response fields
. These tables
  • will be visible in Record View and the Summation Options.
Edit > Options > Configuration > General > Multi-Response Fields
FilterFootnotes

Whether to filter annotation footnotes:

0Do not filter annotation footnotes.
1Filter annotation footnotes.
Filter Annotation Footnotes on the right-click menu.
FootnotesJust

The alignment of the table annotation footnotes:

0Centred.
1Left aligned.
2Right aligned.
Alignment on the right-click menu.
FormatOn

Whether or not table formatting is on by default:

0No table formatting by default.
1Table formatting on by default.
Edit > Formatting
FuzzFactor

The default fuzz factor setting in either number format (xxxx.yyyy) or exponential format (xxxe-yyyy, e.g. 1e-15).

The default setting is 1e-15. This value is used if the setting does not appear in the super.ini configuration file.

For more information, see Configure the Fuzz Factor - SuperCROSS.

 
Guidelines

Whether to display guide lines on tables (and empty tables):

0Do not display guide lines.
1Display guide lines.
2Display guide lines even if there is no table.
 
MaxNumItemsLargeAxis
The number of items in an axis that will trigger large axes mode. This will be used as the trigger for large axes mode if AllowLargeAxes is set to 1 and AfterPhysMemoryUsed is set to 0.Edit > Options > Data > Large Axes > Allow Very Large Axes
MaxNumUndos
The number of levels of undo (only applies if Undo is set to 1).Edit > Options > Duty of Care > Undo
MultiResponseAutoPlacing

Where to place the second part of a multi-response field (only applies if MultiResponseEnable is set to 1).

0Place the field in the opposite axis.
1Place the field in the same axis.
Edit > Options > Duty of Care > Multi Response
MultiResponseEnable

This option ensures that all parts of a multi-response field are added to the table together.

0Do not enable multi-response.
1Enable multi-response. 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 a question and answer field on the multi-response table (complex multi-response data). For simple multi-response data this setting is not applicable.

Edit > Options > Duty of Care > Multi Response
NoContributorsString
The string that will display in cells where there are no records contributing to the cell value.Edit > Options > Data > No Contributors String
NotApplicableString
The string representing a suppressed cell.Edit > Options > Data > Suppress Total String
NumberFormat

Whether or not to show a thousand separator, such as a comma in table data (the character used as the separator is determined by your system settings):

0No separator.
1Show a separator.
Edit > Options > Format > Number Format
OtherDataDecimalPlace

The number of decimal places used when the table is showing grand total percentages (the Calculations > Grand Total and Calculations > Replace Percent options have been selected). The default value is 2 decimal places.

In other cases the DecimalPlaces setting is used for table values.

 
OutputEncoding

The default encoding to use when saving output from SuperCROSS:

0Unicode (UTF-8).
1Unicode (UTF-8 with a Byte Order Mark).
2ANSI/System Locale.

This option sets the default; you can choose a different encoding at save time by selecting an option from the Encoding drop-down list. Not all output formats allow you to set the encoding. See Output Formats - SuperCROSS for more details.

Edit > Options > Configuration > Output Encoding Type
PageCentring

The table position on printed output:

0Table will appear in the top left corner of the print output.
1Table will be horizontally centred the table in the printed output instead.
File > Page Setup > Page Setup > Centre Table Horizontally
PageNumbering

The page numbering options:

0Do not print page numbers on printed output.
1Print page numbers.
File > Page Setup > Page Setup > Page Number > Print
PageNumJustify

The horizontal position of the page number in printed output:

0Centre.
1Left.
2Right.
File > Page Setup > Page Setup > Page Number
PageNumMargin

The vertical position of the page number in printed output:

0Bottom of Page.
1Top of Page.
File > Page Setup > Page Setup > Page Number
PrintAnnex

Whether to print the table annex:

0Do Not Print.
1Print After Table.
2Print Before Table.

See Printing - SuperCROSS for more details about the Table Annex document.

File > Page Setup > Page Setup > Annex
PromptForFileAssociation

Whether to prompt for file associations (if .scs files are not associated with SuperCROSS.

0Disable prompts.
1Enable prompts.

You can use this setting to force prompting for file associations, for example if there are multiple versions of SuperCROSS installed on a system or the user has previously been prompted and responded "Do not prompt me again".

 
PureSummationIncludedSubtraction

Whether to exclude the subtraction operator from pure summation.

0Exclude the - operator.
1Include the - operator (this is the default and applies if the setting does not appear in the super.ini configuration file).
Edit > Options > Configuration > General > Pure-Sum Included Subtraction
RowAutoAxisTotal
If this is set to 1, then SuperCROSS will automatically add a grand total to the row. If this is set to any other value (or not present) then the grand total will not be added. 
RowColWidth
The width of the column that displays the rows. Only applies if StandardRowWidth is set to 0.Edit > Options > Format > Row Width
RowExtra
The spacing used to indent wrapped text in rows.Edit > Options > Format > Row Wrapping
RowIndent
The spacing used to indent nested fields in rows.Edit > Options > Row Indentation
ShowTableAnnexInfo

Whether or not to display the following warning message when the user selects File > Page Setup > Table Annex:

0Do not display warning message.
1Display warning message.

Users can turn off the warning message in the client by selecting Do Not Display This Message Again.

Edit super.ini to reactivate the warning message.

SingleInstance

The number of instances of SuperCROSS that can be opened at any given time:

0Multiple instances.
1Single instance (this is the default and applies if the setting does not appear in the super.ini configuration file).
Edit > Options > Configuration > General > Single Instance
StandardRowWidth

If this is set to 1, it overrides the row column width setting; the row width will be set automatically to fit the field name.

By default this is set to 0, in which case the fixed row width setting applies.

Edit > Options > Format > Auto Row Width
StatusLine

Whether or not to display the status bar at the bottom of the SuperCROSS client:

0Do not display.
1Display the status bar.
Edit > Options > General > Status Bar Help
SuppressFlags
Stores zero suppression storage settings in binary. Use the SuperCROSS client to change this setting.Edit > Options > Suppression > Zero Suppression
TableCount

The count to use for databases with two or more fact tables. This setting is designed to protect you against unintentionally counting from the wrong table.

0Use 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.
1Use count from table. Use the count associated with the fact table that corresponds to the added fields.
Edit > Options > Duty of Care > Counting
TitalJust

The alignment of the table title section:

0Centre (default; this setting is also used if the parameter is not specified in super.ini).
1Left.
2Right.
Alignment on the right-click menu.
  • TopMargin
  • Left Margin
  • RightMargin
  • BottomMargin
The top, left, bottom and right margins of printed output.File > Page Setup > Page Setup > Margin
Tutorial
The location of the help files accessed through the Help > Tutorial menu option. You might want to change this if you want to replace the supplied online help with your own help files. 
Undo

Whether to enable undo.

0Do not enable undo.
1Enable undo.
Edit > Options > Duty of Care > Undo
UserLevel

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

1Novice (displays all error/warning messages).
2Experienced.
3Advanced.
4Expert (displays very few error/warning messages).
Edit > Options > General > Level
WaferAutoAxisTotal
If this is set to 1, then SuperCROSS will automatically add a grand total to the wafer. If this is set to any other value (or not present) then the grand total will not be added. 
WaferIndent
The spacing used to indent nested fields in wafers.Edit > Options > Format > Wafer
WarnMLevel

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

0Use default count when fields from multiple table (the default count is always used).
1Select count when fields from multiple tables (the user will be prompted to choose the fact table count).
Edit > Options > Duty of Care > Multiple Tables
ZeroString
The string that will display in cells where the result is zero.Edit > Options > Data > Zero String

...