Lots of roles applied to a large dimension can chew up a lot of memory. Each
role (consisting of distinct permission to the dim) causes a so-called
"shadow dimension" to be created in server ram. The shadow dimension
consists of every allowed member, every sibling of every allowed member, and
every ancestor of every allowed member. It's my understanding that the
shadow dimension is instantiated when user connects to cube. I don't know
why cube processing would be impacted however.

If you search this group for "security AND dimension AND roles" you will
find many discussions on this topic. Good luck.

public @ the domain below
www.tomchester.net

"Caro" <anonymous (AT) discussions (DOT) microsoft.com> wrote

(include in a role that only see a set of these dimension) connect at a
first time, after cube process, it takes so many time ( aroune 30') to get
the information...