After Applying Section Access on Area Code, Territory Code and Region a few Region disappear?

[#1]

After Applying Section Access on Area Code, Territory Code and Region but a few Regions disappear, after applying admin security overide in the document security it starts showing all the regions and everything . Unable to understand the issue.

Section Access;

LOAD ACCESS,

     NTNAME,

     REGION_KEY,

     text(TERRITORY_KEY) as TERRITORY_KEY,

     text(AREA_KEY) as AREA_KEY,

     BRAND_KEY

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD ACCESS,

     REGION_KEY,

      text(TERRITORY_KEY) as TERRITORY_KEY,

      text(AREA_KEY) as AREA_KEY,

     BRAND_KEY

FROM

(ooxml, embedded labels, table is Sheet2);

Section Application;

[thomaslg_wq]

Does the section access file contains all the possibilities ? It must be the issue. ==> Your second table should be created not with the section access source but with your model fact table.

And, you should work with only one field ==> REGION_KEY&'/'&TERRITORY_KEY&'/'&AREA_KEY&'/'&BRAND_KEY as %SECURITY_KEY

[thomaslg_wq]

You should look at this :

Basics for complex authorization

Very good post.