Need help in section access

[vikasshana]

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

[kaushiknsolanki]

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]

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.

[settu_periasamy]

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

[vikasshana]

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
];

[settu_periasamy]

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]

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.

[jonathandienst]

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.

[jonathandienst]

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;

[PrashantSangle]

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,