topic Re: How to refresh Section Access details, without reloading the whole document. in QlikView

How to refresh Section Access details, without reloading the whole document.

awhitfield — Fri, 17 Jul 2015 09:22:42 GMT

Hi Community,

a client of ours has a qvw that loads section access details from an excel spread sheet within a hidden script. They now need to add new users to the Section Access, but can't perform a full reload as the dashboard is based on historic data, that is no longer available.

Can you come up with a fairly simple to implement solution for this query please?

Thanks in Advance,

Andy

Re: How to refresh Section Access details, without reloading the whole document.

MK_QSL — Fri, 17 Jul 2015 09:29:57 GMT

Search for

Replace Load

Replace Only Load

Re: How to refresh Section Access details, without reloading the whole document.

tresB — Fri, 17 Jul 2015 09:35:47 GMT

Binary load the qvw in another qvw
Use Store command to store the historical data as QVD // this is for future re-use
Use section access in the new qvw that will eventually override any section access in the binary loaded qvw (if any, and provided 'prohibit binary load' was not enabled in the source qvw).

Or, may be a partial reload.

Re: How to refresh Section Access details, without reloading the whole document.

Peter_Cammaert — Fri, 17 Jul 2015 09:47:09 GMT

Don't think a partial load will work. After script termination, the SA tables aren't really tables anymore...

IMHO tresesco's data recovery solution is your only option.

Peter

Re: How to refresh Section Access details, without reloading the whole document.

jonathandienst — Fri, 17 Jul 2015 09:54:19 GMT

A general tip for a case such as this is that you might want to dump all the tables from this 'non-updateable' model into qvd files as a backup for this data.

You need a separate qvw file that contains a binary load followed by a loop that iterates through the tables, storing each one to a qvd file.

Then you can update the load script of the original model (after taking a backup), to simply load all the qvd files. Maintaining the section access of the new 'updateable' model is simple. You will have to add the section access part to the script file, update the source data and reload the model in the normal way.

Re: How to refresh Section Access details, without reloading the whole document.

Gabriel — Fri, 17 Jul 2015 10:06:22 GMT

Hi,

1 things which has worked for me in the past is to use variable to split the code into two part. Say you have vSectionAccess as you parameter then in your script you will say IF vSectionAccess = 1 then reload section access script, your ELSE will skip the part you don't want to load.

IF vSectionAccess = 1 THEN

LOAD

//sectionaccess

ELSE

// This is the historical reload section

ENDIF

Then in QMC you have to enter this parameter into Reload tab under Parameter Name and Parameter Value

Hope this is helpful it has helped me in the past

Let me know if it works

Re: How to refresh Section Access details, without reloading the whole document.

tresB — Fri, 17 Jul 2015 10:42:04 GMT

Hi Peter,

I was testing the partial reload option to be sure. And I guess it works as I guessed.

Have a look at the attached sample. The steps I followed:

Loaded an inline data set
Then added section access with Replace
Commented out the inline data section, or put it blank
Run partial reload - ctrl+shift+R
- worked (unless you catch me somewhere, )

Re: How to refresh Section Access details, without reloading the whole document.

Bharat_Ahuja — Thu, 19 Nov 2015 20:36:45 GMT

The sample QVW is locked and is asking for a User ID.

We have a similar requirement where we just don't want to run the full reload and just update only the section access table.

I don't think QlikView Supports keeping all the data in the same QVW file and updating one single table, which would be a very nice feature to have.