Hi All,
I have to restrict the data for a group of users using row level security. When user login he has to see his geographical data based on selection of measures from fact tables. Geogrpahy dimension is linked to two or more fact tables.
Ex: A(geography dimension), B(Fact table1), C(Fact table 2)
A=B and A=C
Thanks
asiddiqu (BOB member since 2008-01-04)
A search with keywords as ‘row level restrictions’ would have helped instead of opening this post because this topic is discussed hundred of times in the past.
If you are using XIr2 then use the ‘access restrictions’ feature in Universe designer, or in Supervisor for versions prior to XIr2.
.
haider 
(BOB member since 2005-07-18)
I have searched but could not find out the resolution for that issue.
I am using BO XI R2 With SP2.
Thanks
asiddiqu (BOB member since 2008-01-04)
Start here: Using Designer to Implement Row-Level Security
It’s old, but still relevant.
Steve Krandel 
(BOB member since 2002-06-25)
Steve,
Was your posting a test? The link you posted is for “Executive Director of Reform Temple” in California… 
{moderator note … I fixed the link … dwayne}
jsanzone (BOB member since 2006-09-12)
Sorry 'bout that. Must have forgotten to cut. 
Steve Krandel (BOB member since 2002-06-25)