Configure Settings for Concealment and Cells with No Contributors

Concealment

Concealment of data in SuperSTAR is achieved via the Data Control API. If a Data Control API module has been configured for a certain dataset, it may flag certain data values as being "concealed".

• Data values flagged as concealed will be displayed in SuperWEB2 using a configurable string instead of the data value itself. The default value is "..C".
• If a concealed string is displayed in a table, then the string itself as well as a configurable description is also displayed at the bottom of the table as a footnote. The default description is " - data is concealed".

If the intent of the confidentiality rule concealing values is to set those cells to 0, so that they are indistinguishable from true 0 values in the table, then you should configure the confidentiality rule to set the concealed cells to 0, rather than changing the concealed string to "0". See these steps to Replace the Cell Value with 0 instead. No footnote is displayed when concealed cells are set to true 0 values by the data control module.

To configure the strings:

1. Open <tomcat_home>\webapps\webapi\WEB-INF\data\.repository\CubeCatalog.xml in a text editor.

   

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

2. Locate the following attribute and change the value to your preferred concealment string:

   XML

   concealedString="..C"

3. Locate the following attribute and change the value to your preferred concealment description:

   XML

   concealedStringDescription=" data is concealed"

4. Save your changes.
5. Restart Tomcat or the SuperWEB2 server.

If you are using the Job Queue Manager, then you must apply the same changes to the Job Queue Manager server.

Cells with No Contributing Values

By default, if a cell in a table has no records contributing to the result, then SuperWEB2 will display 0 as the cell value.

You can configure SuperWEB2 to display a configurable string instead to indicate that there are no contributors to the cell. When you configure SuperWEB2 like this, it will also display a description in the table footnotes, explaining what the string means.

The default string value is "..NaN" and the default footnote description is "data is not available".

To configure SuperWEB2 to display the string instead of 0:

1. Open <tomcat_home>\webapps\webapi\WEB-INF\classes\configuration.properties in a text editor.

   

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

2. Locate the following parameter:

   TEXT

   cube.showNaNAsZero=

3. Set the value to false.

   TEXT

   cube.showNaNAsZero=false

4. Save your changes to the file.

If you also want to change the string and footnote description:

1. Open <tomcat_home>\webapps\webapi\WEB-INF\data\.repository\CubeCatalog.xml in a text editor.

   

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

2. Locate the following attribute and change it to your preferred string to show in the table:

   XML

   notANumberString="..NaN"

3. Locate the following attribute and change it to your preferred footnote description:

   XML

   notANumberStringDescription=" data is not available"

4. Save your changes to the file.

When you have finished making changes, restart Tomcat or the SuperWEB2 service.

If you are using the Job Queue Manager, then you must apply the same changes to the Job Queue Manager server.