Hai All,
I am a new member to this Group. i want to write an MDX Query with an
OR Clause.
In Detail i have a measure for counting the number of records. the
requirment is to view the measure in 2 different dimension say one
dimension is Date and the other dimension is Types. Now i have to look
for a measure which is particular for a date (or) the dimension lies
with one particular type. If i pull the dimension of date and choose a
particular date then those records which are satisfied for that date is
displayed. If i pull dimension type and then view the measure it is
displaying. if i want to view those records which are present for a
particular date or a particular type i am not able to view because if i
drag and drop it auomatically takes and clause.


Please help me out !!!!!!
Thanks in Advance....

Here's an example Adventure Works query, which returns [Order Quantity]
when either the Date is "Jul 31, 2001" (= 5) or the Product Name is
"Road-150 Red, 44" (= 437). Note that the total is 441, not 442, because
[Order Quantity] = 1 when both conditions apply, so this should not be
double-counted.

from [Adventure Works]
where {([Date].[Calendar].[Date].&[31],
[Product].[Product Categories].[All Products]),
([Date].[Calendar].[All Periods],
[Product].[Product Categories].[Product Name].&[311])}
------------------------------------------------------
Order Quantity
441

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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