Scheduling of reload of data
Answered
Hello everyone,
do I have the possibility in Analytics to schedule the reload of the data, e.g. once every night instead of every time when a user opens a report?
As I understand the "normal" scheduling is just like an Mail with always up to date data.
Thx and regards,
Daniel
-
Daniel, What your looking for is that the report should work as static page for the whole day except for the first time when loaded.
Example , Any one of the user will open the report in morning. Report will behave like normal loading data from Database. After this if any user opens the report, it should show the same old report which was loaded before instead of getting data from live Database.
There is auto refresh configuration which can be set to one day but that will apply only for idle tabs. If you reopen the link or reload the report it will get live data again.
I have not read any such feature in Analytics. However you can achieve this using Database itself. Instead of actual Database and tables you create a report against another custom Database. This custom Database can be setup with some SQL jobs to get refreshed once a day.
-
Hi,
Once the report is opened/page refreshed/apply filter clicked, it always shows “fresh data” as it fetches the data at that time. Scheduling is like you said, just sends fresh data via email. You can put a value in update interval fields as depicted below to refresh it every night and keep the browser idle after that. But once you open the report again, you will get fresh data only. Another workaround might be that you can export the data anytime in excel/pdf and work with that throughout the day and for the next day, again can do the same.
Please sign in to leave a comment.
Comments
2 comments