Qlikview SAP HANA connector does not support group by in the script of select ?

[geogou1973]

Hello,

I am connecting in sap hana with qlikview sap hana connector 7.0.1.0

I write the following script 

SELECT
GJAHR,
MONAT
FROM table
GROUP BY GJAHR,
MONAT;

which is correct and does not run and a take the message

The field "MONAT" from the SELECT list is missing in the GROUP BY clause.

the sap connector does not support group by clause or something else happens ?

Can anyone knows and help me about this problem ?

Thank you in advance.

[geogou1973]

I tried to do the same sql with one dimension 

SELECT
MONAT
FROM table
GROUP BY 
MONAT;

and it worked. I don't know why for more than one dimension the connector fails.

[Hakan_Ronningberg · Accepted solution]

Hi,

Try to remove the commas. This statement works in our test system:

select spart vtweg from vbak
group by spart vtweg

Regards,
Håkan

[geogou1973]

Hello Hakan.

It worked fine.

Thank you.