Skip to Content
0
Former Member
Oct 17, 2005 at 08:42 PM

Key Figure Question...

64 Views

Billing INfoCube has the following fields:

Sales Employee, Region, Calendar Month, Net Value and Projected Sales. All fields with the exception of Projected Sales are directly mapped from the main Billing ODS. The Projected Sales is custom abap written to retreive the projected sales amount based on calendar month + employee in the Projected Sales ODS. The problem is that the load from the Main Billing ODS to Billing INfocube may have, for example, 11 records for the the calendar month 2005/10. The net value adds up fine, but the projected sales is multiplied 11X. ONe for each billing record that is read and loaded from the ODS to the InfoCube. I don't want the Projected Sales to add up. In the Projected Sales ODS there is only ever one combination of employee + calendar month = Projected Sales amount for that employee for that particular calendar month.

Question is: How do we not have the key figure add up for each billing record that it retrieves?

Appreciate any feedback