topic Re: doesn't work section access after reload using NTNAME in QlikView

doesn't work section access after reload using NTNAME

Wed, 04 Jul 2012 01:49:09 GMT

hi,

i have ploblem of section access.

i wrote following expressions for using section access...

SECTION Access;

ACCESS:

LOAD

"ACCESS_KBN" AS [ACCESS],

"USER_ID" AS [USERID],

"PASSWORD" AS [PASSWORD],

' ' AS [NTNAME],

"GRP_USER_ID" AS [GRP_USERID],

"SSK_USER_ID" AS [SSK_USERID],

"KMK_USER_ID" AS [KMK_USERID]

;

select QA.ACCESS_KBN AS ACCESS_KBN,

QA.USER_ID AS USER_ID,

QA.PASSWORD AS PASSWORD,

QA.USER_ID AS GRP_USER_ID,

QA.USER_ID AS SSK_USER_ID,

QA.USER_ID AS KMK_USER_ID

from QV_ACCESSCTL QA

;

//using NTNAME to open this file

concatenate(ACCESS)

LOAD * INLINE [

ACCESS,USERID,PASSWORD,NTNAME,GRP_USERID,SSK_USERID,KMK_USERID

ADMIN,*,*,QVSR\ADMINISTRATOR,*,*,*

];

i deployed this file to server after reload this scripts by NTNAME of ADMINISTRATOR.

i aceess and open this file by using Internet Explore then it doesn't work section access without NTNAME.

i tryed to enter ID and PASSWORD 3 times but the file is not opened....

please anyone tell me this solution.

regards,

olfesio

Re: doesn't work section access after reload using NTNAME

fosuzuki — Thu, 05 Jul 2012 01:54:53 GMT

Hi olfesio,

try this: