![]() ![]() 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. 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 ![]() Click Add to create a new data source to connect to a SAP HANA database. Click the User DSN tab to view the data sources. Click the Drivers tab and view the installed drivers. ODBC error state: 42000 code: -1 message: The function 'SUM' is not supported. How does SAP HANA connect to ODBC Prerequisites Open the administrator by entering ODBC after clicking on the Microsoft Windows start icon. Select the SAP HANA MDX Provider from the list and click OK. Select the Other/Advanced item from the list and click Next. 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.Ĭonnectivity, 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:Įrror Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P From the Data tab on the Excel tabstrip, select the From Other Sources button, and select the From Data Connection Wizard option. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |