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 |