topic Re: Section Access with Binary Load? in QlikView

Section Access with Binary Load?

Sun, 27 Oct 2013 19:06:49 GMT

Hi All,

I have couple of doubts regarding section access and table viewer?

1. Can section access be transfered through Bianry load?If so How?

2. If we load some table through resident load . Can the fields/tables be shown in table viewer?

Thanks.

Re: Section Access with Binary Load?

swuehl — Sun, 27 Oct 2013 20:21:19 GMT

1. A binary statement will load the access as well as the data parts of a document.

2. All tables in your data model should show up in the table viewer, regardless the data source.

When using a resident LOAD with transferring all fields, like

LOAD * RESIDENT Table;

take care that this will auto-concatenate to the resident table Table.

Re: Section Access with Binary Load?

Thu, 31 Oct 2013 15:12:10 GMT

Thanks Swuehl.

Re: Section Access with Binary Load?

Fri, 03 Jan 2014 23:49:10 GMT

Hi,

Can you overwrite the section access?

lets say i have Source Doc.QVW with section access where user A has USER1 has USER access

I create a new doc.QVD with Binary Load Source Doc.QVW and here i reduce my data

and so i want USER1 to have ADMIN access since data is already reduced.

(We dont have publisher and doing a section access data reduction is taking a while so i am doing this as a work around instead of duplicating the data model)

Re: Section Access with Binary Load?

agilos_mla — Sat, 04 Jan 2014 08:39:12 GMT

Hi Janet,

You can overwrite the section access after a binary laod. The rule is : qvw inherit section access from the binary load but if you build a new section access in the calling qvw this will override rights defined in the binary, that's why you have the option "prohibit binary load" in order to avoid a user to do a binary and rewrite the Section Access.

Then in you new qvw do :

BINARY SourceDoc.Qvw;

Section Access;

...

Section Application;

...

and check "prohibit binary load " in the Document Properties\Opening tab.

KR,

Michael

Re: Section Access with Binary Load?

Sat, 04 Jan 2014 08:40:19 GMT

Hi Vaneet,

1.I am not sure, not possible to transferred Can section access through Binary load. Please cross check it one time. Both are separate document.

2. You can load some table through resident load, You Can the view the Table Name and fields Name in Table Viewer.

Re: Section Access with Binary Load?

domeniconotaro — Fri, 05 Oct 2018 09:58:53 GMT

It works perfectly.

Thank you Michael!