Qlikview Dashboard without In-memory (QVD) and without source cache

[Anonymous]

hi Team,

I am an business analyst and don't have expertise on Qlikview.

Scenario we have is there is a database, a virtualization tool (like Denodo) and final reporting to be done in Qlikview. 2 cases.

1. Denodo will pull some relevant data from database in a Denodo view and store it in Denodo cache. There will be a job which will run in Qlikview once a day which will read this view data and store in Qlikview in-memory (guess QVD file, not sure about exact name). Qlikview dashboard reporting will pull data from this in-memory and display to user. This is working fine.

2. Adhoc scenario. User can query anything from the database. So we cant keep data in Denodo view (coz it will mean entire data). Hence we cant cache in Denodo. When user selects some input from Qlikview screen, then that input parameter needs to be passed to Denodo, then Denodo will runtime query database based on that input and fetch the data in Denodo view. This data needs to be displayed to user. Hence, for this Adhoc scenario, data cannot be stored in Qlikview in-memory (QVD file). My query is it is easily possible in Qlikview development or very complex ? Any downsides to this of bypassing in-memory.

Please share some details as our QV dev team is not sure on this as normally we have also been using in-memory based reports.

Regards.

[ychaitanya]

there is a work around what we could do.

1. We can take the selections in Qlikview and store that value into text document by using STORE command.2

2. Create some watcher script(batch) in the folder where Qlikview places the file, then take that input file and read and create the Denodo query dynamically and store in the cache.

3. Once this is finished from dB, we can place some touch file at some other location where the QV reads the number of files in that location.

4. We can setup in Qlik to reload based on the file created at that location.

Although this process takes 5-10 mins Turnaround time , we can't help.

(OR)

we can use the concept of DIRECT DISCOVERY in Qlik to run the dB Commands on the fly.

Thanks

CY