COGNOiSe.com - The IBM Cognos Community

I have following scenario to secure. I tried couple of ways to secure but I'm not getting the correct results.

User Classes in Access Manager:
RootUserClass
Sales
Ã,  Ã, USA
Ã,  Ã,  Ã,  Ã, Boston
Ã,  Ã,  Ã,  Ã, LA
Products
Ã,  Ã, Outdoor
Ã,  Ã,  Ã,  Ã, FirstAid
Ã,  Ã,  Ã,  Ã, Sunscreen

User1 has access to view only "FirstAid" product sales in "LA" only

Model has Sales and Products dimensions.

I'm expecting to see the following results:
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, Revenue
2004Ã,  Ã, LAÃ,  Ã, FirstAidÃ,  Ã,  Ã, 11957
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  ----------------------
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  OutdoorÃ,  Ã, 11957

But I'm getting the following results:
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, Revenue
2004Ã,  Ã, LAÃ,  Ã, FirstAidÃ,  Ã,  Ã, 11957
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  ----------------------
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  OutdoorÃ,  Ã, 67376

Thanks.

Can you describe how you have defined the security  in the cube itself ??

I suppose you have dragged the user-classes under the cube name in the Powercube box.
And I suppose that you have also generated some categories and in Diagram , in the user-class tab , you have created a custom view for your user-classes using Apex , cloak , suppress.

Did you ?

Thanks for the reply...

I achieved the correct results by moving "Products" user class to both "Boston" and "LA" user classes. I used "Exclude" to achieve this...

Thanks.

Good.
Can you mark this post as closed then ?

How to mark this post as closed?

Thanks