ADB for YTD
We have run GL_ADB_CALCX everyday since 1/1/2011 for ACTUALSYTD using the following options for each business unit: Request Type is 'Calc End of Per', Period Type is YTD, Request Date Option is 'As-of-Date', As of Date is the current date, tree date optn is 'Use EndDt', Adhoc box is checked. We also calculate MTD and QTD averages in the same job for other ledgers. The processing time for the YTD ADB has increased from seconds to 8+ minutes since beginning of year. The concern is that the more journal rows added throughout the year will bring this process to an undesireable processing
0