Does MDX have an equivalent to sql's IN operator?
Here's my code:

MEMBER [d_MarketProvider].[M Total] AS
'Sum(
Filter(
[D_MarketProvider].[Market Name].Members,
[D_MarketProvider].CurrentMember.Properties("Market ID") = "1" or
[D_MarketProvider].CurrentMember.Properties("Market ID") = "6" or
[D_MarketProvider].CurrentMember.Properties("Market ID") = "8"
)
)'


This code works fine, but I was wondering if you could do something
like:

[D_MarketProvider].[Market Name].Members where
[D_MarketProvider].CurrentMember.Properties("Market ID") in
("1","6","8")

Any ideas?? Is this even posible?
Thanks in advance.

Francisco Alvarado

If the member property was mapped to a virual dimension, then you could just
slice on the member property values like any other dimension. That is the
whole purpose of a virtual dimension.
Hope that helps.
--
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.

"Francisco Alvarado" <franciscoalvarado (AT) gmail (DOT) com> wrote

You could also create a named set which includes the values, then use the
named set in your MDX, but if this is a common TYPE of thing, virtual
dimension is the way to go.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

"Francisco Alvarado" <franciscoalvarado (AT) gmail (DOT) com> wrote

Hi Dave

What would you chooe here

Have a dimension with a hierachy Level 1 - level 2 - level 3 - level 4 -
level 5

Now I need these hierachies:

a) Level 1, 2, 3, 4, 5
b) Level 5
c) Level 4
d) Level 2,3,4

Would you

1) make a) and b) physical and b)-c) virtual
2) make all physical (don't think so...)
3) make a) phyiscal and b)-d) virtual

/Michael V.

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote