Duplicate Key Predicate Error in Analytic Model in SAP Datasphere

[#1]

Dear Community,

I am currently working on converting the Analytical Datasets (now deprecated) to Analytic Model using Fact semantic usage as is recommended. While doing so, I encountered an error in the Analytic Model where I was unable to see the data in the Data Preview and is showed an error saying "Duplicate key predicate:(PRIMARY KEY DIMENSIONS = value)" i.e. showing only primary key dimensions and a particular value. I can see data in the Data Preview in the Fact View that is used as the base source of the Analytical Model. I had to remove the Primary Key of these dimensions and only then could I see the data. And then there was another error saying: "Duplicate key predicate:(null). Is there any resolution for this?

Please let me know if I can provide any more information.

Thank you!

[Martin_Kuma]

Hi, 

try to copy & paste SQL. Or save-as without any Associations attached to the model-view (FACT level). 

DSP ignores not-nulls, duplicates, ... only the validation shows this, but DSP does not work with SQL rules. Only tables in DSP do.  

I observed different issues, I could not even explain. Once I build two models with the same base-line measure and the AMs showed different results. What helped was to copy the SQL to new model-view, re-save the model and replace the model-view... I did read that this is common DWC error 😞

Anyway. Try to save-as new model-view (FACT-Level) and then replace in the model self the view. If that fails, first create new AM on top of the saved-as model-view. If that fails, copy and paste the SQL (or SCN/JSON if you have graphical view, find&replace the ID and re-upload the JSON back to create a new FACT view) 

The predicate could mean that you have a compounding key which cannot be resolved in AM for the AM-Association. 

Feedback if this helped. Cheers, Martin