Question Re: Extraction Method from SAP ECC to SAP Analytics Cloud. in Technology Q&A

Extraction Method from SAP ECC to SAP Analytics Cloud.

former_member604438 — Fri, 06 Dec 2019 05:56:51 GMT

Hello all,

I want to extract data from SAP ECC Tables like USR02(User login data) and USR03 (ADDRESS DATA) into single SAP Analytic Model .

Can any one explain the what exact procedure need to follow.?

Re: Extraction Method from SAP ECC to SAP Analytics Cloud.

TammyPowlas — Fri, 06 Dec 2019 10:05:26 GMT

Please see the SAP steps here to connect to SAP ERP from SAP Analytics Cloud: https://www.sapanalytics.cloud/guided_playlists/connect-sap-erp/

Re: Extraction Method from SAP ECC to SAP Analytics Cloud.

former_member604438 — Fri, 06 Dec 2019 13:23:24 GMT

Hi Tammy,

Thank you for your response.

Connection to ECC is fine, but the thing is how to extract data from selected fields of 3 tables which is having common field in 3 tables from SAP ECC to SAC.

My Question is like,

1. whether we need to extract separately from three different tables to SAC Models or is there any other way..?

Re: Extraction Method from SAP ECC to SAP Analytics Cloud.

TammyPowlas — Fri, 06 Dec 2019 13:29:44 GMT

One suggestion is to create a SAP Infoset/Query using the SQXX transactions and join the 2 tables

Is your end goal one model for the 2 tables?

Re: Extraction Method from SAP ECC to SAP Analytics Cloud.

mfoeken — Fri, 06 Dec 2019 20:44:29 GMT

Hi Venkata,

The is no data modeling environment in SAP Analytics Cloud where you can join 3 tables and create a single model. For this use case you need to look at SAP Datawarehouse Cloud: https://saphanacloudservices.com/data-warehouse-cloud/product/. With regards to SAC: you can create 3 separate models and link them in a story.

Kind regards,

Martijn van Foeken | Interdobs