Cells with No Contributors

If you have modified the SuperWEB2 settings that determine what happens if a table cell has no records contributing to the result, then you must apply the same changes to Job Queue Manager.

The settings for SuperWEB2 are configured in <tomcat_home>\webapps\webapi\WEB-INF\classes\configuration.properties and <tomcat_home>\webapps\webapi\WEB-INF\data\.repository\CubeCatalog.xml.

The equivalent settings for Job Queue Manager are configured in <tomcat_home>\webapps\queuedjobservice\WEB-INF\config\common\service-config.xml.

To change the settings for Job Queue Manager:

1. Go to the Tomcat instance that is running Job Queue Manager and open <tomcat_home>\webapps\queuedjobservice\WEB-INF\config\common\service-config.xml in a text editor.

   

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

2. Locate the following property and update it to either true or false to match the value for the equivalent SuperWEB2 property in configuration.properties:

   XML

   <property name="showNaNasZero" value="true"/>

3. Locate the following property and change the value to match the no contributors string configured for SuperWEB2:

   XML

   <property name="defaultNotANumberString" value="..NaN"/>

4. Locate the following property and change the value to match the footnote description string configured for SuperWEB2:

   XML

   <property name="defaultNotANumberStringDescription" value=" - data is not available"/>

5. Save your changes.
6. Restart the Tomcat server that is running Job Queue Manager.