Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Inventory scenario - History and delta ends up in same partition!

I have read the first guidance document about inventory cubes in relation to BW on HANA(SAP First Guidance – SAP Netweaver BW 7.30 on HANA Inventory InfoCubes).

I was trying to establish the first scenario(simple table and 3 dtp's) which is described in the document. But I have to say I have some issues and I am thinking that it must be something which I am doing wrong (I have tried it in two systems on 7.4 sps08 and sps09 respectively).

I have the three types of data in the source table

I - Init record (only 1)

H - History record(2 of those)

D - Delta record(2 of those)

And I load in the above sequence. After loading all of the 5 records(before compression) have the following recordtypes:

1 record with the record type 1 (the init one)

2 records with record type 2 (the historical ones)

2 records with record type “ “ (blank - the delta records)

On hana everything is in partition 4 for now - as expected ;-)

Once I run the compression I get my delta and historical records mixed into the same partition - I expected that these would be in separate partitions. When displaying the data in BW the record type for the delta and history is 2 (the blank value on deltas was overwritten with 2).

Does anyone have some pointers ?

Best regards

Michael

Former Member
replied

Hi Michael,

actually the situation that you observe in your system is the intended behavior in a BW 7.40 >= SP6 system.

Please check table RSDCUBELOC field NCUM_REFP_UPD. You should see here value 'Y' for your InfoCube. This means the reference point is updated during compression and all the movements that are part of the compressed request (requid =0) are changed to '2' (historical movements).

This was introduced with BW 7.40 SP6 to allow loading data from a non cumulative InfoProvider into further data targets (SAP note 1949903).

In previous BW 7.40 versions (<=SP5) the value in NCUM_REFP_UPD in table RSDCUBELOC was 'X'. Compression was done by updating the reference points but not changing the recordtp value.

In BW 7.30 the value NCUM_REFP_UPD is space, the compression does not update the reference point.

OLAP execution considers the NCUM_REFP_UPD value and should show the correct stock values for all cases.     

Best regards,

Andreas

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question