Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paputzback
New Contributor II

I have a question about scheduling

We are planning on developing a two tiered QVD architecture. We will build a QVD Generator App for each table we want to report on. Then, build our presentation layer off of the QVDs. We want to go this route of using a one to one QVD Gen App to Source table to avoid developers being restricted from working on a QVD Gen App while another may already be in it Also, this allows us to easily track down a failed task and rerun the QVD Gen App.

Now the problem is, how do setup the tasks to run 70 QVD Gen Apps 7 days a week and then when they are complete, the Presentation QVWs kick off. I think we have this sort of figured out. But then next thing we are trying to plan for is the weekly and monthly loads.

Let's say it is Sunday, and we don't want the Presentation layer to run until both Daily and Weekly have completed. So in my Presentation Layer QVW I create the trigger On Multiple events completed and add two Task Completed - Task finished triggers based on Daily QVD Load and Weekly QVD load. That works fine. Now it is Monday. The task will never run because the weekly won't trigger a task finished event since it does not run on Monday.

Then to really throw a loop, when a monthly QVD runs how do you handle that in the Daily Presentation Layer task?

Tags (2)
2 Replies

Re: I have a question about scheduling

In what exactly are the Weekly and Monthly loads different from the daily loads that you run 365 times a year?  Wouldn't it be better to use a single daily task, and create new objects in your presentation layer that report on the last complete week/month? It would be simpler to manage, I'm sure.

paputzback
New Contributor II

Re: I have a question about scheduling

I am wondering why would we would have separate ones myself. It was one of those plan ahead meetings, and the weekly and monthly topics came up as a what if scenario.

Community Browser