Can Cycling feature generally slow down report publishing process?

[jblomqvist]

Hi,

Recently I built a sales report that was not using cycling functionality.

Then the user requirements changed and they wanted seperate reports by Country in seperate documents.

The solution for this is to use Cycling. However I noticed, my reports take much longer to process by a publishing task. Of course there are other reports that publish too so it might be multiple tasks running at once might also play a role?

Is this generally to be expected that Cycling slows down the report production process?

[Ruggero_Piccoli]

Yes, it is expected that cycling slow down the production process. The same is for Levels and Pages.

The reason is that they are filters. So, in your case, Qlik NPrinting applies a filter for, for example USA and generate the first report. Then it applies the filter for Germany and generate the second and so on. For every report you have to wait the filter for country calculation and this requires time.

If you need to keep cycles and you want to speed up the generation process you could:

- create a document only for reporting and include in it only data and charts that are necesary for reporting

- save the document with charts minimized

- avoid calculated columns in charts. Insert the calculations in the load script instead.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.