Section Access using NTName Issue

[#1]

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

[maxgro]

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

[#3]

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]

I always use uppercase

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

[#5]

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

[#6]

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

Do you have strict exclusion on the document?

[Bill_Britt]

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

[#8]

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...

[#9]

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]

What do you have ACCESSID tied to under Section Application?

Bill