cube security

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