Hi Group
I need some help implementing dynamic dimension security.
My environment is:
SQL Analysis Services 2005 Standard
Windows 2003 Server

I have a dimension lets call it store name and an attribute is store
code.

I want to implement dynamic security on store code. There could be many
users allowed to see a particular store so i created a table with
store code, username in it and joined it in the DSV and dimension view
to the stores table...

My problem is that not all stores are in the security table are present
and therefore when i process the dimension, i only see the stores that
have users attributed to them...so here are my thoughts...

a: Make the stores table and the security table a 1-1 relationship with
the use of an ALL username. Trap this value in the allowed members mdx
for therole ( help needed here as mdx is not a strong point at moment)
b: Implement seperate roles for each store with seperate domain groups
for each strore - at moment there are 200 or so stores so this is a
management nightmare....
c: something else?

Any pointers would as always be greatfully received....

AW