1.) Which precise version?
2.) How do you even get that to NOT aggregate
3.) Are all union bits bringing back numerical values?
4.) Do the columns of the measures have an aggregation rule set?
5.) Have you already forced the agg rule to SUM in the pivot?
OBIEE version is 18.104.22.168
All are measure columns (Numerical values) and set to SUM.
Errrrr what about the word "precise" confuses you? Which one of the about 13 different 22.214.171.124 versions?
1 person found this helpful
in the subject areas that you joined by a UNION, you can fill in a '0' in the dummy column.
Apart from that there are two places on which you can set the aggregation. In the column itself AND in the pivot as Christian Berg mentioned. Are you sure you set the aggregation on both places correct?
I have done in both column and pivot view (to SUM).