This is the documentation for SuperSTAR 9.8

SuperSTAR 9.9 is now available.
View this page in the SuperSTAR 9.9 documentation or visit the SuperSTAR 9.9 documentation home.

Skip to end of metadata
Go to start of metadata
SummaryContains table manipulation and general program settings for SuperCROSS.
Default Location

C:\ProgramData\STR\SuperCROSS

If you choose to edit any of the settings in this configuration file, then you must make sure you close SuperCROSS first. When you close SuperCROSS it saves its settings to super.ini, so if you try to edit this file while SuperCROSS is running, your changes will be overwritten when you close the client.

Some of the settings described below do not appear in super.ini by default.

[General]

This section contains general settings for the SuperCROSS client.

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:

    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):

    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 multi-response fields in SuperCROSS.

0Do not show fact tables for multi-response fields.
1Show 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

[Start]

This section contains settings relating to SuperCROSS startup options

SettingDescriptionEquivalent Setting in SuperCROSS Client
Catalogue
The path to the databases that will be available in the Catalogue section in the Catalogue - Select Database or Table dialog. 
New

The default action when SuperCROSS starts.

  • If New is set to 1, then the default action will be to open the Catalogue dialog to create a new table.
  • If Open is set to 1 and New is set to 0, then the default action will be to open a file browser where you can select a saved table.
  • If both options are set to 0, then SuperCROSS will do nothing and wait for your input.

 

Edit > Options > General > Create New Table
Open
Edit > Options > General > Open File

[Lines]

This section contains settings relating to how grid lines display in the client.

SettingDescriptionEquivalent Setting in SuperCROSS Client
LineEmptyAxes

Whether to display lines if the axes are empty.

0Do not display lines if the axes are empty.
1Display the lines for the row, column and wafer headings even if there is no heading in that axis.
Edit > Options > Lines > Lines Around Empty Axis Headings
Lines
The settings for displaying lines for wafers, columns, rows and the table body.Edit > Options > Lines > Default Settings

[Font]

This section defines the fonts that will be available for selection in the Edit > Fonts dialog.

SettingDescriptionEquivalent Setting in SuperCROSS Client
Column
Specifies which of the defined fonts is used for column headings.Field Font on the right-click menu.
Font <X>
A font definition. For example this specifies the typeface, the font size, and style.Edit > Fonts
Footnote
Specifies which of the defined fonts is used for footnotes.Font on the right-click menu.
Number
Specifies the number of font definitions. There is no limit to the number of font definitions that can be specified.Edit > Fonts
Row
Specifies which of the defined fonts is used for row headings.Field Font on the right-click menu.
Title
Specifies which of the defined fonts is used for the table title.Font on the right-click menu.
Wafer
Specifies which of the defined fonts is used for wafer headings.Field Font on the right-click menu.

Footnote, Column, Row, Title and Wafer are all optional. If they are not specified then these elements will use font 1.

For example:

[Font]
Number=4
Font 1=Arial,-165,0,0,0,400,0,0,0,0,3,2,1,34
Font 2=Arial,-165,0,0,0,700,0,0,0,0,3,2,1,34
Font 3=Arial,-165,0,0,0,700,1,0,0,0,3,2,1,34
Font 4=Algerian,-165,0,0,0,400,1,0,0,0,3,2,1,82
Title=2
Column=1
Row=4

[ClientServer]

This section contains preferences for the client/server connection options set in the File menu in the client.

SettingDescription
Group
The workgroup settings used by SuperCROSS. Used during batch processing.
Mode

The client server mode:

0Local.
1Client.
2Server.
RefreshRate

The rate at which SuperCROSS will poll the interchange directory for files to process (in seconds). This setting only applies when SuperCROSS is used for batch processing. For example, if this is set to 60 then SuperCROSS will check the interchange directory every 60 seconds.

A value of 0 indicates that SuperCROSS will not check the interchange directory for files to process.

ShowSetup

Controls whether the user can access the server connection options in the File menu:

0No access to these menu options.
1Allow access to these menu options.

