topic Scheduling QVD loads in QlikView

Scheduling QVD loads

Fri, 25 Mar 2011 13:36:26 GMT

Hello Experts,

I was wondering if we can schedule the QVD reloads to trigger based on an update in the Data base? I have something like the below code which is sent as an email soon as the DB updates the DWH cubes I am using:

SELECT 'Y'

FROM DUAL

WHERE EXISTS (

SELECT *

FROM w_onvglo_job_logging

WHERE progname = 'w_onvdwh_orders_pkg.summarise_orders'

AND TRUNC (log_end_date) = TRUNC (SYSDATE)

AND log_params = 'P'

AND log_success = 'Y')

Is there a way for the QV server to check that this flag is Y and then trigger the reload everyday?

Thanks in Advance,

ANDY

Scheduling QVD loads

Fri, 25 Mar 2011 15:35:21 GMT

Any takers please?

Thanks Again

Scheduling QVD loads

Miguel_Angel_Baeyens — Fri, 25 Mar 2011 15:42:06 GMT

Hello Andy,

You can create a very simple QVW file that is being reloaded continuously. This file only reads that flag. Then create another reload task but this one is set to reload "On event of another task" "Successful" and select the file that is reading the flag.

Hope that helps.

Scheduling QVD loads

Fri, 25 Mar 2011 16:00:54 GMT

Hello Miguel Thank you for the quick and the short yet correct reply. But I might comeback if there are more issues ;).

Thanks Again

Scheduling QVD loads

Wed, 30 Mar 2011 13:12:02 GMT

Hello Miguel,

I have the below code in one of my Flag.QVW's as posted here and the plan is to check for a flag Field "LOG_SUCCESS"
from DB which should be 'Y' for the PROGNAME 'w_onvdwh_orders_pkg.summarise_orders' and then I want the QVW to reload. After this I want a set of QVDs(or QVWs) to reload based on the sucessful reload of Flag.QVW

I am thinking this is simple, but isnt feeling confident doing it. Can someone please explain the process in a bit detail how this can be achieved?

Thanks a Ton in advance,
ANDY

LOAD
PROGNAME,
"LOG_START_DATE",
"LOG_END_DATE",
"LOG_PARAMS",
"LOG_SUCCESS";

SQL FROM
"OPS$WSFONV"."W_ONVGLO_JOB_LOGGING"
WHERE
PROGNAME = 'w_onvdwh_orders_pkg.summarise_orders'

Scheduling QVD loads

Miguel_Angel_Baeyens — Wed, 30 Mar 2011 13:59:01 GMT

Hello Andy,

The following should work, but the syntax may vary depending on the driver to connect to the database:

FlagTable:LOADPROGNAME, "LOG_START_DATE","LOG_END_DATE","LOG_PARAMS","LOG_SUCCESS";SQL SELECT PROGNAME, LOG_START_DATE, LOG_END_DATE, LOG_PARAMS, LOG_SUCCESS FROM "OPS$WSFONV"."W_ONVGLO_JOB_LOGGING" WHERE PROGNAME = 'w_onvdwh_orders_pkg.summarise_orders'; LET vFlagContent = FieldValue('LOG_SUCCESS', 1); // there must be only one record fetchedIF $(vFlagContent) = 'Y' THEN STORE FlagTable INTO Flag.qvd; DROP TABLE FlagTable; LOAD * FROM Flag.qvd (qvd);END IF

Hope that helps.

EDIT: revised code