The WHERE clause function expects a tuple set expression for the argument. A string or numeric expression was used

Question

I use SQL Server 2008 R2 and i use AdventureWorks2008 DataBase.

I Write MDX Query In SSAS.

I want filter result of query.

I write this query

SELECT 
Measures.[Internet Sales Amount] ON COLUMNS,
CROSSJOIN( 
            {Product.[Product Line].[Product Line].MEMBERS}, 
            {[Customer].[Country].MEMBERS}
         ) on ROWS 
FROM [Adventure Works] 
Where 
 ( Measures.[Internet Sales Amount] > 2000000 )

and i get this error

Executing the query ... The WHERE clause function expects a tuple set expression for the argument. A string or >numeric expression was used.

Execution complete

why i get this error?

Answer 1

use this query

SELECT 
Measures.[Internet Sales Amount] ON COLUMNS,
Filter (
            CROSSJOIN( 
                        {Product.[Product Line].[Product Line].MEMBERS}, 
                        {[Customer].[Country].MEMBERS}
                     ) ,    
            ( Measures.[Internet Sales Amount] > 2000000 )       
         ) on ROWS 
FROM [Adventure Works]