Let's face it - it usually takes a bit longer for features and capabilities of any product to gain traction in an organization. We released On Demand App Generation in 2018 with our Qlik Sense client-managed edition. Frankly I don't have much insight into whom has or has not implemented it. BUT, I can tell you from those that I have spoken with over the years, many were surprised to even see this awesome feature in the product when I brought it up.
However, in older versions, in order to enable it - there were a number of requirements which involved copying data load script along with inserting bindings and variables - which at first glance could be perceived as cumbersome. Even the first time I worked with it, I was a bit overwhelmed. This was true for others as well, so much so, that some Qlik enthusiast even developed web app add-ons and extensions to simplify the process and generate the template for you.
BUT....... since the release of ODAG, just like anything else, it has evolved and is now extremely simple to enable and implement. I show you this process in my latest Do More with Qlik (archive link below) session and summarize the ODAG concept in the latest Qlik Sense in 60 video embedded in this post - so please be sure to check them out. Let me know what you think in the comments below. Stay tuned to my next post where I build on what we learned about ODAG to introduce you to Dynamic Views!
On Demand App Generation - (ODAG - concept)
In summary, ODAG was originally developed to meet the need of analysis of very large data sets. The concept is quite simple:
One Qlik Sense app displays summarized data with filters from the big data source.
You select the filter values and reduce your answer set to meet a defined row count constraint.
You click the app navigation link along the bottom to open the ODAG panel
You click a button and a new more detailed app, dynamically built from a template, is generated directly from the source data with applied filters and defined metrics at a much more detailed level. That's it!
ODAG Requirements Summarized
Qlik Sense base app (contains summarized measures as KPIS and desired dimension values as filters)
Summarized data
App Navigation link - linked to 2nd Qlik Sense template app
Defined row count constraint
App retention setting
Qlik Sense template app (contains detail KPIs and detailed analysis metrics)
Activation script with binding syntax
WHERE conditions with odag_ binding variables added to query
Qlik Sense in 60 - On Demand App Generation (video)
Sample Apps attached - ODAG - Apps - Taxi Trips.zip - (Note you need to add your data connection and access SQL etc to your data sources)
Can't see the video? YouTube blocked by your region or organization? Download the .mp4 attached in this post to view this on your computer or mobile device.
@Michael_Tarallo ODAG Apps are matched with the GUID of the App. How do i migrate ODAG Apps(or dynamic views) from one system to an other without a rebuild of this links? (Test Environment to Production)
Currently we have no solution for this. Things getting worse if you use dynamic views, you have to rebuild your linked App Objects...
Best example: ODAG - Apps - Taxi Trips.zip If you migrate it to you system, you have to delete der ODAG Link (invalid object) and recreate it. (on our Qlik Version)
I think both variants should be included. 🙂 A configurable AppID is nice, but you are still not able to just migrate your ODAG Concept like any other App. You have to reconfigure it every time you migrate.
Heading into the upcoming post about Dynamic Views, those sure would be a lot more useful (for me, at least) if they could include certified third-party extensions from Qlik partners and not just the native and bundled objects. Is that in the roadmap, by any chance?
The on demand webinar links dont seem to work. After registering, when i begin to view the webinar it keeps rejecting the email address. Could you please help.
the On24 URL of the webinar thats showing the message.
Hi Aadil - I have only seen this when the wrong email address was used - I believe you need to use the original email address that was used when signing up. I will have my program manager also look at this.
Michael, Is there a way to pass variables from a selector app with an ODAG, that are NULL? In my selector app, I have situation where some selection app filters are not populated or greyed out. When I run the ODAG, I get no results.
Suggestion on how to be able to return results even when a selector app filter does not meet any criteria after make other filter selections?
is it possible to load data from an existing app instead of from QVDs or DB when ODAG app is generated?
our issues is, we have hourly incremental load for QVDs, therefore QVDs will not be available to reload data to ODAG while they are updated by incremental load. I am looking for solution to load data from in memory of template app or an existing app so that we will not need to hit QVD files during ODAG app generation.
0
Likes
710 Views
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
