Skip to Content
0
Former Member
May 09, 2008 at 09:40 PM

Infoset result

20 Views

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,