topic binary reload from a document with section access in QlikView

binary reload from a document with section access

ali_hijazi — Wed, 02 May 2012 14:21:12 GMT

Hello

I got a document Doc1 with section access

Now I have another doucment Doc2 that has its own section access and at the same time it has to read binary from Doc1

Is there a way to overcome the user name and password pop up for the section access of Doc1

i.e. I want authenticated users for Doc2 to open it on the web without having to enter the credentials for Doc1

Please advise

binary reload from a document with section access

Thu, 03 May 2012 12:46:07 GMT

It should work ok if both documents have the same section access, same username and password. If the access is different or password is different then, of course, you must enter the second set of credentials in order to preserve the security.

binary reload from a document with section access

Thu, 03 May 2012 13:38:19 GMT

If you name the Section Access table you can drop the table after performing the binary load from Doc1 and then load the new Section Access table for Doc2. Something like this:

BINARY Doc1.qvw;
DROP TABLE SecTable;
SECTION ACCESS;
SecTable:
LOAD
........

Regards

Matt

binary reload from a document with section access

Miguel_Angel_Baeyens — Thu, 03 May 2012 13:56:02 GMT

Hi Ali,

In all documents you should have the NTNAME field with the DOMAIN\USERNAME form of the user that is running the reload processes (usually the QlikView Administrator, as in Startup, Run, Services.msc, right click on a QlikView Service, Properties, Logon tab) with ADMIN access and able to see all records. Should you need to combine USERID/PASSWORD values with the NTNAME field, check this post with sample working code in this regard.

This will avoid asking for credentials and will remove the original section access and will replace with the one in the binary loader.

Hope that helps.

Miguel

binary reload from a document with section access

Miguel_Angel_Baeyens — Thu, 03 May 2012 14:00:42 GMT

Hi Matt,

Just for clarification: Although this works with normal tables, this will not work if the table has been loaded after the SECTION ACCESS; statement. In other words: you cannot DROP a section access table. Anyway, since the BINARY line is the first to be executed, you always be prompted for credentials to read from the original file if you don't have them already.

On the other hand, the second SECTION ACCESS; (in the binary loader) will overwrite the previous one, so there only will be one security table in place, which always will be the latest loaded.

Hope that makes sense.

Miguel

binary reload from a document with section access

ali_hijazi — Thu, 03 May 2012 19:05:40 GMT

Hi Miguel

so you mean that I will have one prompt for the second Section Access?

if Doc1 has Section Access with USERID = user1 and PASSWORD =pass1

and Doc2 has Section Access with USERID = user2 and PASSWORD = pass2 then

if in Doc2 I write Binary Doc1.qvw then I will have only one promt and will be able to access Doc2 using user2 and pss2 and will have both data of both documents?

binary reload from a document with section access

Fri, 04 May 2012 14:41:20 GMT

Hi Miguel

Do you mean that you can't drop a table loaded within the SECTION ACCESS section of the script from the SECTION APPLICATION section?

Regards

Matt

Re: binary reload from a document with section access

Wed, 10 Apr 2013 18:14:52 GMT

Hi Miguel,

I am faced with a similar situation.

I have a qvw file with section access . This file is no more refreshed as it is a snapshot of the last financial year ending 31st march 2013. There is a new user who wants access to this file. For the same , I needed to change the Section access script as the user should be able to see data only for a particular region. However refreshing the app would give me up to date data which i dont want.

Hence i decided to take a binary laod and create a section access script in the new file. But that doesnt seem to work and the User is able to view all the regions after i reload the binary script app. i.e the section access from the first application is not getting over written in the new file.

Wondering if I am missing out on something or if there is any other solution to the problem ?

BTW both the binary and the original file have the same document settings. Initial data reduction based on section access is checked in both the files.

Re: binary reload from a document with section access

Wed, 10 Apr 2013 23:36:12 GMT

Section access is usually the first thing processed in the loadscript if it is near the top of the hidden script. Did you try this?:

Make sure you have a backup copy of the document.

In the line after Section Access there is usually a “Load * Inline” – make it say “Add load * inline”

After the last line of that inline load add a line that says “Exit Script;”

Close the loadscript editor.

From the File menu, select Partial Reload

Did that help?

Re: binary reload from a document with section access

Thu, 11 Apr 2013 04:17:16 GMT

i have a query fiscal year(2013Q1) this formate,

i want to change fiscal year(FY13) this formate

plz help me,

Thanks,

Re: binary reload from a document with section access

Thu, 11 Apr 2013 12:06:05 GMT

Hi Tim,

Thanks for your reply.

Unfortunately your suggestion didnt work. It is not overwriting the section access from the first file.

My intention is to overwrite the section access of the first file without reloading the script of the first application.

My new qlikview file has a binary statement which comes right at the top of the script followed by the new section access code.

Regards

Re: binary reload from a document with section access

Thu, 11 Apr 2013 16:24:48 GMT

Sorry, I wasn’t clear. A binary statement, of course, has to be the first statement in the loadscript and you can’t override the security or else the binary statement would provide a way to look at the contents of secure documents.

My suggestion was meant for the original document (the one referenced in your binary statement). I thought a partial reload on that original document might provide a way to replace the original inline loaded table in the section access without reloading any other data.

I hope you find something that works.

Re: binary reload from a document with section access

Thu, 21 May 2015 17:23:15 GMT

Hi Miguel..

Link in this post is not working can you please update the link as we had a same situation.

Regards
Nandkishor Pandirkar