Bw Dso and Cube data mismatch

[Former Member]

Hi All,

This is my first post.

The issue is about missing data in the cube.

There are 2 records in the DSO activation queue  and these 2 records are not present in the change log.

Only 1 record among these 2 records from the DSO are present in the cube.

Actions taken from my end

=====================

1) checked the change log to find whether data is present matching these 2 product id's and found 0 records matching the product id

2) checked the info cube selective deletion log to find whether data was selectively deleted from the cube and found no entries pertaining to these

product ids

3) Checked the transformation between DSO and cube to see if any routines are there and found no field or start routines and all the fields have

just direct mapping to it

My question

==========

1) In what other cases does the data gets not loaded to the cube

2) How to check the date on which the record was loaded to the DSO ( I mean the missing record loaded date)

3) In what scenarios the data will be present in the DSO activation queue and not in the change log

All inputs and suggestion are welcome

Kind Regards,

RA

[sundeep_chalasani]

If both the records in the activation queue have the same key fields as the DSO then you would be getting only record to the InfoCube.

for example:

Records in the DSO

Sales Document (Key Field n DSO)	Quantity
1234	100 CA
1234	50 CA

Records in the DSO Change log after activation would be

Sales Document (Key Field in DSO)	Quantity
1234	100 CA
1234	-100 CA
1234	50 CA

But then only one record would be inserted into the InfoCube because it would aggregate all three rows into one by adding the quantities together.

Records written to the InfoCube

Sales Document	Quantity
1234	50 CA

Hope this helps

Thanks,

Sundeep

[sat_p2]

Hi,

Try to get execute the DTP with Debugging mode based on that product ID and select the trace for : transformation before and Transformation end.

You come to know where its getting deleting.

Regards,

Satyam.

[former_member210321]

Hello,

Have you checked at PSA level before taking to the ODS for the two records the value for the field RECORDMODE, after activating at the ODS if one of them is with RECORDMODE = D then it will delete the two records.

Regards.

[ssurampally]

3) In what scenarios the data will be present in the DSO activation queue and not in the change log

You said that only record available in the cube,  from the 2 records in the activation queue. this could be possilbe that one record would have loaded some time ago into the cube,

the current 2 records, did not generate any change log entry may be due to the reason that, there is a record already in the DSO with same key and date fields, in this case no change log creates when activation takes place.

Please check that one record available in the cube is part of the recent DTP request which you were worring about,

[former_member186053]

Hi RA,

1) Do you have filters defined in DTP level, may these filters might have stopped loading those two records.

2) Do you have Calday in your DSO mapping, if you have you can check in activation queue of respective record date. Or have you mapped BW load date field in your DSO. Or if you have month , take the key field value(example doc number.) and pass it into PSA requests one after the other until you get the two records(check the PSA requests of only the month you get in activation queue of those two records). You need to put some manual effort here.

3) I think you have a process to delete change log for a certain period of time.

What is the update mode(full/delta) you are using to load from DSO to Cube.

Is KF values(like amount/quantity) are matching irrespective of number records between DSO and Cube.

Hope it helps.

Regards,

Vengal.

[Former Member]

Hi Vengal,

1) No there are no selection criteria in the DTP

2) Calday is not there in the DSO mapping

3) Not sure about change log deletion

4) Update is delta update.

Rest all records are matching and fine.

Only this record is missing without any clue.

Not able to understand why

Regards,

RA