topic Re: Authentication & Authorization in QlikView

Authentication & Authorization

Mon, 24 Feb 2014 15:31:36 GMT

I new toi QlikViw,

What is the difference between Authentication & Authorization in QlikView? And how to implement them?
Thank in advaance
venu

Re: Authentication & Authorization

Miguel_Angel_Baeyens — Tue, 25 Feb 2014 07:30:22 GMT

Hi Venu,

Basically, authentication answers to the question "can you get to the QlikView Server?". QlikView does not authenticate but relies on the OS or security directory to do that.

If the answer is yes, you can get to the QlikView Server, then Authorization comes to place to answer the question "once I'm in the QlikView Server, what documents can I see?". Authorization is done as well by the security directory (LDAP, NTFS, etc.) and set by the QlikView Distribution Service (namely Publisher) in the distribution tasks.

Miguel

Re: Authentication & Authorization

amit_saini — Tue, 25 Feb 2014 07:31:39 GMT

Hi Venu,

Hope this link will help you:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/07/authentication-and-authorization

Re: Authentication & Authorization

jagan — Tue, 25 Feb 2014 07:56:52 GMT

Hi Venu,

Authentication means giving access to the dashboard for the right people, for example the Sales Dashboard can be viewed only by Sales Department people only, Authentication is done at Dashboard level.

Authorization means giving access to the specific data in the Dashboard, for example the Revenue Dashboard, Sales data can be seen only by Sales Deparment and Employee data is only seen by HR Deparment. This is called Authorization.

You can implement Authentication and Authorization in Qlikivew by using Section analysis concepts, check for this in Community and Qlikview Help file. There are lot of examples.

Try this script

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REDUCTION

ADMIN, Admin, password, *

USER, Sales, password1, 1

USER, Market, password1, 2

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

REDUCTION, Dept,

1, Sales

2, Marketing];

Sales:

LOAD * INLINE [

Dept, Sales

Sales, 100

Sales, 200

Sales, 4646

Sales, 755

Sales, 422

Sales, 42

Marketing, 2

Marketing, 453

Marketing, 54

Marketing, 45

];

When you login as Admin, you can see all data in the dashboard, when you login as Sales then you can see only Sales data and when you login as Market you can see only Marketing data.

Hope this helps you.

Regards,

Jagan.

Re: Authentication & Authorization

Mon, 03 Mar 2014 15:11:47 GMT

Hi Miguel,

I am struggling with the following query. Could you please help on this.

The application can move in different trays in the workflow. Each tray has different State_Codes. e.g. Tray = NSS has State_code RDY, RUN & CMP in the following example. But each tray would have RDY (shows application came in a tray) and CMP (application completed in a tray). How can I get that how many working hours each application stayed in each tray. Working days are Monday to Friday and working hours are 9:00-17:00. There is also a problem that the application can go in each tray once or more than once as two examples below.

Once example: In this example application moved in each tray only once.

Application_id	Trays	Txn_Date	State_Code
10007344	NBG	18/09/2013 12:33	CMP
10007344	NBG	18/09/2013 12:33	RDY
10007344	NSS	18/09/2013 16:23	RDY
10007344	NSS	19/09/2013 09:05	RUN
10007344	NSS	19/09/2013 09:07	CMP
10007344	CJA	19/09/2013 09:07	RDY
10007344	CJA	19/09/2013 09:11	CMP
10007344	NCO	19/09/2013 09:11	RDY
10007344	NCO	19/09/2013 09:20	RUN
10007344	NCO	19/09/2013 09:20	CMP
10007344	NFU	25/09/2013 08:28	RDY
10007344	NFU	25/09/2013 08:28	RUN
10007344	NFU	25/09/2013 08:28	CMP
10007344	NCH	25/09/2013 08:28	RDY
10007344	NCH	25/09/2013 11:56	RUN
10007344	NCH	25/09/2013 12:02	CMP
10007344	NBO	25/09/2013 12:02	RDY
10007344	NBO	25/09/2013 12:03	RUN
10007344	NBO	25/09/2013 12:07	CMP
10007344	NCA	25/09/2013 12:07	CMP
10007344	NCA	25/09/2013 12:07	RDY

More than Once example: Application moved into NSA twice, CJA three times etc.

