Hi,

I'm using AS 2000 with SP3. I have a dts job that processes my dimensions
and cubes (all full proces)
First all the dimensions. Then the security cubes (i'm using dynamic
security).
Then everytime my data cube and then the virtual cube that combines my
security cubes and the data cube. This works all fine without any errors.

But when I try to access my application based on the virutal cube I get an
error saying that he can't retrieve any information. If I then reproces my
vitual cube again, I get the data.

Does anyone have an idea? Is there a certain time interval between
processing of data cube and virtual cube? Can't I proces a cube and vitual
cube in the same dts package? ...

Regards,
Nico

This is a known problem with virtual cubes and roles. Unfortunatelly due to
some very difficult technical issues, it is not easy to fix, and it is not
fixed in SP4.
Yukon doesn't have such problem.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

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

Nico,

can you please explain me How did you do dynamic security and method
you implemented in applying the dynamic security
I need to implement dynamic security for user who logs in to see his
data in the cube.

Please mail me on tawarg (AT) yahoo (DOT) co.in

Regards,
Pras

See the material that Mosha posted for me.
http://sqljunkies.com/WebLog/mosha/a...2/16/5605.aspx
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

<tawargerip (AT) hotmail (DOT) com> wrote