Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

vikasshana
New Contributor III

Need help in section access

Hi,

I need help in defining section access. I'm using the below code in order to test whether the section access is working fine or not.

LOAD * INLINE [
Plarform
A
B
C
D
E
]
;

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, NAME, Platform
USER, HBEU\04741072, Adam, A
USER, HBEU\04741072, Adam, B
ADMIN, HBEU\44082191, Varun, *
USER, HBAP\43848019, Brahma, C
]
;
Section Application;

As you can see from the above code Adam can access only 'A' and 'B', Varun can access all the Platforms and Brahma can access only 'C'.

I've published the report and forwarded the link to Adam and Brahma and they are saying they can able to see all the platforms but I gave access to only 'A' and 'B' to Adam and 'C' to Brahma. Can you help me on what I'm doing wrong here.

Regards,

Vikas

Tags (1)
11 Replies

Re: Need help in section access

Try this.

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, NAME, Platform

USER, HBEU\04741072, Adam, A

USER, HBEU\04741072, Adam, B

ADMIN, HBEU\44082191, Varun,

USER, HBAP\43848019, Brahma, C

];

Section Application;

LOAD * INLINE [

Plarform

A

B

C

D

E

];

Also make sure that you have checked the "Initial Data reduction based on Section Access" option in document properties.

Regards,

Kaushik Solanki

vikasshana
New Contributor III

Re: Need help in section access

Thanks for the Code kaushik.solanki‌, I changed the code and checked 'Initial Data reduction based on Section Access' still they can able to see A B C D E.

Re: Need help in section access

did you try to change the Name as Upper(Name)..?

vikasshana
New Contributor III

Re: Need help in section access

I've tried the below code and it still says the same

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, UPPER(NAME), Platform
USER, HBEU\04741072, Adam, A
USER, HBEU\04741072, Adam, B
ADMIN, HBEU\44082191, Varun, A
USER, HBAP\43848019, Brahma, C
USER, HBEU\44067097, Gavin, D
]
;
Section Application;
LOAD * INLINE [
Platform
A
B
C
D
E
]
;

Re: Need help in section access

No.

Like this..

Section Access;

LOAD * INLINE [
ACCESS, NTNAME, NAME, PLATFORM
USER, HBEU\04741072, ADAM, A
USER, HBEU\04741072, ADAM, B
ADMIN, HBEU\44082191, VARUN, *
USER, HBAP\43848019, BRAHMA, C
]
;

Section Application;

LOAD * INLINE [
PLATFORM
A
B
C
D
E
]
;

vikasshana
New Contributor III

Re: Need help in section access

Thanks for that, but I changed my code as below and published,

LOAD * INLINE [
ACCESS, NTNAME, NAME, PLATFORM
USER, HBEU\04741072, ADAM, ATM
USER, HBEU\04741072, ADAM, DATABASE
ADMIN, HBEU\44082191, VARUN, *
USER, HBAP\43848019, BRAHMA, DESKTOP
]
;

Section Application;

LOAD * INLINE [
PLATFORM
ATM
DATABASE
DESKTOP
DMZ ROUTERS AND SWITCHES
F5-LOADBALANCER
FIREWALL DEVICES
FIREWALL RULES
IPS IDS
ISERIES
PROXIES
UNIX/LINUX
WINDOWS SERVER
WIRELESS LAN CONTROLLERS
]
;

After publishing I've to see all the Platforms but i can able to see only ATM, DESKTOP and DATABASE only.

MVP
MVP

Re: Need help in section access

The * wildcard does NOT mean see everything. It means "see all the option listed in the section access table".

To see everything, you will need to include all the possible values of PLATFORM in the SA load.

MVP
MVP

Re: Need help in section access

You could use logic like this to generate the necessary extra lines:

PLATFORMS:

LOAD * INLINE [

  PLATFORM

  ATM

  DATABASE

  DESKTOP

  DMZ ROUTERS AND SWITCHES

  F5-LOADBALANCER

  FIREWALL DEVICES

  FIREWALL RULES

  IPS IDS

  ISERIES

  PROXIES

  UNIX/LINUX

  WINDOWS SERVER

  WIRELESS LAN CONTROLLERS

];

Access:

LOAD 'ADMIN' as ACCESS,

  'HBEU\44082191' as NTNAME,

  'VARUN' as NAME

AUTOGENERATE 1;

Join(Access)

LOAD PLATFORM Resident PLATFORMS;

Concatenate(Access)

LOAD * INLINE [

  ACCESS, NTNAME, NAME, PLATFORM

  USER, HBEU\04741072, ADAM, ATM

  USER, HBEU\04741072, ADAM, DATABASE

  USER, HBAP\43848019, BRAHMA, DESKTOP

];

SECTION ACCESS;

LOAD *

Resident Access;

SECTION APPLICATION;

DROP Table Access;

Re: Need help in section access

We can achieve this by simply replacing * with blank as suggested by kaushik.solanki‌ in their 1st reply.

Section Access;

LOAD ACCESS,NTNAME,Upper(NAME) as NAME,upper(Platform) as PLATFORM INLINE [

ACCESS, NTNAME, NAME, Platform

USER, HBEU\04741072, Adam, A

USER, HBEU\04741072, Adam, B

ADMIN, HBEU\44082191, Varun,

USER, HBAP\43848019, Brahma, C

];

Section Application;

LOAD * INLINE [

Plarform

A

B

C

D

E

];

Regards,

Regards,
Prashant Sangle