Scheduled Update for On Demand Table

[Amit Nex]

Can schedule update a dashboard with a On Demand table? How does it work?

[Olivier Keugue Tadaa]

Hi Amit

On-demand is usually used when the end user needs to refresh data upon performing a certain action in a certain context (e.g., marking, filtering, etc.).
The scheduled updates are meant to put data in the Web Player cache to avoid the end user waiting for that step.
Both would look a bit antagonist at first sight.

However, if you explain your use case we might be able to find a way to trigger an on-demand refresh when the scheduled updates process runs.
 

 

[David Boot-Olazabal]

Hi Amit,

If you want to know if it is possible to schedule an update for an analysis file that has also on demand tables, the answer is yes. When scheduling an analysis file, all 'normal' tables will be refreshed at the time of running.
On demand data tables will not be refreshed, since they will only 'act' whenever they are called upon, as Olivier pointed out.

I have done this many times at customer projects and also in my own test environments.

You can just start scheduling your analysis file via the administration console and let it run in the server. When you then open your analysis file, you will see that the data is loaded from the cache, for all tables except the on-demand ones. The latter will only load data, when they're getting triggered.

Kind regards,

David

[Amit Nex]

Hi @David Boot-Olazabal

Thanks very much for the answer. I was worried as how the table with On-demand would behave when I put the dashboard on the Schedule Update.