Measures in filters

#1

Hi
I have to write a mdx query in which I have to fetch only records that meet that criteria
For Eg
Select {[Measures].[Unit Sales],[Measures].[Store Sales],[Measures].[Profit],[Measures].[Sales Average]} on columns
[Time].[Month].members on row
from sale

I need to select only those records whose [Measures].[Sales Average] > 6.50, how do I do that, please let me know
Thanks in ADVANC
Bes
Mo

#2

Select {[Measures].[Unit Sales],[Measures].[Store Sales],[Measures].[Profit],[Measures].[Sales Average]} on columns
{Filter([Time].[Month].members, [Measures].[Sales Average]> 6.50 )} on row
from sale

----- Mon wrote: ----

Hi
I have to write a mdx query in which I have to fetch only records that meet that criteria
For Eg
Select {[Measures].[Unit Sales],[Measures].[Store Sales],[Measures].[Profit],[Measures].[Sales Average]} on columns
[Time].[Month].members on row
from sale

I need to select only those records whose [Measures].[Sales Average] > 6.50, how do I do that, please let me know
Thanks in ADVANC
Bes
Mo

#3

Take a look here:

http://msdn.microsoft.com/library/en...tions_5tf6.asp

Francesco De Chirico

#4

I have sent you the required MDX query be email.

Thanks,
Abhinav kumar
akumar (AT) itmag (DOT) com.au

Quote:

-----Original Message-----
Hi ,
I have to write a mdx query in which I have to fetch
only records that meet that criteria.
For Eg:
Select {[Measures].[Unit Sales],[Measures].[Store Sales],
[Measures].[Profit],[Measures].[Sales Average]} on

columns,

Quote:

[Time].[Month].members on rows
from sales

I need to select only those records whose [Measures].
[Sales Average] > 6.50, how do I do that, please let me

know.

Quote:

Thanks in ADVANCE
Best
Mon

.

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

Measures in filters

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

Measures in filters - 06-09-2004 , 08:36 AM

RE: Measures in filters - 06-09-2004 , 09:36 AM

Re: Measures in filters - 06-09-2004 , 09:40 AM

Measures in filters - 06-10-2004 , 07:47 PM