Sometimes we need certain important favorite reports and/or dashboards to be refreshed with a high frequency, whilst the rest of favorites are not as prioritaire. If we do not prioritize, then the important reports or dashboards will have to wait until all the rest are refreshed.

Then: how do we prioritize reports and/or dashboards?

Priority is set up by programming in Windows different tasks to refresh reports. This can be done from the reports tab in the console with the button to schedule in Windows the task to refresh (cache) reports. Please note that this button will create only 1 task per company, and therefore, you might need to create manually a new one.

By double clicking in the Windows programmed tasks you can add 2 parameters to it (once we finish there will be 4 parameters, but the first 2 will be there when we edit the task), separated by 1 space character, like this:

These 4 parameters are:

  1. The IP address of the database: 127.0.0.1 in the image.
  2. The IP Port of the database: 10000 in the image.
  3. Optionally, the list of the IDs (separated by comas and without any space character between them) of the favorite reports that we want this task to refresh (ids 1 and 2 in the image). This way this task will only refresh the favorite reports which IDs are indicated in this parameter.
  4. Optionally, the list of the IDs (separated by comas and without any space character between them) of the favorite reports that we want this task to NOT refresh (ids 3 and 4 in the image). This way this task will refresh all the favorite reports except those which IDs are indicated in this parameter.

These parameters are exclusive between them, this is, you cannot use both. Let us see a typicall example: if we want a programmed task to refresh with high frequency the favorite reports with IDs 1 and 2, and another task to refresh less frequently all the rest of the favorites, except the 1 and 2 which are more important, then we should create 2 tasks like this:

  • One, with high frequency, and these parameters: 127.0.0.1 10000 1,2
    This way this task will only refresh favorite reports with ID 1 and 2.
  • Another, with less frequency, and these parameters: 127.0.0.1 10000  1,2
    Please note that there is 1 (and only 1) space character in the third parameter, where in the previous task was 1,2. In this way, this task will refresh all favorite reports except those with IDs 1 and 2.