Stock quantity

[Former Member]

Hi,

I have a requirement on stock cube where in I need to show the maximum stock quantity for a particular day in a month.

I can achieve this by using exception aggregation on the key figure. But the issue is when I drill down to see the calendar day, all the days in the month are displayed. I just want the display calendar day where the quantity was high. Any inputs are really appreciated.

Thanks

Annie

[Former Member · Accepted solution]

Hi Annie,

do you want to display last day of thae month when all values are aggragated or do you want to display a particular day on which corressponding stock value is greater compare to other days???

[Former Member]

Hey,

You can use 0cal_day as your reference characteristic for doing exception aggregation.

& use Excepton aggregation 'MAX'.

Please go through following link to understand more about it.

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0b8ed5b-1025-2d10-b193-839cfdf7362a?QuickLink=index&overridelayout=true]

hope this helps.

Regards,

Sandeep Palekar.

Edited by: SANDEEP1988 on May 27, 2011 7:06 AM

[Former Member]

Hi,

Thanks for the reply. I got the solution.

I used condition TOPN to display the date for my last value.

Thanks

Annie