This page describes major changes to the SuperSTAR suite from version 9.0 onwards. This is intended to assist customers who are upgrading to the latest version of the SuperSTAR suite.
|All||Unicode||SuperSTAR now features full Unicode support. In some cases you may need to update existing SXV4s, TXDs and macros to ensure they work with version 9.0 and above, although in the vast majority of cases this change will be completely transparent and no action will be required.|
|Data Control||Record Count and Perturbation||A new Record Count data control module has been added. In addition, the perturbation module now has the ability to perturb other results.|
|Data Control API||Functions||A new function (|
|Java||Java 7 or later is now required. Java is included with the SuperSTAR installation.|
|SuperADMIN / SuperWEB2||Configuration Server|
This release introduces the configuration server. This is a JSON configuration system that stores a number of internal settings. Most of these settings are used by SuperWEB2, and were previously configured in XML and .properties files within SuperWEB2 itself. These settings can now be set and checked using the
If you are upgrading from an earlier release you will need to check the list of settings that have moved to the configuration server and manually reapply any that are required for your deployment.
The configuration server communicates on port 9000, so you will need to ensure your network firewalls are properly configured to allow this communication: this port must be accessible by SuperWEB2 and any machines running the SuperADMIN console.
|SuperCHANNEL||Batch Mode||SuperCHANNEL batch mode now supports the skip and stop cleansing rules, as well as null columns.|
|SuperCROSS||ColourMatrix||The ColourVIEW feature has been replaced with ColourMatrix.|
|SuperSERVER||Update Dataset||SuperSERVER now supports live updates of compatible SXV4s. As long as there have been no changes to the SXV4 schema, you can live swap to a new SXV4 with no downtime.|
|SuperWEB2||Bulk Selection||A new feature has been added for cases where a field has a large number of valueset items. SuperWEB2 now displays a bulk selection option allowing users to search for and select the items they want.|
|SuperWEB2||Catalogue||It is now possible to choose the sort order for the dataset catalogue.e|
A new SuperWEB2 configuration file, configuration.properties, has been added, and many settings have moved to this file. When upgrading from an earlier release you will need to manually reapply any required settings by editing the new configuration.properties file.
|SuperWEB2||Default Table||It is now possible to configure a default table for each of your datasets.|
|SuperWEB2||Drag and Drop||Users can now build tables quickly by dragging and dropping fields.|
|SuperWEB2||Graph View||Graph view has been completely updated with new look interactive graphs.|
It is now possible to navigate up and down the levels of a hierarchical field from with the table.
In addition, the default settings have been changed so that it is now possible to mix items from different levels of a hierarchy within a table (for example adding both Victoria and Melbourne from an Area hierarchy to the table at the same time). In previous releases, this behaviour was disabled by default. You can revert to the previous behaviour by editing the rules in the RulesEngine.xml configuration file.
|SuperWEB2||Mandatory Fields||Mandatory fields are now defined on a per-dataset basis only. Previously it was possible to define global mandatory fields.|
|SuperWEB2||Mapping||SuperWEB2 mapping configuration has been moved from an XML file to the configuration server.|
|SuperWEB2||Multilingual Support||SuperWEB2 now supports multilingual datasets. In addition, users can select their preferred user interface language from the SuperWEB2 menu. Prior to this release, SuperWEB2 automatically set the user interface language based on the user's browser settings.|
|SuperWEB2||Ranges and Quantiles||The range and quantile options now support translations based on the current dataset language.|
|SuperWEB2||Zero Suppression||SuperWEB2 now supports zero suppression.|
|SuperCHANNEL||Totals||The Totals Appropriate setting has been added to SuperCHANNEL. This allows you to disallow totals for specific classification tables. It currently applies to SuperWEB2 only.|
|SuperWEB2||User Defined Fields||This release adds the ability to import user defined fields from SuperCROSS into SuperWEB2.|
|SuperCROSS||Fact Table Relationships||It is now possible to see a visualisation of the relationship between fact tables in the SXV4. This is particularly useful if you have a complex dataset that has lots of interconnected fact tables.|
The following setting has been added to the configuration.properties file:
|SuperWEB2||Graph View||The cell limit for accessing graph view can now be modified. Previously, this limit was fixed at 1,000 visible table cells.|
|SuperWEB2||Metadata||SuperWEB2 now uses the metadata server when connecting to a metadata database. Prior to this release, SuperWEB2 connected to the external database directly.|
The following settings have been added to the configuration.properties file:
The following setting has been added to the configuration.properties file:
The following settings have been added to the configuration.properties file:
|SuperWEB2||Mapping||It is now possible to change the directory that is used to store mapping cache files.|
|SuperWEB2||Precision||It is now possible to disable number formatting in downloads, which can improve the performance when downloading large tables.|
|SuperWEB2||Table Downloads||SuperWEB2 can now be configured to add a warning/disclaimer when tables are printed.|
|SuperWEB2||Terms and Conditions||SuperWEB2 can now display a terms and conditions screen during log in.|
A new property has been added to the mapping configuration:
This property sets the host name of the Tomcat instance that mapping will use when it needs to make a request to another of the REST endpoints.
|SuperADMIN||SuperADMIN now runs an embedded H2 server, listening on port 9092 but only on localhost. In a standard configuration, only the SuperADMIN server itself needs to access this port. This database is now used to store the data for the configuration server. In a new installation it will also be used to hold Field Level Security settings.|
|SuperADMIN||Field Level Security||It is now much easier to allow or deny access to all values in a value set. Previously, each value had to be configured individually.|
|SuperADMIN / SuperWEB2||Saved Tables|
This release adds the ability to load TXDs into the User Data Repository through SuperADMIN. This means you can save a TXD from SuperCROSS and then load it into the SuperADMIN catalogue so that SuperWEB2 users can access that table (in previous releases this required you to save the TXD file to a location within SuperWEB2 itself).
Once you have loaded a TXD into the catalogue, you can use the
|SuperADMIN||Server Command||The |
|SuperCHANNEL||Perturbation||From 9.3 onwards, SuperCHANNEL can automatically generate R Keys for perturbation.|
|SuperCHANNEL||TDD Driver Encoding|
A new option has been added to the config.txt configuration file allowing you to set the encoding to use when channelling with the TDD driver.
You may need to change this setting if you are channelling data that contains characters that are not supported by the current system codepage.
Additional logging is now available when SuperCROSS is running in server mode. SuperCROSS will now log the following events to the Super.logs.txt file (located in C:\ProgramData\STR\SuperCROSS\logs):
|SuperCROSS||Save Table Formats||A new configuration option has been added to SuperModule.ini for configuring the order that the different download formats appear when saving tables.|
|SuperSERVER||Default Settings||Some default settings have been changed for performance reasons: the default number of threads per cross tabulation is now 4 and the default number of processors is now 2.|
Some changes have been made to audit logging:
Some changes have been made to SuperSERVER and Metadata Server logging:
The following settings have been added to the configuration.properties file:
|SuperWEB2||Default Table||This release adds the ability to configure any table in the user data repository to be a default table. Previously, default tables could only be saved system tables (TXDs created in SuperCROSS and saved in the txd directory within SuperWEB2).|
The information pages that are displayed on the dataset catalogue screen in SuperWEB2 now support more options:
Some settings in the basemaps.properties file have changed. This file that is used to configure the base map images (the map imagery itself, such as the street map images or the satellite view).
|SuperWEB2||Mapping||The plugin used to display Map View in SuperWEB2 has changed to ESRI leaflet. As a result of this change, the buttons that allow you to edit the table from within Map View have changed: the Freehand button is now Polygon, and works in a slightly different way.|
A number of new features have been added to metadata:
In some cases, precision settings in TXDs now override the SuperWEB2 precision settings.
In previous releases, the summation options precision setting (defined using the
|SuperWEB2||Select All At Level Drop-Down||It is now possible to display the label of the first item in a valueset in the Select all at level drop-down. This new setting makes SuperWEB2 more closely match the behaviour of SuperCROSS, which displays the first item in a valueset when displaying hierarchies in the Define Recode window.|
A new configuration option has been added that allows you to prevent users from sorting a field alphabetically in SuperWEB2.
By default, when a field has been added to the table rows, SuperWEB2 allows users to sort it into ascending and descending alphabetical order. In some cases, this will not make sense (for example, a date field where it does not make sense to sort the months alphabetically).
|SuperSERVER||Perturbation||New functionality has been added for propagating zero across fact tables when using perturbation.|
|Open Data API||New Product||The Open Data API is now available. This is an additional component that provides programmatic access to SuperSTAR data using a JSON REST API.|
The following settings have been added to the configuration.properties file:
|SuperWEB2||Metadata||A new file, metadataRedirect.html, is now supplied with SuperWEB2 to make it easier to configure static metadata. This file contains the code for redirecting to a static HTML page based on the dataset or field that the clicked metadata link relates to.|
A number of usability changes have been made to the SuperWEB2 user interface.
Some on screen elements have moved or been renamed. For example:
If you have added your own UI languages, then some translation changes may be required.
|Data Control||Confidentiality Rule|
Additional configuration options have been added to the confidentiality rule data control module:
Grand totals are now calculated using recode totals by default. This means that they now correctly handle non additive tables without double counting.
Grand totals can also now be added to tables that have multiple summation options and return correct results for the total Relative Standard Error (RSE) as well as the RSE of percentages based on the grand total.
If you wish to keep the behaviour from previous releases, set
If you load a saved table, it will use the behaviour it was created with, until the grand total is switched off.
|SuperCROSS||Quantiles||For weighted databases, it is now possible to display the Relative Standard Error of the range in the labels of quantile user defined fields. You can also choose to show the minimum and maximum RSE values in each label.|
It is now possible to configure the precision used when displaying quantile range boundaries and RSE values in the labels of quantile user defined fields.
The precision of these values is controlled by two new settings that you can add to the
|SuperCROSS||Relative Standard Error|
When using weighted databases:
The statistics.xml file defines the statistical formulas used by SuperCROSS for its summation options.
It is now possible to display both weighted and unweighted values in the same table when using SuperSERVER weightings in SuperCROSS.
In previous versions, changing between a weighted and unweighted option in the Weight By drop-down list in the Define Recode window would change all of the functions in the Recode Values list to be either weighted or unweighted. Now, you can add a combination of weighted and unweighted functions to the Recode Values list.
Quantile perturbation requires three configuration files. In previous releases these had to be located in the same directory as the SXV4 file.
New properties have been added to the data control modules so that it is now possible to configure the location of these files.
|SuperSERVER||Relative Standard Error|
Prior to version 9.7, it was necessary to configure a data control plugin to calculate RSE values. From 9.7 onwards this now runs automatically for all SuperSERVER weighted databases, and will use the jackknife formula for calculating the RSE. You can still configure the plugin if you wish to change some of its other settings, such as the formula, thresholds and unreliable table message, although if you just want to change the formula used then you can do this by editing a setting in the weightings file (if both are configured then the plugin settings take precedence).
As a result of this change, RSE values are now available for SuperSERVER weighted databases in SuperCROSS when confidentiality has been turned off using the padlock button.
New configuration options have been added to enable consistent weighting configuration across SuperCROSS and SuperWEB2.
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.
A new setting has been added to the super.ini configuration file:
This setting controls the threshold for the new behaviour. Its value is the table cell count in millions.
For example, when this is set to 90:
SuperWEB2 now allows users to create derivations within tables.
Derivations are automatically enabled by default, but you can disable them globally by changing the
As part of this change, a new property (
It is now possible to control the formatting of annotations in Excel downloads. This is particularly useful if you have long annotations as you can now control how the text wraps beneath the table.
In addition, the default Excel download templates have been updated to match the current default SuperWEB2 branding.
A new setting (
In previous releases, the list of fields was always fully collapsed when opening the dataset (so only the names of the top level folders would be visible initially). Now you can choose how many levels to expand.
By default, all folders will now be expanded when you open a dataset.
The configuration setting for specifying the PDF template for downloads from Graph View has changed. Previously this used a single setting (
This setting has been replaced by two individual settings in the configuration.properties file:
|SuperWEB2||Graph View||It is now possible to configure the abbreviations used to shorten large numbers in the axes in Graph View.|
The location of the HTML info pages (which are displayed on the right of the database catalogue screen) has changed.
Previously these pages were located in <tomcat_home>\webapps\webapi\WEB-INF\resources\info\
Now, they are located in <tomcat_home>\webapps\webapi\info\
|SuperWEB2||Metadata||The files supplied for configuring metadata have been renamed from not-configured.jsp and sa-metadata.jsp to not-configured.xhtml and sa-metadata.xhtml. In addition, the default path to these files has changed from /webapi/help/ to /webapi/jsf/help/. You will need to update the settings in your configuration.properties file to match the new location.|
|SuperWEB2||Tour||A new interactive tour has been added to guide new users through the basic operations of SuperWEB2.|
A number of usability changes have been made to the SuperWEB2 user interface:
|Data Control API||Functions|
The following new methods have been added to enable Data Control plugins to obtain additional weighting information:
For performance reasons, the
Existing settings will be migrated automatically when SuperADMIN is upgraded, and no user action is required.
The command used to set and check these settings remains the same, although as part of this change, display options settings can now be set for record counts (previously they could only be set for measures).
|SuperADMIN||Max Attempts and Account Locking|
As a result of changes to the user catalogue (see below), there has been a minor change to the behaviour of the account locking feature.
Previously, changing the global settings for
In addition, it is now possible to configure individual groups or users whose accounts cannot be locked.
|SuperADMIN||Port Usage||As part of the implementation of user registration, SuperWEB2 communicates with SuperADMIN via a new REST API. If you want to deploy the user registration system then you must ensure that port 9001 is accessible.|
|SuperADMIN||User Catalogue and Data Storage|
For performance reasons, SuperADMIN now uses a relational database to store all user data (previously, it used an XML file). When you upgrade to version 9.9 SuperADMIN will automatically convert the existing user data to an H2 database.
It is possible to switch to another RDBMS, although this change should only be made before going into production. Please contact STR for advice if you wish to change the RDBMS for a production system.
SuperADMIN also uses H2 to store the configuration server data and data related to user registrations. Switching to another RDBMS will move all of this data in addition to the user data.
Some additional details are now recorded in the audit logs:
|SuperSERVER||Output Scaling and Precision|
The outputscaling data control module now supports:
As a result of this change, an additional column (
The direct URLs feature has been extended. Previously if you wanted to link directly to a dataset you could construct a link that opens that dataset in Table View (
In addition, a new URL parameter (
|SuperWEB2||Graph View||It is now possible to configure specific colours for specific fields to be used in Graph View.|
A new configuration setting (
In addition, the username and password for guest access are now configured in the configuration.properties file, rather than web.xml.
|SuperWEB2||Large Table Mode|
The thresholds for large table mode are now configured in configuration.properties. Previously these settings were configured in CubeCatalog.xml.
In addition, the default total cell threshold for large table mode has been increased from 10,000 to 100,000.
Mandatory fields are now indicated in the field list by a small red * image that appears on top of the field icon and the field item icon.
A new configuration option has been added that allows you to specify whether mandatory fields will be automatically tabulated when opening a dataset.
|SuperWEB2||Metadata||The default metadata template supplied with SuperWEB2 has been renamed from sa-metadata.xhtml to metadata.xhtml. If you wish to continue using the default template you will need to update the settings in your configuration.properties file to match the new location (please also note that, as documented above, the path to this file changed from /webapi/help/ to /webapi/jsf/help/ in version 9.8).|
|SuperWEB2||Preferences||The Preferences page has been renamed to Account and now has additional options for users to change their password and delete their account. New settings have been added to the configuration.properties file that allow you to turn off these settings.|
|SuperWEB2||Saved Tables and Datasets||SuperWEB2 now displays a tool tip when you hover the mouse pointer over a saved table on the dataset catalogue page. This can be particularly useful if you have tables with very long names, as it is no longer necessary to use the horizontal scrollbar to see the full table name.|
|SuperWEB2||Table Download as Open Data API Query|
A new download format has been added to the Download Table drop-down menu in Table View: you can now download the table as an Open Data API query.
Selecting this option will download a text file containing JSON that you can pass in to the API in a table query. This feature is designed to make it easier to set up your API queries, as you can now use the SuperWEB2 drag and drop interface to design your queries and then easily reuse these in the application you are building with the API.
SuperWEB2 now has an automated user registration system, designed to make it easy to allow users to sign up for an account on your SuperWEB2 deployment, set their own password, and change or reset their password.
As part of this change, users can now change their password and delete their account from the Account page (accessible from the top-right menu).
|Open Data API||Rate Limiting|
It is now possible to configure different rate limits for the
As a result of this change, the
In addition, there are two new endpoints for checking the individual rate limits:
New navigation options have been added to Table View, Graph View and Map View:
If you do not wish to show table names, then you can prevent this by setting the
|Open Data API||Caching|
The Open Data API now automatically caches data to make it more efficient to serve multiple requests for the same table or schema elements. This means that, for example, if multiple requests are received for the same table, the API will return the results from the cache, rather than re-querying SuperSERVER.
The API will also cache data from the metadata server (such as dataset labels).
|Open Data API||Saved Tables|
It is now possible to query the API for tables that have been saved to the User Data Repository (as long as the account doing the query has permission to access the saved table).
The ID of the table can be retrieved from the
|Open Data API||Schema ID Format for Groups|
A change has been made to the format of the schema ID that is returned for groups within datasets (such as a group of classification fields or a group of measures).
The format has changed from
The prefix indicates what type of group it represents:
This change resolves an issue where previously it was not possible to distinguish between a group of classification fields and a group of measures if they both had the same name. For example, if there is a group of fields in your dataset called
|SuperCROSS||Decimal Places in TXDs|
It is now possible to choose whether to explicitly set the decimal places for a saved table (TXD or SCS file). This can be particularly useful when loading TXDs into SuperWEB2, as any TXD decimal place settings will take precedence over SuperWEB2's precision settings. This means that you can now easily choose whether to explicity set the precision for your saved TXDs, or use the default SuperWEB2 settings.
In previous releases, the decimal places setting from SuperCROSS was always saved in the TXD file.
This setting is controlled by the
A change has been made to the default behaviour when a field containing a field derivation is removed from the table. In previous releases, field derivations remained in memory and could be added back to the table. The downside to this behaviour is that the Add Total With Default Recodes option did not apply in cases where a field with a recode was added back to the table.
The new default behaviour is that field derivations are automatically removed from memory when the field is removed, which means that the Add Total With Default Recodes option will now apply if selected when the field is added back to the table.
A new configuration option,
|SuperCROSS||Single Sign On|
The setting to enable Single Sign On is now stored in the ssii.ini configuration file. Previously it was stored in the Windows Registry.
If you are upgrading from an earlier version and you use Single Sign On you will either need to add this setting to the ssii.ini file manually, or reselect the single sign on option in the SuperADMIN Connection dialog.
SuperSERVER audit logs now record a
By default, the event will include details of the fact tables and fields involved in the query. You can use the
|SuperWEB2||Job Queue Manager||An update has been made to the Job Queue Manager so that it is now possible to run multiple instances of Job Queue Manager.|
The Tomcat startup parameters in the sw2.bat file that is provided with the full SuperWEB2 installation have been updated to more closely reflect our recommended RAM settings. This batch file now starts Tomcat/SuperWEB2 with 4GB RAM. In many cases you are recommended to increase the available RAM where possible, see Installation Requirements, Compatibility and Supported Platforms for more details.
In addition, some changes have been made to the batch file to remove some unnecessary error messages that were previously output to the SuperWEB2 log.
If you are using the supplied Tomcat installation and batch files to run SuperWEB2 then you may wish to consider applying the changes from the latest version supplied with this release.
|Data Control||Confidentiality Rule||Since version 9.6 it has been possible to configure the confidentiality rule to only apply when certain fields are in the table. This functionality has been extended to also support only applying the rule when specific summation options are in the table.|
|SuperCROSS||Mandatory Fields||The mandatory fields feature now supports summation options in addition to fields.|
Two new output formats have been added to SuperCROSS:
|SuperCROSS||Recodes||A new setting (|
It is now possible to specify advanced rules for showing or hiding annotations. For example, annotations can be shown or hidden based on specific combinations of fields and field values appearing in a table.
|SuperSERVER||IPv6 Support||SuperSERVER, SuperCROSS and Production System now support IPv6 environments. See IPv6 Support for details on the additional configuration required when deploying on an IPv6 network.|
An additional step is now required when upgrading SuperSERVER: when restoring your existing settings, it is essential that you copy your entire backup of the SuperADMIN server config directory to your new installation. This directory will be located by default at C:\ProgramData\STR\SuperADMIN\server\config\ (Windows) or /STR/SuperADMIN/server/config/ (Linux).
This step is required for all upgrades to version 9.9.3 or later. If you miss this step, then SuperADMIN will fail to start up and will show the following error message:
It is now possible to specify a different version of the online help and PDF download templates depending on the current language SuperWEB2 is displayed in.
This means you can provide translations in every language you need to support for your deployment. As a result of this change, a new configuration file has been added, localised_config.properties. Properties that can be localised, which were previously defined in configuration.properties, are now defined in this new file by default.
To set the relevant properties for each supported language, create a copy of localised_config.properties called localised_config_<locale>.properties for every language you want to support. Replace <locale> with the relevant 2 character lower case ISO 639 language code.
For backwards compatibility reasons, SuperWEB2 will fall back to the old properties in configuration.properties if the localised_config.properties file does not exist.
As part of this change, some properties have been renamed: the online help link properties have been renamed to more accurately reflect where they are used in SuperWEB2, and the property for controlling embedding of fonts in PDF downloads. However, you can continue to use the old property names.
|Open Data API||Schema|
The Open Data API Schema endpoint now supports some additional options that allow you to retrieve the entire schema with fewer requests. In previous releases retrieving the entire schema required users to submit multiple requests to traverse the different levels of the schema hierarchy.
This release adds the
In addition, there are new parameters for individual datasets that allow you to retrieve all fields, all valuesets, or all values.
|SuperCROSS||Dataset Selection||A new setting (|
New settings have been added to the configuration.properties file that are intended to help prevent the accidental release of datasets that do not have confidentiality applied:
These settings are intended for situations where all of your datasets should have confidentiality modules applied to them. By using these properties you can prevent the accidental addition of a dataset that does not have a confidentiality module applied to it.
The localised_config.properties file that was added in version 9.9.3 has been removed. Localised configuration settings can now be defined by creating additional copies of the standard configuration.properties file called configuration_<locale>.properties, where <locale> is the relevant 2 character lower case ISO 639 language code.
Not all properties can be localised. Those that can be localised are identified in the comments in configuration.properties and in the documentation page for this file.
|SuperWEB2||Suppress SUM Setting||The setting for preventing users from adding the SUM to a table has been moved from web.xml to configuration.properties.|
It is now possible to configure SuperWEB2 so that users can opt in or out of email updates from you. To do this:
|Open Data API||Range and Quantile UDFs||The Open Data API now supports queries that include range and quantile User Defined Fields (UDFs).|
|Open Data API||Record View|
A new property (
A future release will make unit record data available through an API endpoint in cases where the dataset has Record View enabled and the requesting user has appropriate permissions.
|Open Data API||Valuesets||It is now possible to use |
|Production System||Record View Offset|
Production System now supports sorting of record view output as well as a record view offset. The offset can be used in conjunction with the existing limit setting to retrieve records in batches. To configure this, there is a new setting you can add to the Production System configuration file, and you can now also include the record view offset in your TXD-level record view configuration file.
|SuperWEB2||Add to Table Ordering|
By default, when you select items from the field list and use the Add to Row, Column, and Wafer buttons, SuperWEB2 adds the items to the table in the order you selected them.
You can now choose to add the items in hierarchical order instead. This adds the items in the order they appear in the field list, regardless of the order you selected them. If you have selected items from multiple levels of a hierarchy, then items from a lower level in the hierarchy will be sorted according to their relative position in the hierarchy.
To apply this sorting when adding items to the table, select the Add in hierarchical order option from the drop-down list under the Row, Column, or Wafer buttons.
|SuperWEB2||CSV Input Encoding||A new property, |
|SuperWEB2||Mandatory Fields and Summation Options|
The mandatory fields rule now supports summation options, in addition to fields.
As a result of this change:
|SuperWEB2||Mapping Cache Configuration||Some mapping data is now stored in an in memory cache. By default, the size of the in memory cache is not restricted. If necessary, you can configure limits on the amount of memory that will be used for the cache, and the cache expiry time, by editing the new map cache properties that have been added to configuration.properties.|
|SuperWEB2||PDF Template Configuration|
The properties for configuring PDF downloads have been changed: previous each type of template (graph and map) had two properties, one to configure the template location and one to configure the template name. These properties have been merged into a single property for each download type that includes both the name and location.
In addition, the default templates have moved from <tomcat_home>\webapps\webapi to <tomcat_home>\webapps\webapi\WEB-INF\templates
It is now possible to configure percentages to be enabled by default for a particular dataset. You can choose to set the default to either row, column or total percentages.
As a result of this change, the percentage menu options are now available when the table is empty, and the total percentages option is now available when there is only one axis in the table (previously this option required at least two axes to be populated).
|SuperWEB2||Record View Configuration||The Record View configuration option has been moved from web.xml to configuration.properties . You must update your configuration accordingly when upgrading to version 9.9.5 or later.|
|SuperWEB2||Select all for Summation Options||A new option has been added to the filter list that allows you to quickly select all Summation Options (similar to the existing Select all at level option for field items).|
|SuperWEB2||Table Download as Open Data API Query||The option to download a table query in Open Data API JSON format is now automatically disabled if the table contains a weighted count, as this feature is not currently supported by the Open Data API. When the table contains a weighted count, the Open Data API Query (.json) option will be greyed out from the Download Table drop-down list.|
|Open Data API||Weighted Datasets|
The Open Data API now supports weighted datasets.
As a result of this change, the SuperWEB2 option to download a table as an Open Data API Query is no longer greyed out if you are viewing weighted table results, and the
|SuperWEB2||Chart Downloads||A new configuration setting (|
The Suppress Sum feature is used to prevent users from adding the sum of a measure to the table. Prior to this version, when suppress sum was enabled for a dataset it also suppressed weighted counts.
This is no longer the case: setting
It is now possible to access saved tables for the current dataset without leaving Table View: a new tab has been added to the Customise Table area that shows a list of all the accessible saved tables for the current dataset. Simply double-click to open any of these tables.
If you do not wish to show this tab, you can hide it by setting
Data Control/Dataset Changes
Job Queue Manager
A number of improvements have been made to audit logging:
As a result of these changes, several new
|Open Data API||Single UDFs||A new setting (|
|SuperCROSS||Transpose Wafer and Row/Column||New options have been added to the Edit > Table menu that allow you to quickly swap the wafers with the rows/columns.|
The default table behaviour has changed. A new button has been added to the Dataset catalogue, Default Table, that appears when a dataset has a default table. It allows users to choose whether to open the default table for that dataset or start with a new table (with any configured mandatory fields applied).
A configuration option (
|SuperWEB2||Derivations||A new configuration option (|
|SuperWEB2||Download Tables as TXD|
A new configuration option (
|SuperWEB2||Folder Expansion for Saved Table Lists|
A new option has been added to the configuration.properties file that allows you to control the initial folder expansion of saved table lists. Previously, it was only possible to set this for the list of datasets.
The new option,
|SuperWEB2||Graph View||A new option has been added to the configuration.properties file that allows you to restrict access to Graph View if there are more than a certain number of fields in the table.|
|SuperWEB2||Icon Link||The SuperWEB2 logo is now a clickable link. By default it links to the Dataset catalogue but you can configure the destination for this link by editing the |
SuperWEB2 now supports the Web Feature Service (WFS) Interface Standard for mapping (previously, ArcGIS was the only supported mapping server).
When configuring mapping with a WFS server, there are some additional required configuration keys:
|SuperWEB2||Metadata Icons||A new property (|
|SuperWEB2||Percentages in Saved Tables|
SuperWEB2 now supports saving tables with percentages. If percentages are turned on at the time the table is saved, then this setting will be saved with the table and restored when it is reopened.
For saved tables that were created in SuperCROSS in TXD format and have been loaded into SuperWEB2 (for example as system tables), SuperWEB2 supports percentages that were added using the SuperCROSS Replace Percent option only. Tables with percentages added in SuperCROSS using Append Percent cannot be loaded into SuperWEB2.
|SuperWEB2||Terms and Conditions||A new setting (|
|SuperWEB2||Upload Tables in TXD Format|
It is now possible to allow administrator users to upload tables into SuperWEB2 in TXD format.
This feature is not enabled by default. To activate it, set
Opening a TXD in this way does not save the table by default: you will need to manually save the table after opening it if you want it to be available in future SuperWEB2 sessions.
As part of this change, the
With this release we have begun working towards Web Content Accessibility Guidelines (WCAG) 2.0 compliance in SuperWEB2. As part of this work we have:
|Audit Logging||Data Control||A new item is now recorded in the audit logs as part of the SuperSERVER |
|Data Control API||Perturbation||A new |
|SuperADMIN||SMTP Proxy Support|
SuperADMIN now supports configuring a web proxy to send user registration emails. Additional settings are now available in the SuperADMIN local.conf configuration file.
|SuperCROSS||Add to Row/Column/Wafer Shortcuts||New right-click menu options have been added to the Fields window that allow you to choose which axis to add a field to: Add to Row, Add to Column and Add to Wafer.|
|SuperCROSS||Fields Window||A usability improvement has been made to the Fields window. Previously, when an item in the list was collapsed, any items underneath it in the hierarchy would also be collapsed. Now, expanded sub items are retained when collapsing and expanding an item in the list.|
|SuperCROSS||Hide Unused Fields||A new option has been added to the Fields window: Hide Unused Fields. Users can select this to hide any fields from the list that are not currently in the table.|
|SuperCROSS||SCS File Size|
Due to a change in number storage formats (from 32 bit integer to doubles for most cubes), by default SCS files saved from SuperCROSS will be approximately double the size of the equivalent files from earlier versions.
If required, users can revert to the previous behaviour by adding the setting
|SuperSERVER||Quantiles||A fix has been implemented to resolve an issue with the Step Quantile algorithm that is used to generate percentiles.|
|SuperSERVER||Tabulation Performance - Fast Path Calculation of Totals||Performance improvements have been implemented to improve tabulation performance when calculating totals of sums and counts in certain situations. For certain tables, totals are now calculated using a faster post-tabulation calculation method.|
|SuperWEB2||MariaDB Support||The User Data Repository and Job Queue Manager now support MariaDB, using the MariaDB drivers.|
|SuperWEB2||Performance||A performance improvement has been made to SuperWEB2. It now more efficiently manages dataset-level configuration settings to reduce the number of times this configuration needs to be retrieved from the server.|
|SuperWEB2||Security Fix||A security fix has been implemented to resolve a potential XML External Entity vulnerability related to a third party library. WingArc Australia strongly recommends all customers upgrade to 9.10 to mitigate any potential risk from this vulnerability. Please contact WingArc Australia support for further details.|
Recodes (custom groups) in saved tables are now added to the field list as "temporary recodes". These temporary recodes are indicated with the symbol
Temporary recodes can be removed from the table, but doing so will also remove them from the field list.
|SuperWEB2||Totals (Initial State)|
The behaviour of
|SuperWEB2||Totals (Unused Total Behaviour)|
A new setting,
The appropriate setting for your system will depend on the types of tables your users create. The performance improvement is more significant for non-additive tables, where each total will double the tabulation time. If your users create a lot of non-additive tables then you are recommended to set this property to
For additive tables, the performance benefit is negligible. If your users mostly create additive tables then you are recommended to leave this property set to
|SuperWEB2||TXDs, Single Item Recodes and the Default Label for Multilingual Datasets|
The default labels specified in TXDs for single item group recodes in multilingual datasets are now ignored by SuperWEB2. This change only affects customers who generate their own TXDs and use multilingual datasets.
For a multilingual dataset, field items are expressed in TXDs in the form
SuperWEB2 now ignores the default label specified in the TXD when parsing recodes.
|SuperWEB2||User Data Repository - Microsoft SQL Server Driver||The SuperWEB2 User Data Repository is now compatible with the latest Microsoft SQL Server driver (version 7.2). It is no longer compatible with the version 4.2 driver that was previously recommended.|
|SuperWEB2||User Registration||The configuration of the base URL for user registration email verification links has changed. Previously this was hard coded. Now the URL will be automatically detected by SuperWEB2 but possible values for the base URL must be added to a whitelist in order for them to be used in emails sent by SuperWEB2.|
|Data Control API||Cancelled Jobs||A new method has been added (|
|SuperADMIN||OSGi||The Java OSGi framework has been removed from SuperADMIN.|
|SuperCROSS / SuperSERVER||Tabulation Requests|
Improvements have been implemented to allow SuperSERVER to cancel tabulation requests as soon as the SuperCROSS session has been terminated.
Previously, SuperSERVER continued tabulation requests even if the SuperCROSS session had been ended or terminated, potentially consuming significant resources.
|SuperCROSS / SuperSERVER||CSV Output|
Performance improvements have been implemented related to saving CSV output from SuperCROSS.
Some additional details are now recorded in the audit logs:
|SuperWEB2 / SuperCHANNEL||Recodes and Totals Appropriate Fields|
A new setting,
|SuperWEB2||Custom Message on Search Results Page||A new definition, |
|SuperWEB2||Hide System TXDs|
A new setting,
These items can still be opened via direct URLs, but they will not be visible to users in the catalogue.
|SuperWEB2||Large Table Mode|
The thresholds for large table mode configured in configuration.properties can now be set with values that include and exclude wafers.
The existing setting
|SuperWEB2 / Open Data API||Read-only Tables|
It is now possible to set tables as read-only on a per-dataset or per-user group basis. This feature allows SuperWEB2 to share static tables or reports to users.
By default this feature applies to all users of the specified dataset, but you can choose to apply the setting only to specific groups if you wish. Users with read-only access will not be able to edit any read-only tables, for example, the schema tree and add/remove functionality will not be available.
|SuperWEB2||Summation Options Rule|