Unable to create blocks for Allocation Logic
Summary: Unable to create blocks for Allocation Logic
Only Period and Account are Dense and rest of all are Sparse.
FIX(&CurYr, &CurMnth,"Actual","Final", @RELATIVE("All Entity",0),"No Entity", @RELATIVE("Total Department",0),@RELATIVE("Total UnitCode",0), @RELATIVE("Total Location",0),"No Location",@RELATIVE("Total Intercompany",0) ,"No Intercompany",@RELATIVE("Input Currency",0),"No Currency")
/*----------------Block Creation----------------------------*/
Fix("Actual","Final")
"82111019" /* Account Dim Member - Dense*/
(
IF ("MI_Alloc_%"->"No Book"->"No Location"->"No Currency"->"No Intercompany"->"No Entity" <> #Missing)
"MI_Alloc_Reporting" = 1;
"MI_Alloc_Entered" = 1;
"MI_Alloc_Accounted" = 1;
EndIF
)
ENDFIX
/*----------------Target Data Clear----------------------------*/
Fix("MI_Alloc_Reporting","MI_Alloc_Entered","MI_Alloc_Accounted")