Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Section Access using NTName Issue

Hi,

We have section access on our document, so that each user can see their own data. Below is the script:

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, [NAME]

    ADMIN, Domain\Userid, 'user'

    ADMIN, Domain\Userid, 'user'

   ADMIN, Qservice, *

];

Section Application;

the NAME is linked to a table in our data model.

The issue when we try to access the file through access point it gives us an error 'Failed to Open the document'. we are using SR5.

is there some wrong that I am doing? Any help?

Thanks

10 Replies
MVP
MVP

Re: Section Access using NTName Issue

use uppercase for section access field, remove quotes

some detail here

http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access

and in the attached pdf

Not applicable

Re: Section Access using NTName Issue

Thanks. I looked through this document.

Do the values in the fields have to be uppercase?  I tried removing the quotes also. still same error.

MVP
MVP

Re: Re: Section Access using NTName Issue

I always use uppercase

You can use the small doc attached (User ID is user) to try lower/uppercase

Not applicable

Re: Section Access using NTName Issue

Thanks. Tried upper case and lower case. Still same error "Failed to open the document" when i open it through access point

Not applicable

Re: Section Access using NTName Issue

what if you put a star instead of a value in the NAME field.

Do you have strict exclusion on the document?

Employee
Employee

Re: Section Access using NTName Issue

Hi Padmaja,

Try just using the basic at first to make sure you can get into the document before you start the data reduction.

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME

    ADMIN, Domain\NTNAME

    ADMIN, Domain\NTNAME

   ADMIN, Qservice, *

];

Section Application;

Bill

Not applicable

Re: Section Access using NTName Issue

I tried using star also...but not able to view through access point.

Thanks Bill...have not tried the basic section access..will try that...

Not applicable

Re: Section Access using NTName Issue

Bill,

I tried with basic section access and I am able to get in. But the moment i put in data reduction, it gives an error.  This is my script

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, ACCESSID

    ADMIN, Domain\NTNAME, ID

    USER, Domain\NTNAME, ID

   ADMIN, Qservice, *

];

Section Application;

Thanks

Employee
Employee

Re: Section Access using NTName Issue

What do you have ACCESSID tied to under Section Application?

Bill

Community Browser