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

[awhitfield]

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

[MK_QSL]

Search for

Replace Load

Replace Only Load

[tresesco]

• 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.

[Peter_Cammaert]

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

[jonathandienst]

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.

[Gabriel]

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

[tresesco]

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, )

[Bharat_Ahuja]

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.