(Re)fresh DataSet for reports

[cnisparnorddk]

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?

[cnisparnorddk]

@KennethB @mega Are you looking here?

[cnisparnorddk]

It sounds perfect 

[BenAvdicevic]

@cnisparnorddk 
Exactly.  We are facing the exact same issue.

We have some public reports which were built from a DataSet.

After pressing the "refresh" button - it takes 2-3 minutes for report to display with freshest data.

When viewing the report - HOPEX doesn't display "date of last refresh"   So, user doesn't even know how current the data is.

I would state the requirement like this: 

• For reports built from DataSets, TreeSets, GraphSets:
  • User viewing the report - needs to see date of last data refresh
  • HOPEX Admin should be able to setup report auto-refresh  (i.e. hourly/daily/weekly) - so that HOPEX users do not have 'refresh' the report every time they open it. 

@KennethB Any suggestions appreciated.

[cnisparnorddk]

Will this give us updated dataset, or only keep old data in the dataset?

We need fresh data in our dataset in this case.

[AHassan]

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