Reload running Dashboards on server via OCX

thorsten_edler — Tue, 15 Apr 2014 08:02:32 GMT

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

Re: Reload running Dashboards on server via OCX

Tue, 15 Apr 2014 08:25:53 GMT

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.