Oracle Business Intelligence

Products Banner

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

Received Response
42
Views
3
Comments

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?

Tagged:

Answers

  • 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.

  • User_92LR5
    User_92LR5 ✭✭✭

    Dear Christian

    I understood your point.


    Thanks

  • User_92LR5
    User_92LR5 ✭✭✭

    Hi Everyone,


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