APO Macro BUCKET_WDAYS()

[Former Member]

Hi Gurus,

In APO DP, we use a macro, BUCKET_WDAYS() , for work days calculation. This Macro takes Calendar as in input and gives the No. of work days for that calendar. In our case we have configured it like this.

BUCKET_WDAYS( CALENDAR( ACT_LOCATION ; 'SD' ;000) : Row: Final Fcst )

Here the macro CALENDAR returns SD calendar associated with the selected location and this is used as an input to find Work days by BUCKET_WDAYS. But when user selects multiple locations and pivots it, they see a 'Total level'. Since Total is not a location, Macro CALENDAR returns null. In that case BUCKET_WDAYS selects the time stream set in storage bucket profile as the calendar and gives work days for that. But in Our case, we dont have any time stream set for SBP. As the last Option, help.sap.com, says that this Macro will use 'Calendar Days'. But the actual data displayed in data view at Total level is not Calendar days. It actualy varies with work days displayed at actual locations for some buckets and matches in some other. As an example, for Nov 2009 work days for France is 20 days and at Total level it shows 21, which is not the Calendar days for Nov 2009.

Can anyone tell what Bucket this macro uses when no other bucket is available please.

Any hints are welcome.

Thanks,

Ganesh Pai

[Former Member · Accepted solution]

Hello Ganesh,

Try to execute the macro only at detail level of product location combination. Also, pls check the macro definition. I think Details only should be selected.

Please let me know if this is working.

Regds,

Ashutosh