Skip to Content
0
Former Member
Apr 08, 2010 at 02:16 PM

Problem with parents not showing the sum of its dependents

41 Views

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