topic Re: Load multiple qvd dependencies files from one qvw in QlikView

Load multiple qvd dependencies files from one qvw

Tue, 15 Jan 2013 15:12:35 GMT

Hello wonderful community,

I have a qvw document which has 10 dependent QVDs. Rather than create 10 taks in QMC, is there a way to create one task that will load all dependencies?

I know I can create tasks that will run upon the successful completion of another task but this is still clunky and clogs up the QMC task list.

In development my solution was to simply create a batch file that reloads all dependencies, I was thinking of executing a batch file from within a qvw but I am sure the community can come up with a more elegant solution than that??

Thanks lovely people

Re: Load multiple qvd dependencies files from one qvw

Tue, 22 Jan 2013 10:47:44 GMT

Hi all

Disappointing response so far guys, have to be honest 😞 (that’s a sad face right there)

The best solution i have come up with so far is to fire off execute statements like so:

EXECUTE c:\Program Files\QlikView\qv.exe /r c:\reports\reloadtest.qvw

The reload works fine in desktop mode, however, when run via a distribution task the load fails. Each dependent qvw file just hangs.

Any ideas most welcome guys.

L for love

Re: Load multiple qvd dependencies files from one qvw

paputzback — Wed, 21 Jan 2015 19:37:09 GMT

No response?

Re: Load multiple qvd dependencies files from one qvw

Wed, 21 Jan 2015 22:21:58 GMT

Hi Andrew,

You have at the moment 10 seperate qvw's each generating just one QVD?

Is there a reason why you cannot create a single QVD builder QVW for all 10 of the required QVD creation?

Or at the very least group up some of the QVD's into common qvd builders.

One qvw for all fact QVD's, one qvw for dimension QVD's

Joe

Re: Load multiple qvd dependencies files from one qvw

paputzback — Wed, 21 Jan 2015 22:57:55 GMT

Joe,

What happens when one QVD fails out of many in a builder. If you rerun the QVD generator does it know which QVDs were already ran? Is there a best practice for how many QVDs should run at once? And I can't remember if the scripts run sequentially in a QVD Generation app. We took training a few months ago and then started work on the data warehouse and are several months away from getting to the QVD side of the project. Once of those cart before the horse plans.