Introduction:

The SAP ERP Rapid-deployment solution for profitability analysis with SAP HANA provide functionality for customer to speed up the reporting ans transactional processes in CO-PA by using the SAP HANA database as secondary data persistence.

Prerequisites

  • It is recommended to use SAP kernel/DBSL 7.20
  • Only an SAP kernel 64-bit is supported. See SAP Note 1700052 if you use a non-Unicode system
  • Download HANA Client and HANA studio

1.       Install HANA client on the ERP server

  (You must install the HANA Client on all the application server – Note 1517236 1597627)

  After the installation you will see the folder – C:\Program Files\SAP\hdbclient

2.       Enter the path for the DB client software <lw>:\usr\sap\<SID>\hdbclient in the environment variable PATH for the user <SID>Adm

/wp-content/uploads/2013/12/1_350847.png

Picture 1.0

1.       Restart the server!!!

2.       Go to transaction code SM30 in table DBCON

And create new entries

/wp-content/uploads/2013/12/2_350848.png

Picture 1.1

  • DB connection – HANA SID
  • DBMS – HDB
  • User name – the user name you are creating in the HANA Studio (see next page)
  • DB password – password of the user name
  • Conn. Info – HANA server FQDN with port 30015

3.PNG

Picture 1.2

DBACockpit – Test the connection                                  

When you create the connection in table DBCON you can see the connection in the DBA cockpit under DBconnections

4.PNG

Picture 1.3

To test the connection you need to add the system to System configuration

/wp-content/uploads/2013/12/5_350957.png

Picture 1.3.1

Enter add

/wp-content/uploads/2013/12/6_350958.png

Picture 1.3.2

In the next pics enter this parameter

/wp-content/uploads/2013/12/7_350959.png

Picture 1.3.3

  • System – HANA SID
  • Mark the database connection, and choose the name of the connection from the DBcon table

8.PNG

Picture 1.3.4

Now you can test the connection :

9.PNG

          Picture 1.3.5

10.PNG

    Picture 1.3.6

    And check the result

11.PNG

     Picture 1.3.7

Test the connection with – ADBC_TEST_Connection

    Go to transaction code SA38 – enter the ADBC_TEST_Connection and execute

                           Select the name of the connection from the checkbox

12.PNG

Picture 2.0

Execute  an Check the result

13.PNG

Picture 2.1

Sap sources:

Note 1597627 – SAP HANA connection

Note 1559994 – Profitability analysis with Accelerated CO-PA

Note 1632506 – SAP ERP RDS for profitability analysis with SAP HANA

Thanks

Naor Shalom

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply