![]() So, instead of filling out the logon form you can just enter to have ODBC use the HDBUSERSTORE-entry named. I’ve mentioned the HDBUSERSTORE earlier and really like how it makes getting access to the SAP HANA server seamless. ![]() You can now either type in the usual SAP HANA logon credentials (hostname, port number, username and password) or, and this is really nice, you can use an entry from the secure HDBUSERSTORE. This is easy to do with the SAP HANA client program odbcreg.exe (to be found in the installation folder of the SAP HANA client software).īy using the command odbcreg.exe -t hdbodbc the driver is loaded and a logon dialog window is opened.Ī nice giveaway is that the exact driver software version information can be found in the title bar of this dialog window. ![]() Let’s see the nuggets in there!Ī common task is to check the database connectivity via ODBC after a user workstation has been set up. While I’ve no idea on when the SQL reference will follow, I still use the web browser integration until then. This means:no more back and forth between the PDF and the HANA studio as well as ‘F1’ help in the studio.Īs you can see, the SAP HANA Administration Guide, the SAP HANA Developer Guide and the SAP HANA SQLScript Reference are now ‘on board‘. 1.1, (really that date? not even 12.12.12? □ ) and found something pretty nice in there for ODBC and JDBC users.īy the way: meanwhile (as of SPS 5) three of the files from the HANA documentation website have been included into the local eclipse help. I just browsed throught the updated SAP HANA Developer Guide, SPS 05, Ver. ![]() 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.Based on revision 48 (SPS 5) of SAP HANA Studio and Database 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 ![]() ODBC error state: 42000 code: -1 message: The function 'SUM' is not supported. 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |