topic Need Ideas for reduce Extracting time in QlikView

Need Ideas for reduce Extracting time

sathishkumar_go — Mon, 08 Nov 2010 10:27:53 GMT

Hi All,

I have 3 years data. Scheduler runs daily wise.every time qlikview read all the data. so qlikview takes more time for extracting.

what is the best solution for this? I need to reduce the extracting time?I already tried incremental load and its working fine.( now i am thinking without incremental load) what are all the possible solutions?

-Sathish

SV:Need Ideas for reduce Extracting time

Mon, 08 Nov 2010 11:33:48 GMT

Is it possible for you to do some pre-aggregation in your data source?

Does your historical data change? Maybe you could do some aggregation of your historical data and store it in QVD-files.

Need Ideas for reduce Extracting time

sathishkumar_go — Mon, 08 Nov 2010 11:55:38 GMT

Hi Vegar,

Thanks for ur reply.

if i go Historical data, suppose client update the last year data or last 2 year data? that time it will not reflect.

I want dynamic. every time enduser don't want to reload manually.

-Sathish