SAP-HANA
SAP HANA Calculation View Tutorial
What is Calculation View? SAP HANA Calculation view is a powerful information view. SAP HANA...
SAP HANA DXC is batch driven data replication technique i.e. it can execute after a time interval.
SAP HANA DXC uses existing ETL (Extract, Transform, and Load) method of SAP Business Suite Application via a HTTPS connection.
In SAP Business suite application content Data Source Extractors have been available for data modeling and data acquisition for SAP Business Warehouse.
SAP DXC use these Data Source Extractor to deliver data directly to SAP HANA.
Step 1) Enabling XS Engine and ICM Service
Go to SAP HANA Studio -> Select System -> Configuration -> xsengine.ini.
Set instance value to 1 in Default filed.
Go to SAP HANA Studio -> Select System -> Configuration -> webdispatcher.ini
Set instance value to in default column 1.
Step 2) Setup SAP HANA Direct Extractor Connection
You need to download the DXC delivery unit from SAP into SAP HANA database. You can
import the unit in the location
"/usr/sap/HDB/SYS/global/hdb/content".
Import the delivery unit using Import Dialog in SAP HANA Content Node ? Configure XS
Application server to utilize the DXC ? Change the application container value to libxsdxc.
Modify the application container value to libxsdxc (if any value existed, then append it).
Test the DXC Connection.
We can check DXC Connection by using below path in Internet Explorer –
http://<hostname>:80<instance Number>/sap/hana/dxc/dxc.xscfunc
- Enter a user name and password to connect.
So create a http connection in SAP BW Using T-code SM59. Input Parameters will be
-- RFC Connection equal Name of RFC Connection
-- Target Host equal HANA Host Name
-- Service Number equal 80 <Instance Number >
Log on Security Tab Maintain the DXC user created in HANA studio which has basic Authentication method.
We Need to Setup the Following Parameters in BW Using Program SAP_RSADMIN_MAINTAIN
(T-code SE38 or SA38)
Parameters List in Program – Parameter list contains value , which pass value to call screen.
PSA_TO_HDB: This three object values are shown as below -
PSA_TO_HDB_DATASOURCETABLE: In this we need to give the Table Name, which having the List of data sources which are used for DXC.
PSA_TO_HDB_DESTINATION: In this we need to Move the Incoming data (in this we need to Give the value which we create in SM59) ( here XC_HANA_CONNECTION_HANAS)
PSA_TO_HDB_SCHEMA: It specifies which schema the replicated data need to assign
Data Source Replication
Install data source in ECC using RSA5. we have taken data source 0FI_AA_20
( FI-AA: Transactions and Depreciation). First we need to Replicate the Meta data Using Specified application Component (data source version Need to 7.0 version. If we have 3.5 version data source, we need to migrate that first. Active the data Source in SAP BW. )
Once data source loaded and activated in SAP BW, it will create the following table in the Defined schema.
Now data is successfully loaded into Table /BIC/A0FI_AA_2000 once it is activated. And we can preview data from table /BIC/A0FI_AA_2000 in SAP HANA Studio.
What is Calculation View? SAP HANA Calculation view is a powerful information view. SAP HANA...
$20.20 $9.99 for today 4.6 (120 ratings) Key Highlights of SAP HANA Tutorial PDF 253+ pages eBook...
What is SAP HANA Join? Join in SAP HANA is used to Join table and information view and select...
We have till now loaded data from SAP Source, Non-SAP, and Flat file through SAP SLT, SAP BODS and...
What is SLT (SAP Landscape Transformation Replication)? SLT is the an ETL tool that allows you to...
What is SAP HANA Information composer? SAP HANA Information composer is a web application that...