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?

[SteveNewman]

‌"direct" is a key word and so you should not use it to name the table. Instead try something like ...

direct_query:

DIRECT QUERY

DIMENSION

ACCOUNT_NUMBER,

...

[Anil_Babu_Samineni]

Remove Comma(,) from dimension syntax

[omid5ive]

i changed it but it does not fixed

[omid5ive]

i changed it but it does not fixed

[Anil_Babu_Samineni]

I assume, You need Nested Aggregation for all resident's.

[omid5ive]

can you send me an example?

[Anil_Babu_Samineni]

In fact, i never worked with Direct Query earlier. But, I've fetch few data set from different source, Let me think little more related the same. Then we can talk

[omid5ive]

thanks a lot

[SteveNewman]

What is the new error message?