Skip to Content
author's profile photo Former Member
Former Member

Key Figure Question...

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 17, 2005 at 11:25 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2005 at 12:03 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.