EBAN Data Model - Set Up Error

Question

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 Message DM Setup and tables needed

bernardo.vecch · Answer

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:SELECTA, B, C, D, E, F,COUNT(A) FROM XGROUP BY 1, 2, 3, 4, 5, 6ORDER BY 7 DESCwhere 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

EBAN Data Model - Set Up Error

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN