Skip to Content
avatar image
Former Member

min exception aggregation

Hi All,

I need to find a solution for a weird requirement. Simply, I need to find the customers whom bought a list of materials (all)

I could find an easy solutions however stuck at a point.

material infoobject A B

Sales infocube material quantitiy customer 1 A 10 customer 1 B 20 customer 2 A 30

I made a MP which include Material infoobject and sales infocube.

by making "Access Type for Result Values property to Master Data" for 0material in bEX, I could get the list of the materials which do not have a quantity. (customer 2 material B)

Multiprovider material quantitiy customer 1 A 10 customer 1 B 20 customer 2 A 30 customer 2 B 0

Once I define an exception aggregation (MIN) on quantity with 0material object and I was expecting to get below result.

Quey result minumum quantitiy customer 1 10 customer 2 0

However, I am receving below report output.

Quey result minumum quantitiy customer 1 10 customer 2 30

Any idea about this ?

thanks

regards

Berna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 20, 2015 at 03:18 PM

    Hi Berna,

    What is customer 1 and 2 here? are they info providers? or data of characteristic info object (ex: customer)?

    If it is a info object, then you can try creating a new formula --> Quantity then apply exception aggregation choose minimum and reference char as "customer (info object) " . You can suppress the result of material and see if it works.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Berna,

      yes, I do noticed it, it would be because material result areĀ  suppressed earlier. have you tried enablingĀ  result rows for both customer and material (hiding it from rows but result as display)? and then check the report result? it should work.

  • avatar image
    Former Member
    Oct 19, 2015 at 02:35 PM

    Hi Berna,

    From your above comments could understand that you have done the exception aggregation on Quantity with ref infobject as 0material. If you expect the minimum of Quantity based on the customer ,define the exception aggregation on Quantity with customer infoobject

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 02:45 PM

    Hi Berna ,

    Can you try creating a formula on the key figure .

    Ex KF1 = KF+0 . Then apply Exception aggregation .

    or

    Use Minimum / Minimum of 0 and Operand function from Mathematical functions section .

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sateesh,

      can not say I understand " Minimum / Minimum of 0" ??

      I already tried first option, but did not help ?

      regards

      thanks

      berna