Section Access / Section Application Issue

[#1]

I'm trying to apply a filter on load of a document, based on the user specified. I've looked at examples, and have some that work. Yet, for some reason, when I create one, mine don't work. I know I'm missing something, likely simple, but haven't had any luck figuring it out.

A very simple example of what I'm running into problems with is at http://www.insaneprojects.com/SecuritySample.qvw

If someone can take a look and tell me what obvious thing I'm missing, I'd appreciate it.

Thanks!

-Kevin

[disqr_rm]

What is the user/password of your document?

Make sure that you have the "Initial Data Reduction...." checkbox "on" under document properties and "Opening" tab.

[#3]

Hello Rakesh!

I am also struggling with something same like this. I wish you could see the below post can help me out. It is so bad that i don't know how to define the admin due to some reason in the data structure and also not proper understanding of Section access in qlikview. In my document admin is not able to see the over all data so it is so bad. User and the USER level are only able see the data. I want the admin login to see all the USER' s data.

Please look into the below post and help me out. If anything is not understandable please let me know because so many times posted the same problem in the forum but no helped me out it the last. So not sure whether they are not able to understand anything in my or what.

Hope you to receive reply from you atleast.

http://community.qlik.com/forums/t/25669.aspx

http://community.qlik.com/forums/t/25323.aspx

To open the attachment application, use userid: 0010012021, password: c2info99

Thanks and Regards,

Rikab

[#4]

Hi All,

I don't know whats wrong with this post. I am not getting much reply which and all are related to this post. I don't know why! Is it not understandable or missing any information. But i seriously in need of solution for this problem. Hope members of this community will consider this seriously and provide solution for this problem at the earliest.

Thanks and Regards,

Rikab

[#5]

Rakesh wrote:
What is the user/password of your document?
Make sure that you have the "Initial Data Reduction...." checkbox "on" under document properties and "Opening" tab. <div></div>

Sorry; I forgot that rather key piece of info!

Section Access;
Access01:
LOAD * INLINE [
 ACCESS, USERID, SP
 ADMIN, ADMIN, *
 USER, USER, *
 USER, Kevin, Central
 User, Ricardo, Eastern
];

Initial data reduction is checked.

-Kevin

[#6]

Is a field called SP exists in the section application of your QlikView File ?

this field [SP] must include at least 'Central' and 'Eastern' values and it should be linked to the other part of your QlikView Data Model.
If you still have difficulties, please read the QlikView reference Manual Book 1, 26.8 Dynamic Data Reduction first.There is explanations on an example

Note : Please use only USER or ADMIN value in the ACCESS field

Hopes it helps

Regards

[#7]

Bertrand wrote:Is a field called SP exists in the section application of your QlikView File ?
this field [SP] must include at least 'Central' and 'Eastern' valuesand it should be linked to the other part of your QlikView Data Model.

Yes.

If you still have difficulties, please read the QlikView reference Manual Book 1, 26.8 Dynamic Data Reduction first.There is explanations on an example

I've reviewed that, I have reviewed other examples that work, but for some reason, when I try to implement it myself, it does not work.

When I view the associated database, it also shows the proper link between the table created in Section Application and in the data itself.

-Kevin

[disqr_rm]

I still cannot open your sample document with the user/password information you have provide. Please double check and let us know.

[#9]

Rakesh wrote:
I still cannot open your sample document with the user/password information you have provide. Please double check and let us know. <div></div>

I just downloaded a copy and was able to access via a username of admin and a password of admin.

-Kevin

[disqr_rm · Accepted solution]

oops!!! my bad. I had typo,... sorry.

Try this code. Only chaged the case of SP. It's very picky in the section access. You could also do upper() function as preload.

Section Access;
Access01:
LOAD * INLINE [
 ACCESS, USERID, SP
 ADMIN, admin, *
 USER, user, *
 USER, kevin, CENTRAL
 USER, ricardo, EASTERN
];
Section Application;
Access_Application:
Load * INLINE [
 SP, Region
 CENTRAL, C
 EASTERN, E
 NORTHERN, N
 SOUTHERN, S
];