For the presentation in the form of Pivot tables and charts an Excel template named statistics.xlsx has to be created on customer side.

The template file statistics.xlsx has to be stored in the path under $CADENAS_SETUP\user\default_user\validator_reports_template.

With the first execution of the command Create class system for filters, the template file is copied to the user directory under $CADENAS_USER/validator_reports_template.

The configuration file createFilterClassSystem.cfg can be found under $CADENAS\libs\x86\64\plugins\createFilterClassSystem.cfg.

There, in the section [Settings], in the key STATISTICTEMPLATE, the path to the xlsx template file is set.

[Settings]
#:VALS_S
#:HELP;Maximum number of threads
MaxThreadCount=1
MAIN_REPORTS_DIRECTORY=$CADENAS_USER/validator_reports
STATISTICSTEMPLATE=$CADENAS_USER/validator_reports_template/statistics.xlsx

Note If the template file is missing under STATISTICTEMPLATE, in the dialog Extended ECLASS validation report, when clicking on Open statistics directory, the following error message is displayed:

In the dialog Extended ECLASS validation report, the path from MAIN_REPORTS_DIRECTORY is displayed under Main Report Directory.

The path statement under STATISTICSTEMPLATE determines the storage location of the Excel template file statistics.xlsx.

The directory names "validator_reports_template" in Setup and User directory have to match.

Furthermore the default path for statistics.xlsx should not be changed; otherwise updating of the Pivot table and chart with "Alt"+"F5" will not work.