Dear SDNers
I have an infoset with CRM Marketing element Master Data, an 2 ODS objects, one of them with a Left Outer Join and another master Data Business Partner.
Now, I have 2 Direct Key Figures PLN Lead count and Forecast LEad Count.
Due to the Join conditions, there are more than one record for a given PLN Lead value or Forecast Lead value. For eg. If the original Master Data record has a value of 500 , and the Infoset join has 4 other corresponding records (Like Header and Items data).
How do I get the query to display the value just once i.e 500 and not 2500? Will a CKF help? If so, how?
Any help would be greatly appreciated.
Thanks,