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

cube security

Started by raven31, 25 Oct 2010 07:37:08 AM

Previous topic - Next topic

raven31

Hello,

I have started working with Transformer but I am not an expert yet  ;)

I have this problem. I want to assign security to my Cube. Let's say I want to to give access to the Cube for over 300 sellers. Every seller must see only some portion of the data. Let's say I have separate dimension for seller. And now if one seller connects to the cube I want him to see only his portion of data.

I have read that Custom Views may help me doing it, but I can't imagine creating 300 views, managing them, etc.  :o

Anyone can help me with that.

Regards,

nanzmercado

why dont u try to have the data assigned to the seller in the table.

ex. item categories
Category ABC - Seller 1
Category DEF - Seller 2 and so on..

Seller must be one of ur dimensiones

Next Steps:
1. create a separate Data Source for that in the Transformer.
2. Generate the Categories of that Data Sources
3. assign the users in the cube (grant)
4. Go to Diagram (Show Diagram) - another window will appear
5. Go to User Class Tab
6. Search for each seller (user), under each user will give u the Dimensions available.
7. from ther u may grant only the data they will need to see.

Gud luck.. it is quite long but it is easy as u go along.