This setting applies to the client/server connection options only. The SuperADMIN connection option will be available regardless of this setting.

WorkGroup
The location for the client/server setup work groups file ( cs.ini ). Only applicable when using SuperCROSS for batch processing.

[XLS]

This section contains settings used when saving tables in Excel format.

SettingDescriptionEquivalent Setting in SuperCROSS Client
CentreTableHeader

The alignment for the table header information:

0Left aligned (this is the default, and is used if this setting is not in the super.ini file).
1Centred.
Edit > Options > Configuration > Excel Options > Centre Table Header
ColumnWidthMax
Minimum width of columns in the Excel output. 
ColumnWidthMin
Maximum width of columns in the Excel output. 
Copyright
A copyright statement to include at the bottom of the worksheet. 
CreatedOn

Whether to include the date the Excel file was generated at the bottom of the worksheet.

0Do not include the created date.
1Include the created date.
 
DataBorder

Whether to draw a border around the data cells.

0Do not draw a border around the data cells.
1Draw borders around the data cells.
 
DecimalPlaces
The number of decimal places in Excel output. 
DecimalPoint
The character to use as the decimal point. 
DualLanguageOutput

Enable dual language saving to Excel. This setting only applies when SuperCROSS has been configured to use multiple languages for tables.

0Disable dual language saving to Excel.
1Enable dual language saving to Excel.
Edit > Options > Configuration > Excel Options > Dual Language Save As
Email
Text to be displayed at the bottom of the Excel worksheet. For example: "Space-Time Research Online support: support@str.com.au" 
HomeLink
Text to be displayed at the bottom of the Excel worksheet. For example: "Space-Time Research Web page: www.str.com.au" 
LanguageOne
The language code (e.g. en, fr, de) of the first language to use for table output when saving dual language output to Excel. This setting only applies when SuperCROSS has been configured to use multiple languages for tables. If this is not set then the current table language will be used.Edit > Options > Configuration > Excel Options > First Language
LanguageTwo
The language code (e.g. en, fr, de) of the second language to use for table output when saving dual language output to Excel. This setting only applies when SuperCROSS has been configured to use multiple languages for tables. If this is not set then the current table language will be used.Edit > Options > Configuration > Excel Options > Second Language
RowIndentation
The number of characters to indent fields (up to 255 characters). 
SaveAsNumbers

Whether to format cell values in the table as numbers or text:

0Save in text format.
1Save in number format.
 
ShowDialog

Whether to show the dual language save options dialog when saving in Excel format. This setting only applies when SuperCROSS has been configured to use multiple languages.

0Do not show the dialog.
1Show the dialog.
Edit > Options > Configuration > Excel Options > Show options dialog
TableBorder

Whether to draw a border around the table.

0Do not draw table borders.
1Draw borders around the tables.
 
ThousandSeparator
The character to use as the thousand separator. 
WafersList

When saving a table containing wafers, each individual wafer is saved to a separate worksheet in the Excel file. This setting determines whether a list of links to each wafer is included on the first worksheet.

0Do not include a list of links to each wafer on the first worksheet.
1Include a list of links to each wafer on the first worksheet.
 
WafersStyle

Where to display the name of the wafer in relation to the table:

0Display the name of the wafer at the top left of the table.
1Display the name of the wafer centred above the table.
 

[HTML]

This section contains settings used when saving tables in HTML format.

SettingDescription
Copyright
A copyright statement to be displayed at the bottom of the HTML output. For example: "Copyright © 2009-2014 Space Time Research. All rights reserved."
DecimalPlaces
The number of decimal places in HTML output.
DecimalPoint
The character to use as the decimal point.
Email
Text to be displayed at the bottom of the HTML output. For example: "Space-Time Research Online support: support@str.com.au"
HomeLink
Text to be displayed at the bottom of the HTML output. For example: "Space-Time Research Web page: www.str.com.au"
LastUpdated

Whether to include the last updated date at the bottom of the HTML page.

0Do not include the last updated date.
1Include the last updated date.
ThousandSeparator
The character to use as the thousand separator.
WaferLinks

