Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
balanandam
Creator II
Creator II

Section Access Not working

Hi,

In my app I have defined section access based on user login. without publisher its working but in our prod evn scheduled are happening thru Publisher. there i'm facing problem. Super user who has configured admin and configured with '*' to see complete view. when I logged with super it is working but with sub users who has configured for a particular section of data view is not working. when I logged in any sub user Access point itself getting logged out automatically..

Pls. advice if there special configuration to be set at Publisher level.

Thanks In Advance!

Br, Balanandam

13 Replies
Anil_Babu_Samineni

In my app I have defined section access based on user login. without publisher its working but in our prod evn scheduled are happening thru Publisher. there i'm facing problem. Super user who has configured admin and configured with '*' to see complete view. when I logged with super it is working but with sub users who has configured for a particular section of data view is not working. when I logged in any sub user Access point itself getting logged out automatically..

What is the mean of Highlight one. Can you share script?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
balanandam
Creator II
Creator II
Author

Hi Anil,

this  was my code

Section Access;


LOAD *, Upper(NTNAME) as User;

LOAD * INLINE [
    ACCESS, NTNAME
    ADMIN,EC2AMAB-7GFRL3S\ADMINUSER
    USER,EC2AMAB-7GFRL3S\USER1
    USER,EC2AMAB-7GFRL3S\USER2
    USER,EC2AMAB-7GFRL3S\USER3
    USER,EC2AMAB-7GFRL3S\USER4
];

Section Application;

star is *;
User_Reduction_Data:
LOAD * Inline [
CompanyName, User
Valutech,EC2AMAB-7GFRL3S\USER1
EncoreRepair,EC2AMAB-7GFRL3S\USER2
EcoRenew,EC2AMAB-7GFRL3S\USER3
CVE,EC2AMAB-7GFRL3S\USER4
*,EC2AMAB-7GFRL3S\ADMINUSER
];
star is *;

here I'm calling ADMINUSER as super user and rest all sub user..

My dev environment it is working but not in prod, only change is Prod we have publisher that's it.

Br, Balanandam

Anil_Babu_Samineni

Can you take away star is * and check one more time, Usually star is * will work up on data reduction level for all Users and Admin as well. It won't work as expected.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
balanandam
Creator II
Creator II
Author

Anil,

I 've changed my code like below:

Section Access;


LOAD *, Upper(NTNAME) as User;

LOAD * INLINE [
    ACCESS, NTNAME
    ADMIN,EC2AMAB-7GFRL3S\ADMINUSER
    USER,EC2AMAB-7GFRL3S\USER1
    USER,EC2AMAB-7GFRL3S\USER2
    USER,EC2AMAB-7GFRL3S\USER3
    USER,EC2AMAB-7GFRL3S\USER4
];

Section Application;


User_Reduction_Data:
LOAD * Inline [
CompanyName, User
Valutech,EC2AMAB-7GFRL3S\USER1
EncoreRepair,EC2AMAB-7GFRL3S\USER2
EcoRenew,EC2AMAB-7GFRL3S\USER3
CVE,EC2AMAB-7GFRL3S\USER4
CVE,EC2AMAB-7GFRL3S\ADMINUSER
EcoRenew,EC2AMAB-7GFRL3S\ADMINUSER
EncoreRepair,EC2AMAB-7GFRL3S\ADMINUSER
Valutech,EC2AMAB-7GFRL3S\ADMINUSER
];

No change on behaviour, only no problem with super user. FYI all sub users created newly and granted licenses. Is there any thing that can cause this issue ? it might be foolish ask! but I just wanted to tell you this.

with sub I can log into access point and there I can see accessible Dash board, when I can click on the Dashboard it is getting logged out.

Br, Balanandam

PabloTrevisan
Partner
Partner

Hi Balanadam, to use reduction try this format..

Section Access;


LOAD * inline [

  ACCESS, USERID, REDUCTION

  ADMIN, DOMAIN\USER1, USER1

  USER,   DOMAIN\USER2, USER2

  USER,  INTERNAL\SA_SCHEDULER,,,*

];


Section Application;

Star is *;

REDUCT:

Load * InLine [

    REDUCTION, CONTRY

    USER1, *

    USER2, USA

   ];

balanandam
Creator II
Creator II
Author

No Luck again!

Br, Balanandam

Anil_Babu_Samineni

Instead, Can you try simple and test from Prod using below.

LOAD *, Upper(NTNAME) as User;

LOAD * INLINE [
    ACCESS, NTNAME, CompanyName
    ADMIN,EC2AMAB-7GFRL3S\ADMINUSER, *
    USER,EC2AMAB-7GFRL3S\USER1, Valutech
    USER,EC2AMAB-7GFRL3S\USER2, EncoreRepair
    USER,EC2AMAB-7GFRL3S\USER3, EcoRenew
    USER,EC2AMAB-7GFRL3S\USER4, CVE
];

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
balanandam
Creator II
Creator II
Author

Anil, I changed this way as suggested

Section Access;

LOAD *, Upper(NTNAME) as User;

LOAD * INLINE [

LOAD * INLINE [

    ACCESS, NTNAME, CompanyName

    ADMIN,EC2AMAB-7GFRL3S\ADMINUSER, *

    USER,EC2AMAB-7GFRL3S\USER1, Valutech

    USER,EC2AMAB-7GFRL3S\USER2, EncoreRepair

    USER,EC2AMAB-7GFRL3S\USER3, EcoRenew

    USER,EC2AMAB-7GFRL3S\USER4, CVE

];

Section Application;

Now I was able to login with sub users, but data reduction not happening, means Section access not working at all and I could see all the data as like ADMINUSER.

Br, Balanandam

Anil_Babu_Samineni

I believe try from very static level and advance we can try. Can you check this?

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, CompanyName

    ADMIN,EC2AMAB-7GFRL3S\ADMINUSER, 123, *

    USER,EC2AMAB-7GFRL3S\USER1, 456, Valutech

    USER,EC2AMAB-7GFRL3S\USER2, 789, EncoreRepair

    USER,EC2AMAB-7GFRL3S\USER3, 012, EcoRenew

    USER,EC2AMAB-7GFRL3S\USER4, 013, CVE

];

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)