Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have some already running Dashboards on a server.
The reload is currently controlled by the Management Console.
Is it possible to reload those Dashboards via OCX Components and if so how do I adress their instances at runtime ?
I would like to reload only if the underlying SQL Server Data Warehouse is up to date, that means its generating procedures ran correctly.
What I have in mind is to have a SQL Procedure that starts a VBS on the server that starts the reload of the Dashboards on runtime ?
Or is there a even better way to do that ?
Greetings
Thorsten Edler
What we do is
first, check whether the dashboard already refreshed. (by record a flag date in csv file.). if yes, exit, if no, go on.
then check whether database is up to date by sql or stored procedure in script, if yes, go on, if no, exit.
the reload process is called by batch file. the batch file will be triggered several times in one day.