Section Access with Inline, Spreadsheet, and Domain Access

Wed, 17 Jul 2013 19:16:28 GMT

Hello All,

I'm trying to setup section access in which a list of users in a spreadsheet controls the omit and cost access, but the domain ID logs them into the application. Here's what I have...

Section Access; //Start of section access part

DIRECTORY;

Sec:
LOAD * INLINE [USER, USERID, NTNAME, PASSWORD, ACCESS, OMIT
     qlikview, qlikview, *, qk2, ADMIN,
      svc_qlikview11, *, svc_qlikview11@test.net, *, ADMIN,
      a, a, *, 123, USER,     CostAmount
     a, a, *, 123, USER, VendorName
     a, a, *, 123, USER, VendorNumber
     a, a, *, 123, USER, Manufacturer
];

Concatenate (Sec)
LOAD TRIM(UPPER(USERID)) as USER,
      '*' AS USERID,
      'DOMAIN\' + TRIM(UPPER(USERID)) as NTNAME,
     '*' AS PASSWORD,
     TRIM(UPPER(ACCESS)) AS ACCESS,
     OMIT

FROM $(vDataFilePath)UserList.xlsx (ooxml, embedded labels, table is User);

Section Application; //End of section access part
star is *;

DIRECTORY;

Sec2:
LOAD * INLINE [USER, ALLOWCOST
     QLIKVIEW, Y
     SVC_QLIKVIEW11, Y
     A, N
];

Concatenate (Sec2)
LOAD
    TRIM(UPPER(USERID)) AS USER,
    TRIM(UPPER(ALLOWCOST)) AS ALLOWCOST //Flag for showing Item Costing
FROM $(vDataFilePath)UserList.xlsx (ooxml, embedded labels, table is User);

The spreadsheet that this uses looks like the following:

USERID	USER	PASSWORD	ACCESS	DEPT	ALLOWCOST	OMIT
user1	user1	123	ADMIN	IT	Y
user2	user2	123	USER	IT	N	*
user3	user3	123	USER	FIN	Y

When I build and reopen the application, I have to login using one of the inline user IDs. It isn't recognizing my domain user. What am I missing?

Thanks,

Re: Section Access with Inline, Spreadsheet, and Domain Access

Wed, 17 Jul 2013 20:05:36 GMT

I knew it would be something simple.

'DOMAIN\' + TRIM(UPPER(USERID)) as NTNAME,

Needed to be changed to

'DOMAIN\' & TRIM(UPPER(USERID)) as NTNAME,

Now it is all working as I had thought it should. I'm not sure whether I needed to pull the ALLOWCOST as a separate pull or not. Opinions?

Thanks,

topic Re: Section Access with Inline, Spreadsheet, and Domain Access in QlikView

Section Access with Inline, Spreadsheet, and Domain Access

Re: Section Access with Inline, Spreadsheet, and Domain Access