"Unable to process one or more commands" error message
Hi ,
I am getting error while trying to implement dynamic dimension security.
The error reads as follows:
Unable to process one or more commands.
User-generated error - the dimension "<Dimension Name>" has no valid member. For more information, see your administrator.
User-generated error - the dimension "<Dimension Name>" has no valid member. For more information, see your administrator.
This error occurs when we try to test the role in Analysis Services 2000/sp4. on a windows 2003 server.
I tried BOTH the solutions suggested inhttp://support.microsoft.com/default.aspx?scid=kb;en-us;824419
but NO USE. The error remains the same.
The following is the MDX query I am using :
Filter
([Division].[Iclas].Members,(StrtoTuple("[User].[" +Username +"]"), [Measures].[Sales]) = 1)Please Help.
[1357 byte] By [BhanuKiran.K] at [2007-12-24] 