Extraction Method from SAP ECC to SAP Analytics Cloud.

[former_member604438]

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.?

[mfoeken]

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

[TammyPowlas]

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

[former_member604438]

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..?

[TammyPowlas]

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?