Where clause in direct discovery

[omid5ive]

hi

i have below query and i need to use it in direct dicovery

--------------------------------------

DIRECT QUERY

dimension

       ACOUNT_NUMBER,

       REMDEPDATE,

MEASURE

REMDEP

FROM GHR_TA_CLOSE_BALANCE a

WHERE A.SANAD_DATE_NO = (SELECT MAX (A.SANAD_DATE_NO)

                            FROM GHR_TA_CLOSE_BALANCE a)

------------------------------------------------------------------------------------

when i reload this query i get attached error

how can i sole it?

[omid5ive]

no new message
No direct statement