MDX query syntax problem

#1

I am trying to test dynamic dimension security but running into a syntax
error and not sure where.

Filter([Employees].[Name].Members,[Employees].CurrentMember.Properties("Manager Login") = UserName)

Can anyone assist? Thanks in advance.

#2

What does the syntax error say, and are you using AS 2000 or 2005?

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

#3

Hi, I was able to get pass the syntax problem. Thanks for your response. I
believe I posted the correct syntax to help someone else in another posting.

"Deepak Puri" wrote:

Quote:

What does the syntax error say, and are you using AS 2000 or 2005?

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

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

MDX query syntax problem

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

MDX query syntax problem - 08-09-2006 , 10:58 AM

Re: MDX query syntax problem - 08-09-2006 , 04:06 PM

Re: MDX query syntax problem - 08-17-2006 , 10:42 AM