Cube Security

[ksupun]

We have sales rep hierarchy which breaks down as area, district, office...sales rep level where we are planning to apply security to each group level.

We are able to create security group for each level and apply security based on area group, district group... so each member belongs to that group login they should be able to see their group data. we would be maintaining the members in AD.

But for bottom level we need to apply security as each user login they should be able to see only those reports but there are hundreds of representatives belong to sales rep group where if I apply security on Representative group level , all user under that group would see the same data. I believe it should be common issue for most of client but I haven't worked on cube security and not able to figure out the solution.

Any suggestions