Viewing Source Data

Objective

After completing this lesson, you will be able to view SAP Business Warehouse master and transaction data.

View Source Data

Before importing data from SAP Business Warehouse to SAP Analytics Cloud, you can view the source master data and transaction data. This data can be viewed in the SAP Business Warehouse Modeling Perspective in SAP HANA Studio.

SAP Business Warehouse Master Data

In the following example, the Reporting Preview displays members and attribute values for the product characteristic.

Master data displayed in SAP HANA Studio.

Using the search, you can view (and change) master data, such as the account members and the compound chart of accounts.

InfoObject ZAccount showing account members and the compound chart of accounts.

Using transaction RSH1, you can view the profit and loss account hierarchy in the SAP GUI.

Hierarchy Profit and Loss displayed in SAP GUI

SAP Business Warehouse Transaction Data

In the following image, the Reporting Preview displays the transaction data in the ADSO. The data includes profit center, account, and posting period.

SAP Business Warehouse Transaction Data displayed in SAP HANA Studio.

View Source Data

Business Scenario: As part of the integration project, you want to view the SAP Business Warehouse master data and transaction data in SAP HANA Studio before setting up the data import in SAP Analytics Cloud.

Task Flow: In this practice exercise, you will:

  • View master data for the Product and Account dimensions
  • View transaction data in the ADSO

Log in to track your progress & complete quizzes