Incorrect Behavior of SUM in Discoverer...? [message #270221] |
Wed, 26 September 2007 03:30 |
joselfmp
Messages: 23 Registered: August 2007 Location: Madrid
|
Junior Member |
|
|
Hello,
[Disc versions: Vierwer&Desktop 4i (4.1.0.48.06.00) vs 10g (10.1.2.48.18) - DB: 9.2.0.8]
I've just done an installation of Discoverer 10g and after migrating EUL's I'm comparing results between 4i and 10g. All my 15 reports (non-standard) that have similar total calculations presents in 10g different values (wrong ) than in 4i
An example:
- ColA --- ColB -- Col%
- ---------------------------------------
- 10 - 5 - 2
- 40 - 8 - 5
- ---------------------------------------
Total4i 50 - 13 - 3,8
Total10g 50 - 13 - 7
The Correct is the behavior in 4i....
This problem is exactly related on point 1.4 of the pdf file mentioned in Note:276176.1 from Metalink (Oracle Discoverer Aggregation /
Totals / Calculations Explanation and Examples)
It seems to correspond with the behavior of Sum and Sum Cell, and.. seeing the results of 10g, it seems to be the Sum Cell Format.. but in both, the Total Calculation is set to Sum
I've checked lot's of metalink notes about differents results in Totals&aggregations:
208366.1
333521.1
358707.1
177935.1
276176.1
389850.1
312607.1
290870.1
210553.1
247738.1
and in some of those... appeared references to variables of pref.txt that may alter the total behavior
(AggregationBehavior,AllowAggregationOverRepeatedValues and
EnhancedAggregationStrategy). I have all set to 1 in my regedit and in my
pref.txt. I also have under my database node the variable
DisableFanTrapResolution = 0. (I don't know if it would correspond to a Fan
trpa behaviour)... But.. apart from this.. I can't imagine.. what more things
to look...
Any ideas? Is it an incorrect behavior of SUM calculation in 10g?
I tried to add a new total line in 10g report with SUM CELL instead SUM and the same values appear... I mean with this new line I'd have this two lines for totals:
Total10g (SUM) -> 50 13 7 <- This is what it'd be wrong..
Total10g (SUM CELL) -> 50 13 7
Thanks a lot.
Jose L.
|
|
|
|