Filter using member properties

#1

Hi,

I want to filter my Customer dimension using its member property Sales
Division Code. I keep on getting a syntax error. Can point out the right way
of doing this?

FILTER([Customer].Members,
[Customer].CurrentMember.Properties("Sales Division Code") = "NO")

Thanks!

#2

See the Member Property Bootcamp article in SQL Magazine, August 2003 -- it
answers this question and many others with lots of tips and tricks for using
member properties. In my opinion, it is one of Russ' best articles.
http://www.windowsitpro.com/Article/...384/39384.html

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Laura" <Laura (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I want to filter my Customer dimension using its member property Sales
Division Code. I keep on getting a syntax error. Can point out the right
way
of doing this?

FILTER([Customer].Members,
[Customer].CurrentMember.Properties("Sales Division Code") = "NO")

Thanks!

#3

Hi Dave,

I'm not so sure if I am a member. Would you know if this is covered by MSDN
subscription? Thanks.

"Dave Wickert [MSFT]" wrote:

Quote:

See the Member Property Bootcamp article in SQL Magazine, August 2003 -- it
answers this question and many others with lots of tips and tricks for using
member properties. In my opinion, it is one of Russ' best articles.
http://www.windowsitpro.com/Article/...384/39384.html

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Laura" <Laura (AT) discussions (DOT) microsoft.com> wrote in message
news:7BB8311F-3441-47DE-8684-79968CED4C69 (AT) microsoft (DOT) com...
Hi,

I want to filter my Customer dimension using its member property Sales
Division Code. I keep on getting a syntax error. Can point out the right
way
of doing this?

FILTER([Customer].Members,
[Customer].CurrentMember.Properties("Sales Division Code") = "NO")

Thanks!

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

Filter using member properties

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

Filter using member properties - 10-22-2004 , 10:35 AM

Re: Filter using member properties - 10-23-2004 , 01:32 AM

Re: Filter using member properties - 10-25-2004 , 10:59 AM