cancel
Showing results for 
Search instead for 
Did you mean: 

2lis_05_Q0Item Infosource-'Unique Data Records' in Infoprovider

Former Member
0 Kudos

Hi,

We are using the 2lis_05_Q0item BC Infosource & datasource combination in our system for Quality Management.

From the above infosource the data is getting loaded to a custom ODS (termed “ODS for recording Defect Code”).

These objects were created by some previous team in the project. But now we’re facing an issue coz this ODS has the “Unique Data Records” mark set. And because of this it doesn’t allow you to update any record for which the key combination already exists in the ODS. Effectively the ODS allows only new records to come in from the source system and doesn’t allow to modify any existing record.

If anyone has good experience in QM then can they point out why would one use the “Unique Data Records” setting for this ODS, what could probably be the Business or Functional requirements for this?

Is there anything we can do in the source system so that it pulls only new records into the BW?

We don’t have any docs from the earlier team which explains why they have done this setting. Any help from this forum would be greatly appreciated.

Kind regards,

-Melwyn

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Melwyn,

The "Unique Data Records" option is only chosen, when it is absolutely sure that the Data that is coming from the source is UNIQUE, i.e. we donot expect any record from the source, which has already been loaded into the ODS.

The previous project team would have assumed that only Unique recs would be loaded. If you are aware of the missing records, you can change the ODS Settings to UNCHECK the "Unique Data Records" option and then run a REPAIR FULL load from the source into the ODS.

This should resolve your issue, but please ensure that the Update Rules/Data Fields are in OVERWRITE mode to avoid problems.

Regards,

Praveen.

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks guys for your inputs.

Ps. Seems SDN wont allow assigning 6pts to all!

Former Member
0 Kudos

Hi,

When records are cancelled/deleted in R/3, there are only before-images with ROCANCEL = 'X' in the delta queue. If these are downloaded from BW, the relevant key figures in ODS or InfoCubes are set to 0. You can recognize these deleted records by the large number of zeros.

If you are using ODS, you require the InfoObject 0RECORDMODE in the communication structures in BW. 0RECORDMODE is mapped in the transfer rule with the 0STORNO InfoObject, and 0STORNO is mapped with the field ROCANCEL (indicator: cancellation of the data record) of the extract structure.

During the activation of ODS objects with the "unique data record" option, the system delete loaded reverse (R) and delete (D) images.

This means that the associated data records are deleted from the active table.

Hope this give idea..

Lets see the comments comming

regards

Happy Tony

Former Member
0 Kudos

Dear Melvin,

Try changing the update method in the update rules to "Overwrite" instead of "Addition"

Thanks,

Raj