Hi!
We have a very strange error in one of our applications. Itu2019s a problem where the parent doesnu2019t have the same value as the sum of its dependents. Some times it works alright and some times it doesnu2019t, and the problem can occur in two different ways.
I have used EVDRE report for my examples.
In the first example top parent AS000 actually shows the right value but it isnu2019t the sum of its dependents in the report. The problem is AS104 which shows an incorrect value, as you can see in the NR2 in my example this parent level (AS104) doesnu2019t show the sum of its dependents.
If I put the sum of the dependents of AS104, instead of AS104 itself, in the report (NR1) I will get report where the parent AS000 shows the same value as the sum of its dependents as you can see in NR3.
The second way the problem occurs is when parent AS000 shows the wrong value but the sum of its dependents shows the right value (-4332,63) NR4. But the value of AS000 is the same value as the dependents of AS000 showed in our first example so I guess the problem is the same but is showing in different ways.
In NR5 I have changed the time dimension to show just one month instead of all and now suddenly all figures shows the right value. In screenshot 6 I have changed back time dimension to show all months again and you can see we still got the right value in the fist month but the error still occurs in the second month.
The problem seem to be connected to the parent level AS104 in our account dimension, I have looked at the account dimension but canu2019t find anything wrong
We are using BPC5.1 SP5 on SQL 2005 Server
NR1
AS000 -4 323
AS103 42 468
AS104 -38 121
AS105 -13 075
AS106 -3 785
AS107 -21 544
AS108 1 165
AS109 0
NR2
AS104 -38 121
AS307 -1 711
AS310 -7 812
AS311 -29
NR3
AS000 -4 323
AS103 42 468
AS104 -9 552
AS105 -13 075
AS106 -3 785
AS107 -21 544
AS108 1 165
AS109 0
NR4
2010 JAN 2010 FEB
AS000 -32 892 -67 139
AS103 43 845 92 957
AS104 -9 552 -19 808
AS105 -13 114 -26 444
AS106 -5 123 -12 680
AS107 -21 544 -43 137
AS108 1 165 1 215
AS109 0 0
NR5
2010 JAN
AS000 -4 323
AS103 43 845
AS104 -9 552
AS105 -13 114
AS106 -5 123
AS107 -21 544
AS108 1 165
AS109 0
NR6
2010 JAN 2010 FEB
AS000 -4 323 -67 139
AS103 43 845 92 957
AS104 -9 552 -19 808
AS105 -13 114 -26 444
AS106 -5 123 -12 680
AS107 -21 544 -43 137
AS108 1 165 1 215
AS109 0 0
Regards
Fredrik
Edited by: Fredrik Johannesson on Apr 8, 2010 4:17 PM
Edited by: Fredrik Johannesson on Apr 8, 2010 4:28 PM