Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
A bit of background first so you can understand better where this question is coming from...
We are expanding our use of QlikView for these reporting tasks, but are becoming hampered by our internal processes and are looking for alternative solutions for triggering applications.
One option I've thought of is to leverage our BPM tool that will submit job requests as simple database records that indicate the reporting job (dedicated qvw for each job) and any parameters that are required. From there a master .qvw file scheduled to run every minute will poll that table and trigger each on-demand.qvw as indicated from the job request.
This will enable us to fully automate qvw execution without a ticket being submitted, if it's possible. And we will only need to submit tickets for development changes to either the master qvw or a reporting qvw, but not for simple on-demand reloads or triggers. This would obviously be a lot less complicated if we were allowed to access the QEMC directly, but that is not going to happen.
1) Is what I'm thinking theoretically possible?
2) If so, does anyone have thoughts about how that might be accomplished?
and most importantly
3) Am I overlooking a much more simple way to solve our issue?
Your thoughts and ideas are much appreciated.
What you are describing is EDX. See this paper.
You can trigger server tasks from your desktop and pass parms.
This assumes you can get your prod infrastructure team to go along with this, as they will have to enable the security group on the server.
-Rob
Not sure I follow 100% but you can trigger reloads of other QVWs from a master QVW using the button action "Launch" and then setting the Application to the full path of the Qlikview.exe and then in the Filename you would put the full path to the QVW and pass the Parameter /r but I think this may only work locally and not on a server.
Christian, thanks a lot for responding. I'm really looking for a solution that doesn't require any user interaction through the UI. These apps will all be running on our QV server, and I was hoping to execute this all via script or macro.
No problem Jon, sorry that doesn't help much. Other possible option outside of QV would be executing a batch file (.bat) that simply contained "C:\Programs\Qlikview\QV.exe" /r "C:\MyDocs\MyQlikviewDoc.qvw" however not sure if you'd have the appropriate permissions to execute on the server. Hope ya figure something out!
Great out of the box thinking, but even the group that handles our tickets can't access anything on the server except for the QEMC. Gotta love the enterprise environment...
What you are describing is EDX. See this paper.
You can trigger server tasks from your desktop and pass parms.
This assumes you can get your prod infrastructure team to go along with this, as they will have to enable the security group on the server.
-Rob
Thanks Rob, that looks like exactly what is needed.