Business rule run time takes long
Summary:
We have added 2 new dimension Future1 and Future2 recently. Earlier this script runs 45 mins now it is taking 1.2 hours. User is complaining the run time. Is there anyway we can reduce time?
Content (required):
Set Aggmissg On;
FIX (,&prioryear,&Curryear,Actual,@Children("Ledgers"))
agg (Company,Allocation,"Allocation Code","Cost Center",LOB,Location,Future1,Future2);
ENDFIX
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0