I'm searching for a solution to schedule multiple tasks with dependencies. I have an application called SalesThruMargin.qvw that depends on many different sub executions of QlikView. The top level application called SalesThruMargin.qvw is the application that gets distributed to the Qlik Access Point. It does a binary load of "Qlik Mart Generator - SalesThruMargin.qvw". That in turn relies on QVD files transformed by application "QVD-Transformation - SalesThruMargin.qvw" and that application relies on 10 different applications that generate qvd files from source data sources.
Also, since many of the source qvd files are used in several other top level applications I would like to have a threshold for reloading them. Example, if the Calendar.qvd was already reloaded in the past 24 hours mark the task successful and don't reload it.
As a bonus, some of these tasks I would want to run in parallel.
Top Down my qvw application dependency looks like this:
26.SalesThruMargin
\1.Application\3.MartApplication\SalesThruMargin.qvw
\4.Mart\Qlik Mart Generator - SalesThruMargin.qvw
\1.Application\2.QVD-Transformation\QVD-Transformation - SalesThruMargin.qvw
QVD File Name | QVD-Generator |
Calendar.qvd | Calendar.QVD-Generator.qvw |
Customer.qvd | Customer.QVD-Generator.qvw |
BusinessUnit.qvd | BusinessUnit.QVD-Generator.qvw |
MetricLibrary.qvd | QVD-Generator-MetricLibrary.qvw |
PartCharacteristics.qvd | QVD-Generator-PartsCharacteristics.qvw |
Company.qvd | Company.QVD-Generator.qvw |
BusinessDayCalendar.qvd | BusinessDayCalendar.QVD-Generator.qvw |
SalesBacklog.qvd | QVD-Generator-DataWarehouse.qvw |
SalesBudget.qvd | QVD-Generator-DataWarehouse.qvw |
SalesShipments-ThruMargin.qvd | QVD-Generator-Sales Thru Margin - with Incremental.qvw |
Can I do this in publisher?