Skip to Content

Key Figure Aggregation

Hi,

I want to avoid key figure aggregation in Bex 3.5 query designer. How to do this. It sums up and shows me a total. I want to avoid it.

Thanks

GS

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Aug 24, 2013 at 02:15 PM

    Thanks Guys

    But my scenario is as below:

    MAT OPERATION ORDER PLANT RESOURCE UNIT QTY 100006809 100000422478 8 KG 517 100006809 1 100000422478 8 B1153 KG 517 100006809 2 '100000422478 8 C1546 KG 517 100006809 3 '100000422478 8 B1153 KG 517 100006809 4 100000422478 8 C1546 KG 517 100006809 5 '100000422478 8 B1153 KG 517 100006809 6 '100000422478 8 C1546 KG 517

    In the Query 3.5 I dont want to sum up Resource, I want to show only 2 rows

    B1153 517

    C1546 517

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Anshu,

      December 15, 2013 Dec-2013 Jan-2014 Demand 39,904 38,150 16,974 Supply 27,962 42,027 32,390 Projected Inventory 25,401 29,278 44,694

      Example: Projected Inventory for Dec-2013 & Jan-2014 = Prev Period Inventory + Current Period Supply - Current period demand: 29,278 = 25,401 + 42,027 - 38,150

      How can i use the previous values of inventory to calculate the next on the fly in query designer 3.5

      Thanks

  • Posted on Aug 24, 2013 at 02:09 PM

    I think what you're looking for is Exception Aggregation. It works a bit differently in 3.x than in 7.0, and I can't seem to find the documentation for it, but here's a post on how to do it:

    http://scn.sap.com/thread/408808#4730386

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 24, 2013 at 08:00 AM

    Hi

    You can supress result rows in query designer on the infoobject you don't want to sum up.

    Martin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 24, 2013 at 08:21 AM

    Hi,

    What you need to show instead of that...Do you need to supress the result rows ?

    Regards,

    AL

    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.