Missing records in the DSO in delta / full update from infocube in BW 7

[Former Member]

Hi,

I have a DSO with key Equipment Number and I am using Infocube as a DataSource.  When  executing DTP some of the records  dont load to New Data Table(/BIC/AZDSO40) of the DSO.

I mean , have 30 record for Equipment Number 1 in Infocube. when execute DTP only 12 record loaded to New Data Table of DSO. when  change Packeage Size of DTP from 50.000 to 10.000 the number of record in New Data Table increase from 12 to 24.

There isnt startroutin and endroutin in Transformasyon. how can I fix this issue ?

Thank You,

OA

[Former Member]

Well, I guess this has to do with your DSO key. In your cube, all those 30 records might be related to only 12 different Equipment no. If you want all the 30 records, you should have more keys in DSO that differentiates all the records.

Rgds..

Shambhu

[Former Member]

Hi Shambhu Kumar Gupta,

All  those 30 records have same Equipment no. Firsly, when excute DTP all records must loaded to New Data Table(/BIC/A___40) of the DSO. after all record with same key loaded to New Data Table, activating DSO must get all same records togather for one record.

But  in the fist step, all record didnt loaded to New Data Table of DSO.

thnks.

[Former Member]

okay, so you are checking the new table itself. Any filter in your DTP...this could possible restrict the no. of records.

Rgds..

Shambhu

[Former Member]

there isnt filter in my DTP.  But when  change Packeage Size of DTP from 50.000 to 10.000 the number of record in New Data Table increase from 12 to 24. after that, change Packeage Size for 500 record and New Data Table increase from 24 to 28. very interesting 

[Former Member]

Interisting 🙂

Let me know this.. what can of DTP it is .. Delta or Full. And have you pulled any req. from the same source to this DSO previously? (No point checking start routine etc as they are not there in this case)

Rgds..

Shambhu

[Former Member]

ı tried all condition Delta and Full. Every time I try to execute DTP, ı clear DSO from req.so there is no record in DSO.