Key Figure Question...

[Former Member]

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

[Former Member]

Exception aggregation: Determines how the key figure is aggregated in the Business Explorer in relation to the exception characteristic. This reference characteristic must be unique in the query, like time.

Here you would determine a time characteristic as an exception characteristic with, for example, the aggregation Last Value (LAS)- The last value in relation to the reference characteristic is displayed in the results row.

[Former Member]

Hi,

U can do this with the non cumulatives..

Go through the link

http://help.sap.com/saphelp_nw04/helpdata/en/8f/da1640dc88e769e10000000a155106/content.htm

<b>Non-Cumulative Management with Normal Key Figures (Cumulative Key Figures):</b>

Regards

Siddhu