I think I understand your problem. You are trying to create a string measure in a cube Measure Group so that you can then include it in your drill...

Thanks Craig

The over lap was intentional. The main point is that the same user sees different rows when in different contexts (Finance or Production).

Yes the Table Function does cause...

Hi Craig, thanks for your answer.

I can see how you have done this.

Perhaps a better term for what I have called "Security Groups" is "Security Area or Domain".

We could set...

Okay, thanks for your comments.

Has anyone else tried something like this? I'm keen to hear of your experiences.

Yes the Security Groups do overlap which data they can see.

No it is not hierarchical, and yes a person/ADGroup can be a member of more than one Security Group.

The security is reasonably static. New hires get added to the appropriate AD groups, so the security I designed works off either Windows User accounts or groups. Preference...