Skip to Content
Former Member
Dec 15, 2006 at 08:12 AM

Multicube blank key figure


I have constructed a multicube on top of 0IC_C03 and my Material Forecast Cube.

When I want to calculate forecast accuracy I need 'consumption qty' from 0IC_C03 and 'forecast qty' from MFC cube.

My report gives Material records where 'consumption qty' is blank when there are no corresponding records in the 0IC_C03 cube for those materials while there was a 'forecast qty' in MFC cube. Similar phenomenon when there is 'consumption qty' but there is no 'forecast qty' the KF value for 'forecast qty' remains blank.

Is there a way I can default this KF value to 0 when no corresponding entry is found?