topic Re: Section Access in QlikView

Section Access

Thu, 23 Apr 2015 05:50:17 GMT

Team

I am having one inline table called

Re: Section Access

ziadm — Thu, 23 Apr 2015 05:56:26 GMT

Hi Section Access; LOAD * INLINE [ ACCESS, USERID, PASSWORD, NTNAME,ANIMAL ADMIN, ADMIN, *, *,* USER, USER1, *, *,Animal USER, USER2, *, *,Insect USER, USER2,*,*,Animal ]; USER1 will only access Animal data USER2 will access Animal & Insect ADMIN will access all Data Make sure that security section all in upper case ANIMAL is your dimension also has to be upper case ANIMAL field has to be in Upper case in your Fact Table Hope this help Thanks Ziad

Re: Section Access

ziadm — Thu, 23 Apr 2015 06:00:22 GMT

Sorry I had to post again because of the editor format problem

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, NTNAME,ANIMAL

ADMIN, ADMIN, *, *,*

USER, USER1, *, *,Animals

USER, USER2, *, *,Insects

USER, USER2, *, *,Animals

];

Application Section;

// This is where your fact table goes

USER1 will only access Animal data USER2 will access Animal & Insect ADMIN will access all Data Make sure that security section all in upper case ANIMAL is your dimension also has to be upper case ANIMAL field has to be in Upper case in your Fact Table Hope this help

Thanks Ziad

Re: Section Access

PrashantSangle — Thu, 23 Apr 2015 06:00:28 GMT

Hi,

Try below Session Access

Section Access;

LOAD * INLINE [

ACCESS,NTNAME,CATEGORY

ADMIN,ADMIN,

USER,H,HUMAN

USER,A,ANIMAL

];

Section Application;

Re: Section Access

Thu, 23 Apr 2015 06:31:25 GMT

I am sorry, on thing I forgotten

I want the data in the same list box ie Category

if the H User log in Category list box should have only animal and Insect

if the A user log in the Category list box should have only Insect and Human...

list box name is category

Re: Section Access

Thu, 23 Apr 2015 06:32:26 GMT

and the values are not as inline this is coming from the database

Re: Section Access

PrashantSangle — Thu, 23 Apr 2015 06:40:56 GMT

Hi,

Remove that Inline table.

It will work.

For session acces you have to do several setting also

Like in Document Property -> Opening -> Select Initial Data Reduction Based on Section Access.

Regards

Re: Section Access

jagan — Thu, 23 Apr 2015 06:48:30 GMT

Hi,

Check this sample script

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, REDUCTION

ADMIN, Admin, *

USER, Sales, 1

USER, Market,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.

Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option

Hope this helps you.

Regards,

Jagan.

Re: Section Access

Thu, 23 Apr 2015 10:37:13 GMT

i tried all the way around with your ideas but not working.

Re: Section Access

Thu, 23 Apr 2015 10:38:07 GMT

Jagan

I got the idea from the same example what you posted. but not working

Re: Section Access

jagan — Fri, 24 Apr 2015 07:29:47 GMT

Hi,

Did you done this

Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option