topic Re: Section Access Problem in QlikView

Section Access Problem

senpradip007 — Thu, 09 Aug 2012 10:18:32 GMT

Hi All,

I need your help about this topic.

I can implement section access via Inline load or loading from Excel file.

I am using following code to load data from SQL Server

ODBC CONNECT TO dsnTest (XUserId is BWDKaZFMIC, XPassword is ZZRJLYFMTbcOXXJOELMETZUX);

SECTION Access;

LOAD

ACCESS,

USERID,

PASSWORD;

SQL SELECT *

FROM Test.dbo."tbl_SectionAccess";

SECTION Application;

But when I open the application it is asking for the UserId repeatedly instead of Password.

Please help me to get rid of this problem.

UserId is "Admin

Thanx in advance.

Re: Section Access Problem

giakoum — Thu, 09 Aug 2012 10:22:08 GMT

I think there is no user Admin in your table or the users role is preventing him from opening the document. That is why it asks again for another user. Load the tables in section application to see which users are returned and with what access.

Re: Section Access Problem

senpradip007 — Thu, 09 Aug 2012 10:34:22 GMT

Pls check the attached file in the sql server,you can see all the information in this file.

Thanks

Re: Section Access Problem

giakoum — Thu, 09 Aug 2012 10:40:14 GMT

sorry cannot open that file. An excel would help.

Re: Section Access Problem

IAMDV — Thu, 09 Aug 2012 12:09:37 GMT

Pradip - Are you using UPPER case? This behaviour is because Section Access can't find the User within the Section Access table. Please make sure you that you use UPPER case for all the Section Access fields. And remove Section Access and Section Application statements to check if you can load the User Name, Password etc within your data model. Also, please copy your select statement results into excel file and post it here and we can look into it.

Make sure that you include ADMIN with your Section Access Table.

I hope this makes sense!

Cheers,