Complex security application

[Anonymous]

Hi, have the following issue not sure how to address it: 

* My fact table has customers with relevant sales

* I have a related table with customer - country link

* I have a related table with customer - sales force hierarchy link

I need the following security setup: 

* Person in for example Germany should:

   1) See top level data (total sales) for all the countires

   2) See the sales rep/sales office/regional data but ONLY FOR Germany

Net I want the person to be able to do comparison on top level across all the countries, but I cannot share the insight on sales force performance in othert countries. I tried a few things without success. 

Thanks in advance for your help. 

Marcin 

[sturlaws]

Have you tried setting up row level security? I think that what your requirements, you will be able to solve it by having 2 fact tables, one with details and one aggregated to country level. And then adding dynamic row level security.

cheers,
S