topic Re: Direct Discovery App Deployment in QlikView

Direct Discovery App Deployment

azmeerrehan — Mon, 04 Mar 2019 01:52:48 GMT

I have developed an app for real time data load using Qlik Direct Discovery. I reloaded the App on QV desktop it works perfectly fine. Now what are the steps on how will I deploy on Access Point so that when the user clicks on the App it will reload real time.

Any help is appreciated.

Environment QV enterprise server 12.20 (Nov 2017 Release)

Sample script in my app is

Test:
DIRECT QUERY
DIMENSION
DIM A
MEASURE
MEASURE 1

from ABC
EXIT SCRIPT;

Re: Direct Discovery App Deployment

Vegar — Mon, 04 Mar 2019 10:18:49 GMT

If you deploy it and reschedule it in the QMC the app will reload* as any other application. *) reload all but the direct discovery data

The Direct discovery is done when the user access the application and does not need any other configuration in QMC. User selections will query the database and return the Direct Discovery figures.

Good luck with your Direct Discovery app roll out.

/Vegar

Re: Direct Discovery App Deployment

anushree1 — Mon, 04 Mar 2019 13:27:27 GMT

Does this mean on QMC the load happens as per schedule and does not portray the real time data as and when it changes on Database and the direct discovery functionality of picking real time data changes from the database works only on Qlikview desktop

Re: Direct Discovery App Deployment

Vegar — Mon, 04 Mar 2019 13:35:00 GMT

I'm not sure how @azmeerrehan have configured his application, but normally you'll have an application where the most field and fields values are loaded regulary into the application as in a normal QlikView application, but a certain set of calculations queries are made agains the database on the fly using direct discovery.

Please read more on the topic in the Qlik Help - https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/DirectDiscovery/direct-discovery-introduction.htm

Re: Direct Discovery App Deployment

Rehan — Fri, 15 Mar 2019 20:39:17 GMT

Make sure you add this

SET DirectCacheSeconds= 5; Mine works fine after adding this

this clears the cache every 5 secs to reflect the new data. My script is exactly as you have . Mine works perfectly fine in Access point . The only limitation is that if any of the values in any of y our dimension changes then the App wont pick up because its already loaded into memory