I'm trying to create some roles where the user is limited to some dimension
members. I am creating the roles from managament studio.

When I save the role it take up to 7-8 min. when I look at the CPU usage I
see that 1 execution unit (2x Dual core xeon with HT -> 8 virt exec units
(x64)) is going 100% all others are 0%.
I'm working alone on the server.
The msmdsrv.exe process is going 12.50% (100%). When I look at the threads
of the process I see that the whole load is made by 1 thread and in this
thread the call stack is stuck in some call on msxml6.dll.


The server is x64 , AS2005 EE SP1 and post SP1 patch.
The OLAP database is quite small 7 dims, 4 cubes (Realtime ROLAP) and the
secutrity is applyed to only 1 dimension.


Does anyone have an ideea?
Thanks,
Radu