SELECT VS DIRECT QUERY

[woshua5550]

Hi , guys

look at this

using SELECT method :

Result:

This is what i want and then i try to trun it into DIRECT QUERY method

using DIRECT QUERY method:

the result is as follow

How could this possible?

could anyone tell me what's wrong with it?

DATABASE: SAP HANA

thanks in advance