This setting applies when saving to a single HTML file.

0Do not include links.
1Include links to each of the wafers at the top of the HTML file.

This setting does not apply when saving to multiple HTML files, as this format always includes links to the other pages on the first HTML page.

[Quantile]

This section sets the quantile calculation algorithm. This algorithm applies to all quantile calculations, including percentiles and the median.

SettingDescription
Algorithm

Set the quantile calculation method used when SuperCROSS is running in local mode. The options are:

Step
Empirical distribution. This is the default.
AverageStep
Empirical distribution with averaging and interpolation.
WeightedAverage
Empirical distribution with interpolation.

This setting only applies when SuperCROSS is running in local mode. When SuperCROSS is connecting to SuperSERVER it uses the settings defined on the server. See the documentation for the cat Quantile command in SuperADMIN for details of how to check and change the server setting.

[Quantiles]

This section contains settings related to quantile calculations greater than 1 million records. These settings apply to SuperSTAR I only.

SettingDefault ValueDescription
DefaultSample
100

For standard quantile calculations, every record is used to calculate the values. However, for very large datasets this may not be efficient.

This setting allows you to specify a default percentage sampling rate for quantile fields calculated from a very large number of records.

Set this to any value between 1 and 100. For example, 50 means sample 50% of the records.

MaxSampleSize
1000000The maximum calculated sample size. Technically any value up to one billion can be handled. However, the machine running SuperCROSS must have enough memory to process these very large calculations.
<field>Sample
100

The percentage sampling rate for calculating quantiles for a specific user defined field. Replace <field> with the name of the field. This setting will override the DefaultSample setting for the specified field.

Set this to any value between 1 and 100. For example, 50 means sample 50% of the records.

For example, to set the default sample size to 50% for most fields, and 40% for the Population field you would use the following settings:

[Quantiles]
DefaultSample=50
MaxSampleSize=10000000
PopulationSample=40

[SuperADMIN]

This section contains settings related to the connection to the SuperSTAR server.

SettingDescriptionEquivalent Setting in SuperCROSS Client
JobQueueServicePath

This setting is used to enable users to submit tables for tabulation in one SuperCROSS session and retrieve the results of those tabulations in a different session. If SuperCROSS is shut down prior to the job/result completion, the table definition is saved locally, and the Job Monitor continues to process the job when SuperCROSS is restarted.

This setting contains the local path where jobs are queued for tabulation.

 
SuperAdminMode

The mode of access to the server:

0SuperADMIN mode.
1SuperSERVER mode (default).
Edit > Options > Configuration > General > SuperAdmin Mode

For example:

[SuperAdmin]
JobQueueServicePath=z:\jobs
SuperAdminMode=0

[Derivation]

This section controls the aggregate statistics method used for SuperCROSS when running in local mode. For example:

[Derivation]
AggregateStatFunction="Parzen#1"

This setting only applies when SuperCROSS is running local mode. When SuperCROSS connects to SuperSERVER it uses the method defined on the server. See the documentation for the cat aggregatestatfunction SuperADMIN command for more details on how to check or change this setting.

[InstallSRD]

This section controls whether opening an SRD also adds a link to that SRD to the Catalogue - Select Database or Table dialog.

This applies when the SRD is loaded:

  • From the command line.
  • By double-clicking the file in Windows Explorer.
  • By dragging and dropping the file onto SuperCROSS.

It does not apply if the SRD is loaded from the File > Open menu option.

SettingDescription
InstallSRD

SRD auto-install behaviour:

0Open the SRD file but do not install a permanent database link.
1

Install a permanent database link in the Catalogue section of the Catalogue - Select Database or Table dialog as well as opening the file. If an SRD already exists in the catalogue with the same ID, then a warning message will be displayed asking whether you want to overwrite the existing SRD:

  • Select Yes to overwrite the existing SRD in the Catalogue - Select Database or Table dialog.
  • Select No to cancel the installation and stop opening the SRD file.

Once the SRD has been installed, the database details will be added to the [Open SuperCUBE] section of the super.ini file.

[Open SuperCUBE]

This section contains details of SRD files installed in the local database catalogue.

[Recent Files]

This section contains the list of recently opened files displayed on the File menu.

[Sort]

This section contains settings for sorting tables.

SettingDescriptionEquivalent Setting in SuperCROSS Client
Derivation

The sort direction for totals and derivations:

0Totals displayed first.
1Totals displayed last.
2Sort.
Sort > Advanced on the right-click menu, Totals & Derivations section.
Direction

The sort direction:

0Ascending.
1Descending.
2Do not sort.
Sort > Advanced on the right-click menu, Sort section.
GroupLength
The number of characters in the other item field.Sort > Advanced on the right-click menu, Include Other Item section.
GroupName
The name of the other item field.Sort > Advanced on the right-click menu, Include Other Item section.
Range
The sort filter range code. Do not modify. 
Segment
The sort segment code. Do not modify. 
TotalLength
The number of characters in the total item field.Sort > Advanced on the right-click menu, Include Total Item section.
TotalName
The name of the total item field.Sort > Advanced on the right-click menu, Include Total Item section.
Type

The sorting type:

0Axis Sort.
1Field Sort.
Sort > Advanced on the right-click menu, Method section.
Use
Set by the SuperCROSS client. Do not modify. 

[SDMX]

This section contains settings used when saving tables in SDMX format.

SettingDescriptionEquivalent Setting in SuperCROSS Client
IncludeCodeListHierarchies

By default, full code list hierarchies are exported to SDMX, but you can change this if necessary so that only code lists included in the recode are exported.

0Only the code list for the recode values will be exported.
1The full hierarchy code list will be exported to SDMX (default).
Edit > Options > Configuration > SDMX Options > Include codelist hierarchies
Languages
The default language codes, separated by a semi colon.Edit > Options > Configuration > SDMX Options > Languages
Multilingual

Whether to export all languages to SDMX (only applies if SuperCROSS metadata has been configured to use multiple languages):

0Current language only.
1Export all languages.
2Export the user selected language.
Edit > Options > Configuration > SDMX Options > Multilingual
RetainCodelistName

Whether to use the recode ID or the value set ID to identify recodes in SDMX output.

This option is intended for use if you are going to use the same field for multiple recodes. In this case you will need to set SuperCROSS to use the recode ID instead of the value set ID.

0Use the recode ID.
1Use the original ID from the value set, even if it has been recoded.

This option is by default set to 1 (use the value set ID) and does not appear in the super.ini file unless the setting has been changed in the SuperCROSS client. You can also enable or disable this option by manually adding the setting to super.ini.

Edit > Options > Configuration > SDMX Options > Use valueset for codelist id and name
ShowDialog

Whether to show the options dialog when saving to SDMX:

0Do not show the dialog.
1Show the dialog.
Edit > Options > Configuration > SDMX Options > Show Options Dialog
ValidateMetadata

Whether to validate metadata against custom.xsd :

0Do not validate metadata.
1Validate metadata. The SDMX export will fail if the validation fails.

This parameter does not appear in super.ini by default. If this parameter is omitted then SuperCROSS will not validate metadata.

Edit > Options > Configuration > SDMX Options > Validate Custom Metadata

[Local Access]

This section contains settings for the Local Access section in the Catalogue - Select Database or Table dialog.

SettingDescriptionEquivalent Setting in SuperCROSS Client
RootItemText
You can add this optional entry to change the name of the Local Access section. If the setting is not include in the super.ini file, then the default name is used (Local Access). 

[Table Annex]

This section contains settings for the table annex document.

SettingDescriptionEquivalent Setting in SuperCROSS Client
AutoAnnex

Whether or not to create the annex automatically:

0Do not automatically generate the annex.
1Generate the annex automatically.
File > Page Setup > Table Annex
DBMetaInfo

Whether or not to include meta information from the database the table is based on:

0Do not include database meta information.
1Include database meta information.
File > Page Setup > Table Annex > Database This Table Is Based On
FieldMetaInfo

Whether or not to include meta information from the fields in the table:

