Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day community
I have the script below which applies section access on my dashboard. So everytime I make changes to the spreadsheet it's pointing to I have to do a full reload to apply the changes which takes quite long.
Can you please assist with "partial reload" script as I tried with the one below and it's not working: Or do I need two scripts, one for partial reload and one for full? How does it work?
section access;
if IsPartialReload() then
Access:
Replace LOAD Upper(ACCESS) as ACCESS,
Upper(USERID) as USERID,
Upper(PASSWORD) as PASSWORD,
Upper(NTNAME) as NTNAME,
Upper([Business Unit]) as [BUSINESSUNIT]
FROM
[D:\QlikView\FTP\Matlotlo\Users Access List_MatlotloWIP.xlsx]
(ooxml, embedded labels, table is [Section Access]);
section Application;
Grouping:
Replace LOAD NTNAME As [NT NAME],
[OS GROUPING],
HR,
[Title Manco],
Exceptions
FROM
[D:\QlikView\FTP\Matlotlo\Users Access List_MatlotloWIP.xlsx]
(ooxml, embedded labels, table is [Section Access Detail]);
Thanks and regards
Try this:
Copy your QVW without the access script.
Create new QVW which uses Binary Load to the first QVW and applies the Section Access (That' would be the QVW you want to point your users to).
Binary load usually goes much faster than what your script would normally take to execute since it only loads the data previously transformed.
Kind regards,
S.T.
Thank you @ST . But now the qvw that I create the binary script on, does it need to have the same data load as the original document? or is it just a blank document with no data set, just binary load and section access script?
Because I made a copy of the original document and added binary load and section access script and deleted the section access script on the original one. I'm now running the one with binary load and reload time seems to be the same as before?
Thanks
Matlotlo
Matlotlo, I think what Stoyan was suggesting was to keep the original app as the data model etc., and the new app would have the Section Access script as well as the layout from the original app too. The binary of the original into the new app would put the data model plus the section access into the new app for you. That all being said, the only reason of which I can think things would be slow would most likely be something in the data model not being optimized and tied into the reduction field you are using etc. Hopefully this helps, I am sure Stoyan will pop back too, I just wanted to try to help here...
Regards,
Brett
Thank you @Brett_Bleess . Yes you are right, the model itself is not optimized, it's huge with a couple of sync keys. Optimizing it will be a mission but has to be done in due course. I did run the binary load but it still took the same amount of time so since I'm just testing access I'm doing a partial reload. Thank you all for the assistance @Stoyan_Terziev .
Regards
Matlotlo