Skip to main content

Hello everyone, I'm trying to set up a new DM as the P2P Data model (with join EKPO and EBAN) only makes requisition numbers visible that were already converted into an order. With a separate DM I only want to see the requisition numbers that are open and not processed yet (with some other filters from other tables). Does anyone of you already set up such a data model? I'm currently getting this error message and I have already all the keys that should provide distinct data rows.

 

Thanks so much!

 

BR

Julia Bauer

 

Error MessageDM Setup and tables needed

Hello Julia,

 

it looks as if there are some joins in you transformations that are creating duplicates. The error message you provided alreasy gives you a hint where to look at.

You could try the following query to understand where the duplicates are coming from:

 

SELECT A, B, C, D, E, F, COUNT(A) FROM X

GROUP BY 1, 2, 3, 4, 5, 6

ORDER BY 7 DESC

 

where X is your table (for the first issue 'EBAN') and A-F are the respective columns.

This might give you some indication as to where to find the issue.

 

Unfortunately, if this doesn't work you would need to raise a ticket for someone to have a more precise look at your environment.

 

Best regards,

Bernardo


Reply