Forecast Summary CIM

[garypope]

We are using the CIM method to load up forecasts in fcs_sum table. However, the time it takes is frustratingly slow.

Can I "direct write" instead of CIM on this table ? Does it update other tables?
What are my options.?

We are using character Progress.

Thanks

 

[jamesmc]

direct writing into any table within any QAD could invalidate any support or warranties that you have with QAD, even if you are only updating a single table (with no risk of not updating other tables).

Having said that, if you dont have support or any warranties with QAD I would still say that you dont do any direct updates on data, however simple and straight forward they seem as you could never discount them from possible causes of errors further down the line!

Have you tried to analysis why the forcast upload is taking so long? Does it take long if you are typing them manually?

 

[cecsno]

The eB entity relationship diagram shows a 1 to 1 relation ship with mrp_det. I've seen a few sites that update fcs_sum directly.

 

[ovf]

The MFG CIM-loader is quit slow - but very secure!

Anyway the thing We normally do is somthing like:

/* Create Cim Data */

output to value(mfguser + ".tmp").
PUT UNFORMATTED
'"' part '" '
'"' site '" '
year skip.

do i = 1 to 52:
put unformatted
qty " ".
end.
put unformatted skip.
output close.

do transaction:
batchrun = true.
output to value(mfguser + ".out") keep-messages.
input from value(mfguser + ".tmp").
{gprun.i ""fcfsmt01.p""}
output close.
/* Check data is loaded correctly */
if check-ok = false then undo, leave.
end.

This will be a lot faster!

Ole