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

Modelling at report level

Hello, I have a question. I am loading some item level data but also looking into a header level table and doing a look up to populate one keyfigure in my item level table. Now, the problem arises when user DOES NOT drag ITEM NUMBER in the report. what happens is that the keyfigure get summarized. There is one keyfigure in this report which user does not want to see the item level data for and then there is this one. For example:

This is what my data looks like in my DSO:

Sales Document Sales Item KF1(HDR) KF2

101 1 $50 $100

101 2 $50 $150

so, when a user executes a report, if they bring in the item level data then they will have to add KF2 manually and if they take out Sales Item field then they will get the follwoing:

Sales Document KF1(HDR) KF2

101 $100 $250

so in this case KF2 is right but KF1 is wrong it should be $50.

If user brings out the sales item like mentioned before then, KF1 will be correct but KF2 will need to be added up.

I need to some how find a way where I can make the KF1 as stating once per Sales Document since document level will always have the single value.

Please help me if you can.


Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Sep 28, 2013 at 05:41 AM


    You just need to apply exception aggregation on KF1--Make a new formula --Put your kf1 inside it--Hit the aggregation tab--Exception aggregation as first value--Reference characteristic as ---sales item.

    Hope this helps.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 28, 2013 at 07:12 AM


    Just take KF1 and set exception aggregation to LAST with reference characteristic "sales item" This should solve it.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 28, 2013 at 10:08 AM

    Hi venkat,

    Your requirement can be easily achieved by exception aggregation concept. You have already got answers. Below doc is the comprehensive doc on the concept.



    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.