Creating the Feeder Statement to Feed

Follow the steps below to create the feeder statement that feeds Planned Production Qty -Kgs in the Plan cube.

Procedure

Double-click the Plan cube in the Server Explorer.
If it does not already exist, insert a SKIPCHECK; declaration immediately preceding the single calculation statement in the rule.
Insert a FEEDERS; declaration following the calculation statement.

Enter the following feeder statement immediately following the FEEDERS; declaration:

['Planned Production Qty -Kgs'] =>DB('Plan', !CakeType, IF(DIMIX('month',!Month)<12,
DNEXT('Month',!Month), 'December'),'Planned Production Qty - Kgs');

The complete rule for the Plan cube should now appear as follows:

SKIPCHECK;

['Planned Production Qty - Kgs']=IF)(DIMIX('Month',!Month)<DIMIX('MONTH',
DB('CurrentMonth','aNumber','aString')),DB('Production',!CakeType,
!Month,'Quantity Produced - Kgs'),DB('Plan',!CakeType,DIMNM('Month',
(DIMIX('Month',!Month)-1)),'Planned Production Qty - Kgs')*
[Adj. % from last month']); FEEDERS;

['Planned Production Qty - Kgs']=>DB('Plan',!CakeType,IF(DIMIX('month',
!Month)<12,DNEXT('Month',!Month),'December'),'Planned 
Production Qty - Kgs');

Click Save.