Thanks Petter, it's working fine now.
could u pls tell me,like if i have to use any other function in my DIRECT QUERY, then i have to use NATIVE..?
And i m trying to use case statement could you pls help me with this also..
when(Pay<=100) then '0 to 100'
when(Pay<=250) then '100 to 250'
when(Pay<=500) then '250 to 500'
end as pay_range;