Suppress Ability to Add Sum to a Table

In circumstances where perturbation is applied to a table, it may be possible to impute unperturbed values if an unperturbed measure such as mean is available in conjunction with the sum measure.

To prevent this from happening, there is a configuration setting that administrators can modify to remove the sum measure from the table selection tree.

Default Behaviour (Sum Options Available):

SuperWEB2 Modified to Suppress Sum:

To make this change, you need to edit the file <tomcat_home>\webapps\webapi\WEB-INF\web.xml.

Make a backup copy of this file before making any changes.

To suppress the ability to add "Sum" to a table:

1. Open web.xml in a text editor.

2. Locate the following section:

   web.xml

   CODE

   <context-param>
   	<description>
   		Whether to suppress Sum summation options from showing in the schema tree
   	</description>
   	<param-name>suppressSum</param-name>
   	<param-value>false</param-value>
   </context-param>

3. Change the value of <param-value> from false to true

4. Save web.xml.
5. Restart Tomcat.

This setting applies to all datasets available on the SuperSERVER instance. It is not possible to configure the setting on a per-dataset basis.

Open Data API

It is also possible to apply this configuration to the Open Data API.

The API has its own version of the configuration.properties file, located at <tomcat_home>\webapps\webapi#rest#v1\WEB-INF\classes\configuration.properties, so you will also need to make the change to that configuration file if you wish to apply the restriction to API queries.

If you enable the suppress sum feature, then any API queries that request an explicit sum in the request will result in a 422 error.