Security

[#1]

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

[krishna20]

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;