topic Section access question in QlikView

Section access question

lukacvetko — Thu, 11 Dec 2014 09:00:05 GMT

Hello all,

Maybe there is an option but I can't find it and I find it very weird.

So, we implemented section access in one application. After manual reload, we save the application and everything works fine and everyone has access. We used NTNAME column. Users and admins (that were defined in section access part of the script), everyone can access trough server.

Then I open the application again with the same user and lets say I decide to change something in front end, just enough that I can save the change, like add a dimension in pivot table. When I save the application, it first asks me to chose the save location, it doesn't just save, I overwrite current application, and suddenly users can't access the application, it says that access is forbidden for them. Weirdest part is, admins can access it and we have admins in different domains, so that can't be the domain problem

So, after manual reload everybody has access, and after I make a small change in application and save it, users get access denied.

Any input is appreciated.

Regards

Re: Section access question

adiarnon — Thu, 11 Dec 2014 09:02:29 GMT

i have the same problem!

Re: Section access question

Anonymous — Thu, 11 Dec 2014 09:10:53 GMT

Hi Luka,

Please can you Post the script here.

Do you have publisher with your licence?

Regards

Neetha

Re: Section access question

jonathandienst — Thu, 11 Dec 2014 09:16:32 GMT

This is because data reduction is enabled on the Document properties Opening tab combined with section access. QV will not automatically save the reduced document over the original. This is to ensure that you do not accidentally remove data that you cannot see, but that another use can, when they open the document.

This also applies to models that are manually reduced (using File | Reduce) and even if no actual reduction takes place.

Batch reloads using Qv.exe /R or server/publisher are not affected.

HTH

Jonathan

Re: Section access question

Thu, 11 Dec 2014 09:17:15 GMT

Hi Luka

That is not problem of section access

plz check the user that is saving have access on that document

qvw property security add that member

Re: Section access question

rohit214 — Thu, 11 Dec 2014 09:25:51 GMT

Hi Luka,

Same problem i have faced .

how you are saving the application.

try that

after reload select right hand side top corner close button and then select save.

Regards

Rohit

Re: Section access question

Anonymous — Thu, 11 Dec 2014 09:30:50 GMT

Guys,

This is normal.

When you open the document after you saved it after reload for the first time; it applies section access as well.

So let's say you opened it with USER1. Now the section table is reduced to USER1 only. And if you save it now after a few modifications, it saved it only for USER1 (since there is no other user value in the section table).

Now to avoid that you need to reload the document before saving. That is a general rule for section accessed documents.

Serhan

Re: Section access question

lukacvetko — Thu, 11 Dec 2014 12:04:06 GMT

That is correct, thank you for clarifying. So, this mechanism applies no matter if USER1 has access to all the data and it is defined as Admin?

And why did the other Admins (defined as admins in section access part of script) have access after the Save and Users (defined as users in section access part of script) didn't?

This might be problematic for applications that have section access applied but take more time to reload.

Regards,

Luka

Re: Section access question

Anonymous — Thu, 11 Dec 2014 12:33:00 GMT

Hello Luka,

Hard to guess. May depend on how you implement it. I would specifically need to test that app. But I'm sure there would be an explanation for that.

Just from now on, apply reloading as best practice since it is exact.

Serhan

Re: Section access question

lukacvetko — Thu, 11 Dec 2014 15:05:58 GMT

Serhan,

Your explanation is correct. As a solution for our problem for now we are using a batch script. We are doing daily development on test application, and right before the automatic reload through management console starts, batch script overwrites original production application with the test application. That way customers have fresh data, with our fresh amends and upgrades from day before.

I would appreciate if anyone has any info about better practice. We have no Publisher licence.

Regards,

Luka

Re: Section access question

Anonymous — Thu, 11 Dec 2014 15:13:29 GMT

Interesting case. I don't have a better solution but maybe just an alternative.

While you are developing you can use reduced data (such as sample QVDs etc). It may ease on the reload time.

Serhan