Section access

[Gowtham174]

Hi All,

From the below script User DF should have access only for DOMESTIC_FOREIGN but it will show for all other flight type.

Can you please help me to understand section access in details with the example.

Section Access;
LOAD * INLINE [
  ACCESS, USERID, PASSWORD, FLIGHTTYPE
  ADMIN, ADMIN, ADMIN123, *
  USER, DF, DF123, DOMESTIC_FOREIGN
  USER, DU, DU123, DOMESTIC_US
  USER, IF, IF123, INTERNATIONAL_FOREIGN
];
Section Application;

LOAD * INLINE [
  Flight Type, FLIGHTTYPE
  "Domestic, Foreign Carriers", DOMESTIC_FOREIGN
  "Domestic, US Carriers Only", DOMESTIC_US
  "International, Foreign Carriers", INTERNATIONAL_FOREIGN
  "International, US Carriers Only", INTERNATIONAL_US
];

Thanks,

Gowtham

[PrashantSangle · Accepted solution]

check document property > Opening > Initial Data Reduction Based on Section Access > Strict Exclusion must tick

Regards,

[jonathandienst]

Remove the quotes from the inline table load. With the quotes like that, FLIGHTTYPE is not being populated so the SA is not working.

LOAD * INLINE [
  Flight Type, FLIGHTTYPE
  "Domestic, Foreign Carriers", DOMESTIC_FOREIGN
  "Domestic, US Carriers Only", DOMESTIC_US
  "International, Foreign Carriers", INTERNATIONAL_FOREIGN
  "International, US Carriers Only", INTERNATIONAL_US
];