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,
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.