Am getting an OLAP error, due to missing group by clause while accesing my analytic views in IDT. Can you help me to know what is the additional settings i need to do at IDT level?
We are alo facing same issue while creating Universe on Analytic view and publishing it to Repository (we are using ODBC Connection).
As mentioned in the note I have changed the measures SQl sattement to SUM() however I am getting same kind of error for Attributes also which are of data type 'string', 'varchar' and 'Date'
Sorry, I haven't used the ODBC connection in the IDT to connect to HANA.
For JDBC, all I had to do was:
a. In the business layer, right click on the measures and convert them from attributes to measures
b. Mention the aggregation type - e.g. SUM, MAX etc
After the above, when I created a query or say a WEBI report on top of the business layer of IDT, it automatically added the group by clause depending on my selection in the query.
I am guessing it should be the same for ODBC as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.