0Do not include field meta information.
1Include field meta information.
File > Page Setup > Table Annex > Fields In The Table
Footnote

Whether or not to include meta information from the table footnote:

0Do not include table footnote meta information.
1Include table footnote meta information.
File > Page Setup > Table Annex > Table's Footnote
ValueMetaInfo

Whether or not to include meta information from the field values in the table:

0Do not include field value meta information.
1Include field value meta information.
File > Page Setup > Table Annex > Field Values In The Table

[TXD]

This section contains settings for saving to TXD format.

SettingDescriptionEquivalent Setting in SuperCROSS Client
AlwaysSaveAxisMap

Whether to save the axis map to the TXD when advanced sorting is applied.

0Do not save the axis map (default).
1Save the axis map to the TXD. This allows other applications to preserve the sort order (it is not required by SuperCROSS).
Edit > Options > Configuration > TXD > Save Axis Map for advanced sort
SaveAutoloaded

Whether to save automatically loaded recodes to the TXD:

0Do not save.
1Save (default).
Edit > Options > Configuration > TXD > Save auto loaded recodes
SaveAxisManualWidth

Whether to save user defined column width information in the TXD file:

0Do not save column width information (default).
1Save column width information.
Edit > Options > Configuration > TXD > Save column width
SaveExtraUserSettings

Whether to save additional table formatting in the TXD file, such as the power of ten setting, the number of decimal places and the row/column width:

0Do not save additional formatting (default).
1Save additional formatting.

Edit > Options > Configuration > Output Module > Save User Settings

Edit > Options > Configuration > TXD > Save extra formatting

[Metadata]

This setting determines whether or not to show the Create Table Metadata dialog if a database is open when metadata is enabled. See Set Up - Metadata Server for more details.

SettingDescriptionEquivalent Setting in SuperCROSS Client
NotShowMetaDlg

Whether to show the dialog:

0Show the Create Table Metadata dialog.
1Do not show the Create Table Metadata dialog.
 
AllowEditMetadata

Whether to allow editing of metadata within SuperCROSS:

0Do not allow edit editing of metadata in SuperCROSS. This is the recommended setting if you intend to create TXD files in SuperCROSS for use with SuperWEB2.
1Allow editing of metadata in SuperCROSS. When you save a table in TXD format, an XML file will be saved along with the TXD that contains the user edited metadata.
Edit > Options > Configuration > Metadata > Edit metadata

[Recodes]

This optional section can be used to activate FASTMAP when saving recodes in textual format (TXD and TXT files). See Speed Up Loading of TXDs Containing Large Numbers of Recodes - SuperCROSS for more details.

SettingDescription
UseFastMap

Whether to use FASTMAP.

0Do not use FASTMAP when saving recodes in text files. This is the default, and will be used if this setting does not appear in the super.ini file.
1Use FASTMAP when saving recodes in text files.
UseFastMapForSummation

Whether to use FASTMAP for summation options.

0Do not use FASTMAP when saving summation option recodes in text files. This is the default and will be used in this setting does not appear in the super.ini file.
1Use FASTMAP when saving summation option recodes in text files. This setting only applies if UseFastMap is set to 1.

Space-Time Research does not recommend using FASTMAP for summation option recodes.

[Custom]

This section determines whether to create segment metadata for inclusion in SDMX output files.

SettingDescriptionEquivalent Setting in SuperCROSS Client
UseSegments

Whether to use segment metadata in SDMX output:

0

Do not use segment metadata.
1Include any segment metadata that exists in the SDMX output file.
Edit > Options > Configuration > Custom > Use segments
AutoClearSegmentsMetadata

Whether to clear segment metadata automatically if the user significantly changes the table.

0Do not clear the metadata.
1Clear the metadata.

This setting only applies if UseSegments is set to 1.

Edit > Options > Configuration > Custom > Auto clear segments metadata
ClearSegmentsMetadataConfirmation

Whether to prompt the user to confirm whether to clear the metadata when the table is significantly changed.

0Do not prompt the user.
1Prompt the user.

This setting only applies if UseSegments is set to 1.

 

