partial reload?

[canariam]

hi all again,

i know a lot of topic about this issue.i read most of them but i couldnt find my answer.hope that you can help me.

i have a big report and it is being reloaded daily by qv server.there are lots of queries but one of them has a dynamic structure and is need to be reloaded in each 15minutes.i mean i want to reload my whole report daily but just one of the query in 15minutes without reloading the whole report.

i can get it from qvd or just sql statement depending on your solution.

is there a solution for my problem?

thanks in advance,

[fernandotoledo]

you will need to reload your whole report every 15 min after all.

but you can create two aditional QVW´s, one will reload daily, the other every 15 minutes. They´ll generate all tables used in your report as qvds.

then your report should read from the qvd´s after the 15 minutes´s qvw runs

[canariam]

thanks a lot for your answer.but as i said it is a big report and use already lots of qvds.even though getting data from qvds, reloading lasts 20mins or more.even if i tolerate this, it means that server works nonstop just for a report.

there is one more question then.can a report display a sheet of another report as own sheet? i dont mean that linking with web link.it causes opening the targetting sheet in new browser page.can it be possible?

[#4]

there are a few ways I can think of to get around this. Probably the easiest would be to create two seperate 'data loader' QVWs.

1) The first handles all of the 'big' stuff that only needs to be reloaded once per day.

2) the second is the 'every 15 minutes' portion.

Each of these QVWs dumps the results of the data pulling into QVDs, which your main application uses for its data source.

You reload the master every 15 minutes (after your every 15 minutes task runs), and set the other to run once a day, and let the every 15 pick up the new data when its available.

[#5]

I realize I just totally repeated the other poster... sorry.

In answer to your other question: can you show one sheet from one QVW inside of another qvw. The short answer is no. But the longer answer is that you can use the first qvw as a data source, which the second QVW can load from. You can then copy the page you want to display from the first QVW into the second, and preserve its display.

[#6]

Hi!

I think you should use "ADD" prefix on your load and use partial reload. Check the description of ADD in QlikView Help to have a better idea..

-Lester

[canariam]

thank you guys.you helped a lot as always you do.byee