Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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
Hello Hakan.
It worked fine.
Thank you.