topic Re: Security in QlikView

Security

Tue, 22 Sep 2015 09:30:08 GMT

Hi All,

I have 3 tables Fact, PRFT,BAC I need to apply section access based on Region, Sub Region, Business Unit. Region, Sub Region is in PRFT table and Business Unit is in BAC table.

I have done coding (in second tab and commented)for this but it is working either Business unit or Region and sub Region. Could you please help me here

Thanks,

Chiru

Re: Security

Tue, 22 Sep 2015 09:33:45 GMT

For use Section Access see this post:

https://community.qlik.com/docs/DOC-5917

Regards

Gennaro

Re: Security

Tue, 22 Sep 2015 09:47:16 GMT

See the attachment

User this access login:

Admin Admin123

user user123

Re: Security

Tue, 22 Sep 2015 09:59:30 GMT

Hi Voto,

I am not able to open this QVW with Admin123 or user123.

Please help me here.

Thanks,

Chiru

Re: Security

Tue, 22 Sep 2015 10:06:58 GMT

Use

User ID: Admin

Password: Admin123

or for reduce data

User ID: user

Password: user123

It works for me

Re: Security

Tue, 22 Sep 2015 10:50:09 GMT

Yes Voto,

I am able to open QVW now.

But as per my requirement i will get all Region, Sub Region, BU from one QVD and DataValue contains all these values.

that's why i have created 2 seperate columns SECURITYKEY_BG,SECURITYKEY_REG and joined with PRFT,BAC table. Please have a look on commented code and give me some suggestion.

Thanks,

Chiru

Re: Security

Tue, 22 Sep 2015 11:03:10 GMT

OK, can you provide me the source file "Book1.xlsx"

so i can test load script.

Re: Security

Tue, 22 Sep 2015 11:51:12 GMT

Hi Voto,

That contains data like below:

ACCESS,NTNAME,DATAVALUE

USER,apj\ttn,AMS

USER,apj\ssd,HPS

Thanks,

Chiru

Re: Security

Wed, 23 Sep 2015 05:42:46 GMT

Hi Guys,

Any Ideas on this?

Thanks,

Chiru

Re: Security

qlikviewwizard — Wed, 23 Sep 2015 08:43:40 GMT

Hi Chiru,

Please check this thread.

Section Access

Re: Security

krishna20 — Wed, 23 Sep 2015 10:22:56 GMT

Hi,

Try with attached Excel sheet and your script might be.

PRFT:

LOAD PCD,

REGION,

SUBREGION

FROM

(ooxml, embedded labels, table is Sheet1);

Join (PRFT)

LOAD * Inline [

REGION,SECURITYKEY_REG

APJEC,APJEC

AMS,AMS

EMEA,EMEA

];

BAC:

LOAD BAC,

GBU

FROM

(ooxml, embedded labels, table is Sheet2);

Join (BAC)

LOAD * Inline [

GBU,SECURITYKEY_BG

HPS,HPS

STORAGE,STORAGE

STORAGE,NETWORK

];

Fact:

LOAD * Inline [

PCD,BAC,Amount

P1,B1,100

P2,B1,110

P3,B1,120

P4,B1,130

P5,B1,140

P6,B1,150

P1,B2,160

P2,B2,170

P3,B2,180

P4,B2,190

P5,B2,200

P6,B2,210

P1,B3,220

P2,B3,230

P3,B3,240

P4,B3,250

P5,B3,260

P6,B3,270

];

STAR is *;

SECTION Access;

LOAD ACCESS,

NTNAME,

PASSWORD,

REGION,

SUBREGION,

BAC

FROM

(ooxml, embedded labels, table is Sheet3);

SECTION Application;