If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Securing cube

Started by ppdeveloper, 05 Oct 2005 04:42:24 PM

Previous topic - Next topic

ppdeveloper

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.

Draoued

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 ?

ppdeveloper

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.

Draoued

Good.
Can you mark this post as closed then ?

ppdeveloper

How to mark this post as closed?

Thanks