Skip to Content
0
Former Member
Jan 11, 2006 at 05:37 AM

Infocube- file data -

8 Views

Hi All,

I am loading data from File to cube.

1. with full load

C01 10.01.2006 EA 6.00 2 (qty) 12.00

C02 10.01.2006 EA 7.00 2 14.00

C03 10.01.2006 EA 8.00 2 16.00

C04 10.01.2006 EA 9.00 2 18.00

2. I selected “Additive delta “ in Transfer structure

then I got full/Init delata with out/ delta options in Info package

I did Init without data transfer – loaded 1 record

In file records are changed/added.

C01 10.01.2006 EA 6.00 10(qty) 60.00

C05 10.01.2006 EA 55 4(qty) 220.00

I selected Delta Upload :

Its loaded fine,

But showing separately , not summed/aggregated records :

It shows :

C01 10.01.2006 EA 6.00 2 (qty) 12.00

C01 10.01.2006 EA 6.00 10(qty) 60.00

Instead of:

C01 10.01.2006 EA 6.00 12(qty) 72.00

What is the reason?

what additive Delta works for delta in ODS / cubes exactly pls explain?

I think NewStatus for changed records- (this only for ODS delta).

Can anyone please advise?

THanks,

sri.