Application_id	Tray	Txn_Date	State_Code
10007616	NBG	12/09/2013 10:42:29	CMP
10007616	NBG	12/09/2013 10:42:29	RDY
10007616	NSA	12/09/2013 10:42:29	RDY
10007616	NSA	12/09/2013 11:25:55	RUN
10007616	NSA	12/09/2013 11:26:33	CMP
10007616	CJA	12/09/2013 11:26:33	RDY
10007616	CJA	12/09/2013 11:27:24	CMP
10007616	NCO	12/09/2013 11:27:24	RDY
10007616	NCO	12/09/2013 12:56:32	RUN
10007616	NCO	12/09/2013 13:00:24	CMP
10007616	NSA	12/09/2013 13:00:24	RDY
10007616	NSA	13/09/2013 16:20:38	RUN
10007616	NSA	13/09/2013 16:22:08	CMP
10007616	CJA	13/09/2013 16:22:08	RDY
10007616	CJA	13/09/2013 16:25:47	CMP
10007616	NCO	13/09/2013 16:25:47	RDY
10007616	NCO	13/09/2013 16:50:57	RUN
10007616	NCO	13/09/2013 16:51:47	RDY
10007616	NCO	16/09/2013 10:42:22	RUN
10007616	NCO	16/09/2013 10:43:00	CMP
10007616	NFU	16/09/2013 10:43:00	SUS
10007616	NFU	24/09/2013 08:31:02	RDY
10007616	NFU	24/09/2013 08:31:02	RUN
10007616	NFU	24/09/2013 08:31:05	CMP
10007616	NCH	24/09/2013 08:31:05	RDY
10007616	NCH	24/09/2013 12:13:58	RUN
10007616	NCH	24/09/2013 12:15:25	CMP
10007616	NBO	24/09/2013 12:15:25	RDY
10007616	NBO	24/09/2013 12:15:26	RUN
10007616	NBO	24/09/2013 12:16:01	RDY
10007616	NBO	24/09/2013 12:16:04	RUN
10007616	NBO	24/09/2013 12:16:05	EXP
10007616	NCH	24/09/2013 12:16:05	RDY
10007616	NCH	24/09/2013 13:25:26	RUN
10007616	NCH	24/09/2013 13:26:20	CMP
10007616	NRD	24/09/2013 13:26:20	RDY
10007616	NRD	24/09/2013 15:30:05	RUN
10007616	NRD	24/09/2013 15:30:07	EXP
10007616	NCH	24/09/2013 15:30:07	RDY
10007616	NCH	24/09/2013 15:30:08	RUN
10007616	NCH	24/09/2013 15:31:42	CMP
10007616	NBO	24/09/2013 15:31:42	RDY
10007616	NBO	24/09/2013 15:31:43	RUN
10007616	NBO	24/09/2013 15:37:25	RDY
10007616	NBO	24/09/2013 15:37:27	RUN
10007616	NBO	24/09/2013 15:37:32	EXP
10007616	NSA	24/09/2013 15:37:32	RDY
10007616	NSA	24/09/2013 15:39:51	RUN
10007616	NSA	24/09/2013 15:41:37	CMP
10007616	CJA	24/09/2013 15:41:37	RDY
10007616	CJA	24/09/2013 15:43:42	CMP
10007616	NCO	24/09/2013 15:43:42	RDY
10007616	NCO	24/09/2013 15:52:46	RUN
10007616	NCO	24/09/2013 15:53:44	CMP
10007616	NFU	24/09/2013 15:53:44	SUS
10007616	NFU	24/09/2013 15:53:47	RDY
10007616	NFU	24/09/2013 15:53:47	RUN
10007616	NFU	24/09/2013 15:54:06	CMP
10007616	NCH	24/09/2013 15:54:06	RDY
10007616	NCH	24/09/2013 15:54:08	RUN
10007616	NCH	24/09/2013 15:54:12	CMP
10007616	NBO	24/09/2013 15:54:12	RDY
10007616	NBO	24/09/2013 15:54:14	RUN
10007616	NBO	24/09/2013 15:55:56	CMP
10007616	NCA	24/09/2013 15:55:56	CMP
10007616	NCA	24/09/2013 15:55:56	RDY