Sub-totals and Grand Totals Show NULL, N/A or 0 in Discoverer Plus and Viewer

Symptoms
Sub-totals and Grand Totals display NULL, N/A or 0 in Discoverer Plus and Viewer (web products).

Cause
AggregationBehavior and AllowAggregationOverRepeatedValues are set at default values.

Pref.txt shows the default of AggregationBehavior = 0 and AllowAggregationOverRepeatedValues is
not set or is also set to 0.

Solution
To implement the solution, please execute the following steps:

1. Add/Change AggregationBehavior = 1 and AllowAggregationOverRepeatedValues = 1 in the pref.txt file. These two preferences need to be added in the [Application] section (as follows):



[Application]
AggregationBehavior = 1
AllowAggregationOverRepeatedValues = 1

[Database]
EnhancedAggregationStrategy = 0

NOTE: AggregationBehavior and AllowAggregationOverRepeatedValues do not work if EnhancedAggregationStrategy is set to a value larger than 0.


2. Apply preferences by running
BI_Home/discoverer/util/applypreference.sh for unix or
BI_Home\discoverer\util\applypreference.bat for Windows.

NOTE: Discoverer 10.1.2 Plus users may also change the aggregation settings in the Plus applet by choosing
Edit > Worksheet Properties > Aggregation tab.
Uncheck the radio button for "Use default aggregation behavior" and check the radio button for "Show the Sum of Values displayed in the contributing cells" and choose OK.