topic Frequently Updating section access in QlikView

Frequently Updating section access

Wed, 09 Dec 2009 03:05:40 GMT

Hi.

What is the best practice to update section access frequently?

I need to update user access information at least twice a day. I am using QV 8.5 and was told not to use

partial reload because of its unusual(?) behavior from other users.

I believe it is the best to upgrade to 9.0 and use incremental load but till then, what will be the best way

to deal with it other than reloading all data which will take an hour?

Thanks,

Ryan

Frequently Updating section access

Wed, 04 Aug 2010 18:05:25 GMT

Hi Ryan,

Have you figured it out?

I tried a partial reload in QV9.0, but it didn't work. See my code below.

Regards,

James.

Section Access;
LOAD
ACCESS,
NTNAME,
COMPANYCODE
RESIDENT AUTO;
// Partial reload section access
REPLACE ONLY
Section Access;
LOAD
ACCESS,
NTNAME,
COMPANYCODE
RESIDENT AUTO;

Frequently Updating section access

disqr_rm — Wed, 04 Aug 2010 18:47:41 GMT

Why don't you load all the data in intermediate qvw, say datamodel.qvw, and then in your app.qvw you load the section access & binary load from datamodel.qvw?

Binary load should not take an hour to load, so every time you change section access records, just reload the app.qvw.

Would this help?

Frequently Updating section access

Thu, 12 Aug 2010 08:57:27 GMT

Yes, using a binary load is the only possibility for updating the section access quickly. Thanks!

Frequently Updating section access

Tue, 24 Aug 2010 09:05:18 GMT

Your can try replace load in section access and load in section application.

Frequently Updating section access

Tue, 08 Feb 2011 01:23:26 GMT

I dont understand the replace load function, if it is used for you security section, what happens to the other tables???