Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
I always use uppercase
You can use the small doc attached (User ID is user) to try lower/uppercase
Thanks. Tried upper case and lower case. Still same error "Failed to open the document" when i open it through access point
what if you put a star instead of a value in the NAME field.
Do you have strict exclusion on the document?
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
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...
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
What do you have ACCESSID tied to under Section Application?
Bill