Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
maxgro
MVP
MVP

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
Author

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.

maxgro
MVP
MVP

I always use uppercase

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

Not applicable
Author

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

Not applicable
Author

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

Do you have strict exclusion on the document?

Bill_Britt
Former Employee
Former Employee

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

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
Author

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

Bill_Britt
Former Employee
Former Employee

What do you have ACCESSID tied to under Section Application?

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.