Jouni Turunen
Data & business architect
Asked a question 8 months ago
Is there a simple way to filter GoldenRecords that have MasterRecords from a specific source system?
Peter TseSEMARCHY TEAMTraining & Solutions Architect at SemarchyHi Jouni
You want to display in a business view those golden records that have master records coming from ONLY one Publisher. So if a particular golden is comprised of a master from two different source systems, we want to ignore those.
Let's say you want to view masters from CRM only. You also have other Publishers such as MKT and ERP.
The Root Filter for your business view is:
NOT ANY MasterRecords HAVE (PublisherID IN ('MKT', 'ERP') )
You can, of course, modify the Publisher list if you have other publishers.
Regards, Peter
Jouni Turunen 8 months agoThanks! This worked - my SemQL syntax was just worng (I tried MasterRecord.PublisherID = 'DYNAMICS' without luck)
Is there a simple way to filter GoldenRecords that have MasterRecords from a specific source system?
Peter TseSEMARCHY TEAM
Training & Solutions Architect at Semarchy
Hi Jouni
You want to display in a business view those golden records that have master records coming from ONLY one Publisher. So if a particular golden is comprised of a master from two different source systems, we want to ignore those.
Let's say you want to view masters from CRM only. You also have other Publishers such as MKT and ERP.
The Root Filter for your business view is:
NOT ANY MasterRecords HAVE (PublisherID IN ('MKT', 'ERP') )You can, of course, modify the Publisher list if you have other publishers.
Regards, Peter
8 months ago
Thanks! This worked - my SemQL syntax was just worng (I tried MasterRecord.PublisherID = 'DYNAMICS' without luck)