cancel
Showing results for 
Search instead for 
Did you mean: 

Report is not able to distinguish debits and credits accurately

Former Member
0 Kudos

Hello Gurus,

I am generating a report to display revenues for asserts. Revenue is coming as 0AMOUNT to ODS and then to cube (0AMOUNT contains debits or credits).

In ODS update rules 0AMOUNT is mapped to 0AMOUNT.

In Cube update rules ZREV is a custom info object is mapped to 0AMOUNT

All the figures getting into data target are correct but the final result of report is wrong:

example

Record Assert Revenue

1 10 70

2 10 30

In the first record Revenue is Credit so +70

in second record Revenue is Debit so -30

My result should be 40 but I am getting 100.

(I have debit/credit indicator set in ODS which can distinguish these credits and debits)

Please help me out.

Regards

Rajesh

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

While loading data from ODS to the cube, is that a delta load or full load? If it is full load, everytime you need to delete old requests. Pl check this out.

Ravi Thotahdri

Former Member
0 Kudos

Hi Ravi,

Its a delta load I am doing.

Thanks

Rajesh

Former Member
0 Kudos

Hi Rajesh,

If you have got the answer...please post here.

Thanks

andrea

former_member184494
Active Contributor
0 Kudos

rajesh,

have you set any aggregation on the key figures...?

also in the query properties - check display +/- signs.. and the settings for the same...

Arun

Hope it helps...

Former Member
0 Kudos

Hey Arun

I do not any aggregates set up.

My observation so far.

For particular Account : on 31st DEC 2006 some of the -ve revenues were posted.

From R3 side : (tcode: FBL3N) ,For this account it is giving accurate result by considering negative revenues( or adjustments).

From BW side:

1. (ODS) I checked the summation by filterating the records based on credit/debit indicator. This total value matches with R3 values.

2. Now in Cube there is no distinguishing between credit and debit, it aggregates all the amounts with OUT netting the debits and credits.

Obviously report is showing the same values.

example:

In FBL3N:

Account Date amount

1 12/31/2006 100

1 12/31/2006 200

1 12/31/2006 -50

result : 250

In ODS

Account Date amount credit/debit

1 12/31/2006 100 h

1 12/31/2006 200 h

1 12/31/2006 -50 s

In CUBE:

Account Date amount

1 12/31/2006 350

Now my question:

1. Is there any setting in infocube for the infoObject 0AMOUNT which can distinguish debits and credits?

2. Do I need to write a start routine for cube by doing look up on ODS for the credit and debit values?

Please let me know your ideas guys.

Thanks

Rajesh

Former Member
0 Kudos

Guys ,

Finally I solved this problem by writing start routine for cube.

loop at DATA_PACKAGE.

*If Debit/credit indicator is S then multiply amount with -1

if DATA_PACKAGE-DCINDIC = 'S'.

DATA_PACKAGE-AMOUNT = DATA_PACKAGE-AMOUNT * -1.

ENDIF.

modify DATA_PACKAGE.

endloop

thanks

Rajesh