Simple logical calculation of budget transfer
The below code is supposed to run in a second or two but it's running for 20-30mins and giving wrong results. It's filling all the cells. I checked and we have 10 dimensions in our FS cube and all of them are present. Not sure why and how it's still going out of range.
SET UPDATECALC OFF;
SET AGGMISSG ON;
FIX ("SAR", "OFS_Direct Input" , "Approved_Bud", "FY24", "No Miscellaneous")
"OEP_Plan"
(
IF (({V_Account_Source}->{V_Project_Source}->{V_Entity_Source}->{V_Period_Source}) - {V_Amount} <= 0)
@RETURN("There is no enough budget available to be transferred from this source combination", ERROR);
Tagged:
0