Using the Persistent Staging Area (PSA)

PSA stores data in its original source system format. In this way, it gives us a chance to examine the data before we send them into their destination – either characteristics, ODS objects, or InfoCubes.

Work Instructions

Step 1. Reload the data from Table 3.3. This time, in the InfoPackage created in Section 3.9, under the Processing tab, select the option Only PSA, instead of the default PSA and then into data targets (packet by packet).

 

 

SCREEN 4.12

graphics/04fig12.gif

Step 2. Start the data loading process as shown in Screen 3.71. After the Data was requested message appears at the bottom of the screen, click graphics/dataload.gif as shown in Screen 3.22. A green light appears next to the data load request, which indicates that the job was successful.

Next, click graphics/psadata.gif to display the PSA data.

 

 

SCREEN 4.13

graphics/04fig13.gif

Step 3. Click graphics/continue.gif to see records 1 to 1000. BW sets this range by default.

 

 

SCREEN 4.14

graphics/04fig14.gif

Step 4. Review the 24 records stored in PSA. To modify one of them, you select the record and then click graphics/salesrevenue.gif . Notice the zeros in the Sales revenue column; their presence indicates that the transfer rules have not yet been applied to the PSA data.

 

 

SCREEN 4.15

graphics/04fig15.gif

Step 5. After checking the data in PSA, now we can send the data to IC_DEMOBC.

In the Administrator Workbench: Modelling window, notice the load request InfoPackage demo: IC_DEMOBC (25.10.2000) in the right panel. Right-click the request, and then select Start the update immediately.

 

 

SCREEN 4.16

graphics/04fig16.gif

Step 6. In the Administrator Workbench: Modelling window, right-click InfoCube demo: Basic Cube, and then select Manage (Screens 4.1 and 4.2).

Under the Requests tab, notice the status of the data loads. The first row shows the status of the data load in Step 5. Click graphics/bwmonitor.gif in the first row, which returns you to BW Monitor. You will see that the load from PSA into IC_DEMOBC was successful.

 

 

SCREEN 4.17

graphics/04fig17.gif

Result

You have loaded data into IC_DEMOBC via PSA. Using PSA, you verified that the data were loaded correctly into BW.

Part I. Guided Tours

Business Scenario and SAP BW

Creating an InfoCube

Loading Data into the InfoCube

Checking Data Quality

Creating Queries and Workbooks

Managing User Authorization

Part II. Advanced Topics

InfoCube Design

Aggregates and Multi-Cubes

Operational Data Store (ODS)

Business Content

Generic R/3 Data Extraction

Data Maintenance

Performance Tuning

Object Transport

Appendix A. BW Implementation Methodology

Object Transport

Appendix B. SAP Basis Overview

Object Transport

Appendix C. Glossary

Appendix D. Bibliography



SAP Bw. A Step-By-Step Guide
Sap Bw: a Step By Step Guide for Bw 2.0
ISBN: B000LZM8CM
EAN: N/A
Year: 2002
Pages: 106

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net