OBIEE 12C to SAP HANA ODBC Connectivity Issue on SUM Functions

Question

Hi,

I hope you all are doing well.

Recently we are using SAP HANA DB as a data source for OBIEE 12C environment and are utilizing a third party ODBC driver to achieve the same.

Connectivity, table and view import also working fine in the Admin Tool; Creating reports on normal column is working fine however while creating report on a aggregated function on the obiee reporting layer, I am facing the below issue:

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

State: HY000. Code: 16001. [nQSError: 16001] ODBC error state: 42000 code: -1 message: The function 'SUM' is not supported.. (HY000)

State: HY000. Code: 16014. [nQSError: 16014] SQL statement preparation failed. (HY000)

SQL Issued: SET VARIABLE LOGLEVEL=5; SELECT 0 s_0, "SAP BW"."F AR Aging"."Customer Id" s_1, "SAP BW"."F AR Aging"."Customer Name" s_2, "SAP BW"."F AR Aging"."Advance" s_3, REPORT_SUM("SAP BW"."F AR Aging"."Advance" BY ) s_4 FROM "SAP BW" WHERE ("F AR Aging"."0CUSTOMER" = '0000100001') FETCH FIRST 65001 ROWS ONLY

I alredy check the same query and executed on SAP HANA DB and it is working fine there and executed the same query through ODBC Connection on the SQL DB and it is working fine.

Its something to do with the OBIEE.

Can you please help me on this issue?

User_92LR5 · Answer

Hi Everyone,

If there is any help in this regard, it will be highly appreciated.

User_92LR5 · Answer

Dear Christian

I understood your point.

Thanks

[Deleted User] · Answer

Hello,

All Oracle communities are free and participation is voluntary. Nobody is getting paid to answer questions in here. If you have something urgent, then hire a consultant to do it. Asking somebody else to do your urgent work for free is not just against community rules, it's also quite unethical and off-putting.

Community work is community work and there to help others work around problems and LEARN, but do not mistake this for an open invitation to have critical tasks fulfilled by others with no pay.