Suppress Ability to Add Sum to a Table - SuperWEB2

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:

   HTML/XML

   <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 databases available on the SuperSERVER instance. It is not possible to configure the setting on a per-database basis.