‎08-03-2024 12:36 PM
I have a reqeest from users that says it is a problem, that they should wait for report-updates.
Sometimes report updates can take several minutes i HOPEX.
Are there any way you can refresh reports using the scheduler in HOPEX, so they can be refreshed during the night?
‎18-03-2024 09:41 AM
Will this give us updated dataset, or only keep old data in the dataset?
We need fresh data in our dataset in this case.
‎14-03-2024 11:48 AM - edited ‎14-03-2024 12:00 PM
It could be possible with a macro attached to a trigger but refreshing all the reports based on Report Datasets, at the same time, can easily choke the HOPEX/SQL server, since Report Datasets can be very resource demanding.
However you can optimizing the Report DataSet Definition for better performance by:
"Keep the last generated Report DataSet":
Select the Keep last generated result option so that at next session, the first Report DataSet display time is shorten.
Time monitoring:
To identify the column that may introduce performance issues, use the debug log to find out how long it takes to get each column.
[Debug]
ReportDataSetGenerationTimeMonitor=1