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?