dbTalk Databases Forums  

Analysis Services Error While Trying to set Dimension security programatically

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


Discuss Analysis Services Error While Trying to set Dimension security programatically in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lucas Campos
 
Posts: n/a

Default Analysis Services Error While Trying to set Dimension security programatically - 07-28-2003 , 10:43 AM






Hi,
I receive an error while trying to set Dimension Security programmatically.
It occurs when, after setting Roles and security constraints, I try to call
Update Method. The error is the same I found in
http://support.microsoft.com/default...b;en-us;816480 but I'm not
using any user defined function. The error is:

Error occurred during update of Cube 'cube' on the server: 'Error occurred
while processing security for cube 'cube'(Error in the definition of the
dimension security for the dimension 'dimension' and role 'role'. Cannot
evaluate the expression 'MDX Expression'

The Expression I'm trying to use is
{[Componente Versión].&[15.1.0],[Componente Versión].&[15.4.0],[Componente
Versión].&[15.5.0],[Componente Versión].&[15.6.0],[Componente
Versión].&[15.7.0],[Componente Versión].&[15.8.0],[Componente
Versión].&[15.9.0],[Componente Versión].&[15.10.0],[Componente
Versión].&[15.11.0],[Componente Versión].&[15.12.0]}

and I'm trying to set security for Dimension 'Componente Versión' and role
'Persona_84'. This Expression hasn't got any User defined function and there
are another expressions that can be set before this one fails.

Is this the same problem reported?
Is the HotFix included in any Service Pack?
Any idea will be welcome

Thanks

LucasC



Reply With Quote
  #2  
Old   
Bas Kersten [MS]
 
Posts: n/a

Default RE: Analysis Services Error While Trying to set Dimension security programatically - 08-26-2003 , 03:34 AM






Hi Lucas,

I have send the hotfix to you so that you can test this. Be sure that you
are on sp3 of AS before installing it.

HTH,
Bas


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.