Reload Dashboards After a Data Warehouse Load

[#1]

Hello

I'd like to reload the dashboards on our web server only after a successful load of the data warehouse. We have Enterprise v9 SR3.

If someone could point me in the right direction I'd be grateful. It can be push or pull but the simpler the better.

Many Thanks

Paul

[johnw]

I don't know the details unfortunately, be we do trigger reloads in Publisher based on the completion of data loads in our business system. We do it by sending an EDX message. In Publisher, we use the EDX message as a trigger for the reload.

[rwunderlich · Accepted solution]

1. Define the reload task with a trigger of "On an external event" (EDX).

2. Add a step to your data warehouse job flow that triggers the task. The specs for this can be found in the QVS ref guide in section 26.2 "Triggering EDX Enabled Tasks". You can find sample code here on the forum and I can provide samples as well. The code you use (VBS, java) is dependent on the OS where you make the call from.

-Rob

[#4]

Thanks Rob and John.

Rob we use SQL Server Integration Services to load the warehouse so I'm hoping I can embed some VB script at the end of the routine. A sample would be much appreciated.

[rwunderlich]

Hi Paul,

Here's a VBS script that can trigger an EDX task on QVS V9. Instructions are in the file.

-Rob

[mike_garcia]

Hi Rob, Thank you for providing the script.

I'm having an issue when trying to run it, I hope some of you who have already used it can help me. Here is what happens:

I did a test on my laptop, with a local QV Server, via command line and the task was executed. Great!

BUT then I tried to do the exact same thing with an alternate user on the same laptop and member of both, Administrators and QlikView Administrators, groups (So it has the same permissions) and the task was not executed. I got an error of msxml3.dll: Access denied for line 71 that issues the following command:

xmlhttp.send requestData

I just left everything running for the first user and then "Switched" user. If I tried to log off from the first user and then log on on the second I got an error of File Not Found (not the vbs but some of the files it uses).

I do have access to the local server. Also, I'm using Windows 7 and cannot change the permissions for that DLL file, which is found under the Systme32 folder. All the options to set permissions are grayed out when I click on Edit (Permissions) or Advanced... However, I dont think it is a matter of FILE permissions, because as I said, both users have Administrator priviliges and both have Read and Execute Permissions on that DLL.

Another thing I tried was to change Internet Explorer options, add the site to Trusted Sites and enable "Access Data Sources across domains" and I believe all of the ActiveX permissions.

What can I be doing wrong? Any idea is appreciated.

Thank you!

Mike.