Home » Applications » Oracle Fusion Apps & E-Business Suite » Incorrect Behavior of SUM in Discoverer...?
Incorrect Behavior of SUM in Discoverer...? [message #270221] Wed, 26 September 2007 03:30 Go to next message
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.
Re: Incorrect Behavior of SUM in Discoverer...? [message #271680 is a reply to message #270221] Tue, 02 October 2007 08:36 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Jose,

I would suggest to either raise an SR on metalink for this or post your question on the OTN Discoverer forum (perhaps Michael Armstrong or others there do know a solution).

Regards,
Sabine
Previous Topic: Printed Purchase Order Report gives no output
Next Topic: A/P Distribution Issue
Goto Forum:
  


Current Time: Sat Dec 10 05:04:30 CST 2016

Total time taken to generate the page: 0.15290 seconds