Edit > Options > Configuration > Custom > Confirm clearing segments metadata

[Totals]

This section contains settings relating to the display of totals.

SettingDescriptionEquivalent Setting in SuperCROSS Client
AxisDerivationPosition

The default display position of axis derivation totals in a table:

0FirstNew axis derivations will be added as the first field in the axis.
1LastNew axis derivations will be added as the last field in the axis.
2Cursor PositionNew 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).
Edit > Options > Totals > Axis Derivation
DerivationTotalString
The default string to use when creating a derivation total.Edit > Options > Totals > Labels > Derivation
FieldDerivationPosition

The default display position of field derivation totals in a table:

0FirstNew field derivations will be added as the first field in the axis.
1LastNew field derivations will be added as the last field in the axis.
2Cursor PositionNew 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).
Edit > Options > Totals > Field Derivation
GrandTotalPosition

Whether or not to add an automatic grand total to all tables:

0Do not add a grand total.
1Add a grand total as the first field.
2Add a grand total as the last field.
Edit > Options > Totals > Grand Total
RecodeTotalPosition

The default position of recode totals in a table:

0First.
1Last.

Edit > Options > Totals > Recode Total

Edit > Options > Configuration > Recode > Total Position

RecodeTotalString
The default string to use when creating a recode total.Edit > Options > Totals > Labels > Recode
UseRecodeTotalsForGrandTotal

Whether to use recode totals to calculate grand totals (grand totals are added to a table by selecting Calculations > Grand Total). When recode totals are used, the grand totals can be added to tables containing multiple summation options and they correctly handle non-additive tables. Grand totals calculated using recodes also return correct results for the total Relative Standard Error (RSE) as well as the RSE of percentages based on the grand total.

The behaviour for calculating grand totals changed in version 9.7. This setting allows you to revert to the old behaviour if you wish.

0Do not use recode totals. This was the behaviour prior to version 9.7.
1(Default). Use recode totals for grand totals.

This setting does not appear in the super.ini configuration file by default, so you will need to add it if you want to change the behaviour from the default.

If you have weighted databases and you are using the SuperSERVER weighting option, then you must use the new grand total behaviour.

 

If SuperCROSS is configured to use a metadata database to enable multilingual tables, then you can also use this section to set the default derivation and recode total strings for the other languages. Simply specify the values for the other languages by using the name of the property followed by _<language> (where <language> is the relevant language code). For example:

[Totals]
DerivationTotalString=Total 
RecodeTotalString=Total
DerivationTotalString_de=Gesamtmenge
RecodeTotalString_de=Gesamtmenge
DerivationTotalString_fr=Total 
RecodeTotalString_fr=Total

[Legacy]

This section controls settings for older SXV4s.

SettingDescriptionEquivalent Setting in SuperCROSS Client
Codepage

Specify the codepage to use when loading a local copy of an SXV4 database that was built with a version of SuperSTAR prior to 8.0.

Leave the option empty (or set it to 0) to use the system locale codepage.

If you want to use a different codepage, specify either the Windows codepage number of the ISO name. For example: "1252" or "ISO-8859-1".

This does not support saved tables (TXDs and SCS files) in non system locale codepages.
Edit > Options > Configuration > Legacy > Codepage for local old sxv4 databases

[ColourMatrix]

This section controls the field limits for the ColourMatrix feature.

SettingDescriptionEquivalent Setting in SuperCROSS Client
RowMaximumFields
The maximum number of fields that are allowed in the table rows before ColourMatrix will be disabled. You can set this to either 1, 2 or 3.Edit > Options > Configuration > ColourMatrix > Maximum fields on row
ColumnMaximumFields
The maximum number of fields that are allowed in the table columns before ColourMatrix will be disabled. You can set this to either 1, 2 or 3.Edit > Options > Configuration > ColourMatrix > Maximum fields on column
TableMaximumFields
The maximum number of fields that are allowed in a table before ColourMatrix will be disabled. You can set this to either 3, 4, 5 or 6.Edit > Options > Configuration > ColourMatrix > Maximum fields in table
  • No labels