Hierarchy Row Level Authorization

[Former Member]

Hello Team,

I need to apply rowlevel security at every node of an hierarchy....To clear the requirement more, Say I have 1000 users and the geography hierarchy is of 5 level like Region->Country->City->District->Branch…..L1,L2,L3,L4,L5 resp...say for example we need row level security to 5 levels in hierarchy. L1, L2, L3 , L4, L5. L1 being at top in hierarchy. now the issue is L1 has 6 values, L2 has 20, L3 has around 20, L4 has around 14 and L5 has around 13. now the unique combination is running around in 20k+. what is the best approach to do so?

Thank You,

Amol

[lucas_oliveira]

Hello Amol,

You might want to take a look at Dynamic Analytic Privileges. Maintaining this sort of filtering manually is cumbersome and error prone.

Creating a procedure to get the values for a user based on a region-user assignment table would at runtime. There are lots of discussions for that topic here in SDN.

Here is one to start you up:

Hope that helps.

**EDIT**

In SPS10  Hierarchies have been powered up a bunch (specially with SQL access). Check this out:

Take a look at the new features on the Modeling Guide (http://help.sap.com/hana/SAP_HANA_Modeling_Guide_for_SAP_HANA_Studio_en.pdf) and see if it fits your requirements.

If not, explain a little bit more the scenario . Examples always help....when written in a formatted way

BRs,

Lucas de Oliveira