Improving analytic performance

Analytic scripts that access data tables on AX Server use the AX Connector to extract data. Minimizing these transactions is a recommended way of improving the performance of your scripts.

Optimize the performance of analytics by minimizing the number of times tables on AX Server are accessed:

Use the FILTER command to select the records you need.
Use the EXTRACT command to extract only the required fields.

The reduced data set will be processed locally on the server where the analytic is being run by the AX Engine.

Optimizing analytics in this way is important when the data files are not located on the same server as AX Server or the AX Engine Node processing the analytic, and the Copy analytic data option is not selected in the AX Server Configuration web application.

Inefficient analytic example

OPEN LargeTable 
SET FILTER TO trans_date >= `20091201` AND trans_date < `20100101` 
COUNT 
TOTAL amount 
CLASSIFY ON account ACCUMULATE amount TO TransClassAccount

Efficient analytic example

OPEN LargeTable 
SET FILTER TO trans_date >= `20091201` AND trans_date < `20100101` 
EXTRACT FIELDS trans_date desc account type amount TO AnalysisTable 
OPEN AnalysisTable 
COUNT 
TOTAL amount 
CLASSIFY ON account ACCUMULATE amount TO TransClassAccount

[ Back to top ]