6.2 Accessing Data from SAP Systems

Question 1

SAP BusinessObjects universe can connect to :

Answer 1

SAP and non-SAP datasources

Question 2

Integration of SAP universe can be done in 2 ways:

Answer 2

• as a live connection, no data stored in the cloud

- as an import data connection, data will be stored on the cloud and updated periodically

Question 3

Components of a SAP universe live connection to SAC (5)

Answer 3

SAP Universe
> SAP BOBJ BI platform live data connect
> Reverse proxy
> Browser
>SAC

Question 4

Components/flow of a live SAP universe data import to SAC (4)

Answer 4

SAP Universe
> SAP Analytics Cloud Agent
> SAP BTP Connectivity Cloud Connector
>SAC

Question 5

Requirements for Live data connection (Universe to SAC) (2)

Answer 5

• SAP BOBJ Live Data Connect

- Specific URL running to see universe live connection

Question 6

Requirements for data import (Universe to SAC) (2)

Answer 6

• SAP BTP Connectivity Cloud Connector

- SAP Analytics Cloud Agent

Question 7

How to create a universe connection

Answer 7

1. create connection

2. create a model on the universe import connection (universe query)

Question 8

What are the 2 connection types to integrate SAC with S/4HANA

Answer 8

• live connection

- import connection

Question 9

3 ways to create a live connection to S/4HANA

Answer 9

• Direct
• Tunnel
• Cloud

Question 10

with S/4HANA, what can you build stories on?

Answer 10

• CDS views

- queries

Question 11

S/4HANA Live data flow to SAC

Answer 11

• S/4HANA tables
• CDS view (can feed fiori app)
• SAC live connection
• SAC live model
• SAC story

Question 12

Technical prereqs to import data from S/4HANA (2)

Answer 12

• on prem edition is S/4HANA 1610 with SAP NW release 7.51 SP2
• Latest SAC edition

Question 13

When importing data from S/4HANA, Master data must be imported first. (t/f)

Answer 13

T

Question 14

Considerations when importing Master data from S/4HANA

Answer 14

• Descriptions of IDs (properties) may need to be imported separately
• If importing hierarchies, import members first and then the nodes, then the node text
• MD import is only set up once, can be run periodically after
• if data is static, some dim data can be maintained in SAC