Section access on multiple fields

[sureshmaddipati]

Hi All,

I have requirement of restricting user on entity filed but we have built hierarchy  from entity field as total group,region ,country and entity description using external mapping file.

While restricting based on entity only that entity user able to see and hierarchy is getting disturbed as countries not coming under restricted entity .

Please let me know if any appropriate approach for this

[Chanty4u]

Try to do this 

LOAD

    GROUP & '-' & REGION & '-' & COUNTRY & '-' & ENTITY as HierarchyKey,

    GROUP,

    REGION,

    COUNTRY,

    ENTITY,

    ENTITY_DESCRIPTION

RESIDENT YOURFILE;

[sureshmaddipati]

Thanks Chaney,

I have used this approach but still we couldn't achieve as we have parent child relation between total group,region ,country and entity description.