I would like share a data mart scenario on HANA presented by SAP Lumira 1.16.

In this sample Direct Extractor Connector (DXC) method is used for Data Provisioning.

Sales Data will be retrieved from SAP ERP by embedded BW method. I want to skip the steps for setting up DXC on ERP and HANA side. After successfull setting up DXC we have ready to use 2 extractors ready to use data provision. Required tables will be appear under R3TSCHEMA tables.

ERP_to_HANA_Lumira_01.jpg

DXC method will automatically insert required tables after successfully replication of metadata in BW system.

ERP_to_HANA_Lumira_02.jpg

Tables /BIC/A2LIS_11_VAHDR00 and /BIC/A2LIS_11_VAITM00 will be used because they will contain the data.

In order to present data we need to create an analytic view by using those 2 tables. On the following image you can see the created analytic view which is called LUM_DXC

ERP_to_HANA_Lumira_03.jpg

Now data is ready for presentation, any available tool can be used. In this scenario Lumira client version will be used.

ERP_to_HANA_Lumira_04.jpg

Now we need to connect HANA in order to acquire data. Just press the Acquire Data icon and select Connect to SAP HANA One which is showed following image.

ERP_to_HANA_Lumira_05.jpg

Also you can select from recently used part if you did it before. All server connection information should be entered to the following screen fields.

ERP_to_HANA_Lumira_06.jpg

After entering the correct information just press connect and get the available views.

ERP_to_HANA_Lumira_07.jpg

After sucessful connection all available views will be listed. Now we’ll select our predefined view called LUM_DXC.

ERP_to_HANA_Lumira_08.jpg

Once you have select the source of the data, remainning section is very much similar to any graphic tool, so I am skipping those steps. In my sample I like to see my data as follows:

ERP_to_HANA_Lumira_09.jpg

Sorry for some labels are in local language 🙂

If you have any questions, please raise.

Cheers,

Sarhan.

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