Hi,

I am using Yukon Beta 2 Analysis services.

I have couple of Cubes and related dimensions. I access these using MDX
query from web application. In the Roles for this database in Analysis
Services i added a new member which i want to use from my web app. The
previous member in Roles work fine.
This new member has exactly same set of permissions on Cubes,Dimensions and
datasources.
Now as this new member when i run my MDX query, it gives me with following
error:

Exception Error Code : -1056309153(An MDX expression was expected. A full
statement was specified.)

The syntax of MDX is perfectly correct. If i change the user to previous
user, the same MDX query run fine and give result.
Here is the MDX query which gives error on new member but works fine for old
one:

SELECT {[Measures].[Duration] } ON COLUMNS

FROM ( SELECT ( [Client16_Time Dimension].[Time].[00:00:00] : [Client16_Time
Dimension].[Time].[23:59:59],* ) ON COLUMNS FROM (SELECT ( [Client16_Date
Dimension].[Date].[2005/05/01] : [Client16_Date
Dimension].[Date].[2005/05/28],* ) ON COLUMNS FROM [Network8_PlayLogCube]))
CELL PROPERTIES VALUE

Now if the change this MDX to a much simpler version without any filter
expressions:
SELECT {[Measures].[Duration] } ON COLUMNS
FROM [Network8_PlayLogCube])) CELL PROPERTIES VALUE

It works for new user also. After adding this new member to Role i processed
cubes and dimensions again.
I don't know why this is happening, there is no problem in Syntax of MDX
query,but error seems like there is some error there. The MDX query runs fine
with old member.

If anyone knows why this is happening or have any ideas please help.