Hi , guys
look at this
using SELECT method :
![Right1.png](/legacyfs/online/122941_Right1.png)
Result:
![Right2.png](/legacyfs/online/122945_Right2.png)
This is what i want and then i try to trun it into DIRECT QUERY method
using DIRECT QUERY method:
![Wrong1.png](/legacyfs/online/122946_Wrong1.png)
the result is as follow
![Wrong2.png](/legacyfs/online/122947_Wrong2.png)
How could this possible?
could anyone tell me what's wrong with it?
DATABASE: SAP HANA
thanks in advance