Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Confused: section access and section application

Hi There,

I am new on QlikView. Did check some of the documents but no help.

I want to use the section access to control the users to see the data in their own configuration. There is a dimension named CONFIG_ITEM_DESCRIPTION, I want to restrict use to read data in their own config item, the following code as you can see. I want the user U2 to only see the data in ConfigU2.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, Bruce, Bruce

    USER, U2, U2

    USER, U3, U3

];

Section Application;

LOAD * INLINE [

    USERID, CONFIG_ITEM_DESCRIPTION

    U2, ConfigU2

    U3, ConfigU3

];

But after I implemented this, and deployed on server. I even cannot login with the user name and password then.

Anyone can help?

5 Replies
Not applicable
Author

I use the QlikView 10

SunilChauhan
Champion
Champion

in document properties -> opening -> initial data reduction based on section access (check it )

see the attched file hopw this helps you

Sunil Chauhan
Not applicable
Author

I did check the item. it doesn't work.

But you attachment is good to me, I will investigate it. thanks

Not applicable
Author

And additionally, The

CONFIG_ITEM_DESCRIPTION is a dimenssion loaded from a database.

SunilChauhan
Champion
Champion

did got your solution or you want any thing else

Sunil Chauhan