topic Re: Binary load in QlikView

Binary load

Thu, 16 Jul 2015 12:02:06 GMT

Hi Experts,

How to get UI part and Section access and Variables while we go for Binary Load? Is there any option

- Raj

Re: Binary load

MayilVahanan — Thu, 16 Jul 2015 12:05:36 GMT

Edit:

No, we can't able to move UI Part, Variables..

But why you need that ?

I think, you can copy the original file and use it if you need all the information .

Could you explain little bit more

Thanks swuehl‌ for correct it

Re: Binary load

swuehl — Thu, 16 Jul 2015 12:07:31 GMT

From the HELP file:

The binary statement is used for loading the data from another QlikView document, including section access data. It does not load the layout information or variables.

So, section access will be loaded from your source QVW. You need to create the variables and UI in the destination QVW.

Re: Binary load

Kushal_Chawda — Thu, 16 Jul 2015 12:09:29 GMT

Hi,

We can't copy UI in binary load.

To copy variables from one application to other see below link

http://qlikviewmaven.blogspot.in/2008/11/copying-variable-from-one-qlikview.html

Instead of copying saction access , apply saction access on final application.

Re: Binary load

Thu, 16 Jul 2015 12:14:06 GMT

So, How to get section access part for Binary load

Re: Binary load

swuehl — Thu, 16 Jul 2015 12:17:33 GMT

I believe you can add section access either to your source QVW (then it's getting binary loaded) or to your destination QVW. But you can't modify or add access rules in your destination QVW using section access if the source file already has section access applied. If this would be possible, it would circumvent security, right?

Re: Binary load

datagrrl — Thu, 16 Jul 2015 15:09:17 GMT

In this post I found some interesting replies that suggested you could overwrite the original section access table. I would think you could make the section access more restrictive than the original file, but not less.

That is an interesting question.

binary reload from a document with section access

Re: Binary load

swuehl — Thu, 16 Jul 2015 15:30:36 GMT

I doubt that you can override section access, and how would you make sections access more restrictive?

How would you remove a user from the list? Or remove values from a field with data reduction?

I vaguely remember the rule that there can be only one section access section, first will take control.

If the latest will take control, this would severly infringe security.

Not 100% sure though given that Miguel should know, so everyone is free to give it a try (I don't have time right now, maybe later on).

Re: Binary load

swuehl — Thu, 16 Jul 2015 15:57:21 GMT

Just tested it. Seems like the binary loaded section access table is still valid.

UserID Password

SectionAccess1: A A

SectionAccess2: B B

SectionAccess2 binary loads SectionAccess1.

Re: Binary load

datagrrl — Thu, 16 Jul 2015 16:12:35 GMT

Thanks, I really wanted to do some testing on this as well. I have recently started using both Section Access and Binary loads more, but not in the same apps. I will have to test a few scenarios.

Re: Binary load

Peter_Cammaert — Thu, 16 Jul 2015 16:12:57 GMT

Nice experiment Stefan.

I found out something else:

You cannot influence section access across documents. You have shown that the original SA survives a binary load and a subsequent SA is ignored. Probably because at script termination time the information in an SA table is moved to a special security zone, and after a binary load QlikView detects that this zone is already taken up and won't fill it a second time.
However, within the same script, you can create SA tables in sequence and each in a different Section Access area. And the most interesting thing is that you can delete the first SA table using a DROP Table statement if you name the first table. Only the last one will be kept.

Didn't know that.

Peter

PS Now Username/password = B/B due to the second Section Access table load.