Re: Dynamic User Security

#1

Hi all

I still have have the problem, but I noticed that if I reprocess the cube using the AS interface, the dynamic security works
If I reprocess the cube using a job, the problem still remain
My question is

-is there a workaroud that solves the problem
-why I can't use a job to reprocess the cube

Thanks in advanc
J

----- Mosha Pasumansky [MS] wrote: ----

"Jorge Micheloni" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:E4D7228F-7678-4042-BA79-9F9604268250 (AT) microsoft (DOT) com..

Quote:

I created a dynamic user security adding a statement i
the Advanced Tab of the Custom dimension security, using the filter an
username function on a virtual cube, composed of one 'Security' cube and on

'Data' cube

Quote:

This solution seems to work properly, and the users can connect to th
virtual cube using Excel PTS
The problem is that very often the connection to the cube is lost and th
user can't connect to the virtual cube when he/she opens a previously save

Excel file

Quote:

If I reprocess the virtual cube, the user can connect to the virtual cub
again
Every day a job processes all the existing cubes, virtual cubes included
so they should be processed; I don't understand where the error i

generated

There is a known issue with updating roles and virtual cube. If the databas
role is updated, users may lose access to the virtual cube, and virtual cub
needs to be reprocessed. Perhaps this is what happens in your case

--
=================================================
Mosha Pasumansky - http://www.mosha.com/msola
Development Lead in the Analysis Server tea
All you need is love (John Lennon
Disclaimer : This posting is provided "AS IS" with no warranties, an
confers no rights
=================================================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Dynamic User Security

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Dynamic User Security - 05-12-2004 , 08:51 AM