Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

OR Operator in MDX

1 view
Skip to first unread message

. .Ronen

unread,
Nov 3, 2009, 12:51:20 PM11/3/09
to
Hi,

I have a question based on the need to use OR operator in a MDX query.

How can I filter a query using something like this conceptual code?

[Customer].[City]=[Customer].[City].&[Austell]&[GA]

OR

[Geography].[City]=[Geography].[City].&[Austin]&[TX]

From adventure works DW?

Thanks!

Chenn.

amish

unread,
Nov 4, 2009, 12:51:50 AM11/4/09
to

Ronen

Here is a query which will give internet sales for country australia
or canada


select [Measures].[Internet Sales Amount]
on 0
from [Adventure Works]
where {[Customer].[Customer Geography].[Country].&[Australia],
[Customer].[Customer Geography].[Country].&[Canada]}


Amish Shah
http://shahamishm.blogspot.com

. .Ronen

unread,
Nov 8, 2009, 2:00:53 AM11/8/09
to
> Amish Shahhttp://shahamishm.blogspot.com- Hide quoted text -
>
> - Show quoted text -

Thanks Amish!

Is it posible to use the "OR" while using 2 differnt hirarchies?

where
{[Customer].[Customer Geography].[Country].&[Australia],

[Date].[Date].&[20010706]}

Thanks again!
Chenn

. .Ronen

unread,
Nov 11, 2009, 1:52:53 AM11/11/09
to
On Nov 8, 9:00 am, ". .Ronen" <ronen.ch...@gmail.com> wrote:
> On Nov 4, 7:51 am, amish <shahami...@gmail.com> wrote:
>
>
>
>
>
> > On Nov 3, 10:51 pm, ". .Ronen" <ronen.ch...@gmail.com> wrote:
>
> > > Hi,
>
> > > I have a question based on the need to use OR operator in a MDX query.
>
> > > How can I filter a query using something like this conceptual code?
>
> > > [Customer].[City]=[Customer].[City].&[Austell]&[GA]
>
> > > OR
>
> > > [Geography].[City]=[Geography].[City].&[Austin]&[TX]
>
> > > From adventure works DW?
>
> > > Thanks!
>
> > > Chenn.
>
> > Ronen
>
> > Here is a query which will give internet sales for country australia
> > or canada
>
> > select [Measures].[Internet Sales Amount]
> > on 0
> > from [Adventure Works]
> > where {[Customer].[Customer Geography].[Country].&[Australia],
> > [Customer].[Customer Geography].[Country].&[Canada]}
>
> > Amish Shahhttp://shahamishm.blogspot.com-Hide quoted text -

>
> > - Show quoted text -
>
> Thanks Amish!
>
> Is it posible to use the "OR"  while using 2 differnt hirarchies?
>
> where
> {[Customer].[Customer Geography].[Country].&[Australia],
>
> [Date].[Date].&[20010706]}
>
> Thanks again!
> Chenn- Hide quoted text -

>
> - Show quoted text -

hI,
In this case i mean to use a "weak" or, which mean "OR a OR b OR the
two of them".

Thanks!
Chenn

0 new messages