topic Section Access / Section Application Issue in QlikView

Section Access / Section Application Issue

Tue, 16 Feb 2010 01:52:20 GMT

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

Section Access / Section Application Issue

disqr_rm — Tue, 16 Feb 2010 04:31:11 GMT

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.

Section Access / Section Application Issue

Tue, 16 Feb 2010 05:46:20 GMT

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

Section Access / Section Application Issue

Tue, 16 Feb 2010 11:35:59 GMT

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

Section Access / Section Application Issue

Tue, 16 Feb 2010 15:04:01 GMT


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

Section Access / Section Application Issue

Tue, 16 Feb 2010 15:12:56 GMT

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

Section Access / Section Application Issue

Tue, 16 Feb 2010 16:23:44 GMT


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

Section Access / Section Application Issue

disqr_rm — Tue, 16 Feb 2010 19:29:11 GMT

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

Section Access / Section Application Issue

Tue, 16 Feb 2010 19:31:17 GMT


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

Section Access / Section Application Issue

disqr_rm — Tue, 16 Feb 2010 19:51:56 GMT

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
];

Section Access / Section Application Issue

Tue, 16 Feb 2010 20:32:07 GMT

Thanks, Rakesh, that did it!

I knew the SP field name had to be all caps; I didn't realize that the data itself had to be all caps, as well.

Figured it was something simple...

-Kevin

Section Access / Section Application Issue

disqr_rm — Tue, 16 Feb 2010 20:47:20 GMT

HI Kevin, glad that I could help you out. Sometime simple is more difficult... 🙂

As a best practice, could you please validate the answer which helped you? This will make search easier for other users in future.