ODAG - Performance tuning

[Manish]

Hi Guys,

I have created an app with ODAG  functionality to allow users to download big data but I have observed that ODAG- detail app which contains underlying data is taking time to get generated using app navigation link.

So, just wanted to know is there anything we can do to optimize this?

Time to generate detailed app using App navigation link from summary app : 15-20 minutes

Rows in QVD : 16 million approx.

No. of columns in QVD : 235

Looking forward to your response

Many thanks

Manish Kukreti

[JHuis]

Hello,

if you can use an where exist filter in the ODAG app it will go much faster. I did this 

selected_FIELDNAME:
LOAD * INLINE [
FIELDNAME
$(ods_FIELDNAME){"quote": "", "delimiter": ""}
];

and then at the fact Where exist.

(i think you are using a QVD for the detail fact table?)

[Manish]

Hi

Many thanks for your response.

Yes I am using QVDs.

Sorry but it would be really helpful if you could please share the sample code script  here? 

Many thanks

Manish Kukreti

[JHuis]

Maybe it is better that you give me some sample data. (dummy) 

i need a sample of the aggr data and a sample of the fact detail data, then i could make you an odag example inside two apps. 

Maybe this will help you? 

[Manish]

Hi @JHuis 
Thank you . I have attached sample apps with minimum data.

Looking forward to your response.

[JHuis]

Hopefully this helps.

You can do it like this, if you want to quick reload an QlikSense app with additional filtering you have to use Where Exist because this is the fastest way.