MDX Problem

Hi,

I am a fresher for Analysis service.

can i include measures in selection creteria (Where condition).

i am going to show some set of rows. [event count] is comes under measures.

already i have taken [event count] is one column in my query. can i include [event count] in selection creteria.

email id name event count

--

xxx xxxx 12

yyy yyyy 45

zzz zzzz 20

this is resulted value. can i filter, event count is greater then 40

Thanks in advance.

Regards,

Nanda kumar R

You could use Filter() or the "having" clause, as in this Adventure Works query (customers with > 3 orders):

>>

select

{[Measures].[Internet Order Quantity],

[Measures].[Internet Sales Amount]} on 0,

Non Empty [Customer].[Customer].[Customer].Members

* [Customer].[Email Address].[Email Address].Members

having [Measures].[Internet Order Quantity] > 3 on 1

from

[Adventure Works]

where

[Customer].[Customer Geography].[City].&[Calgary]&[AB]

Internet Order Quantity Internet Sales Amount
Alisha G. She alisha24@.adventure-works.com 5 $4,343.59
Carly Yuan carly6@.adventure-works.com 5 $194.96
Damien A. Deng damien18@.adventure-works.com 4 $578.46
Kristi S. Malhotra kristi21@.adventure-works.com 7 $4,850.33

>>