BW--Create Data Warehousing: Step by Step(摘自SAP Library)

Data Warehousing: Step by Step

Purpose

To build a data warehouse, you have to execute certain process steps.

Process Flow

1. Data modeling

○ Creating InfoObjects: Characteristics

○ Creating InfoObjects: Key Figures

○ Creating DataStore objects

○ And/or creating InfoCubes

○ And/or creating InfoSets

○ And/or creating MultiProviders

○ Or creating VirtualProviders

2. Metadata and Document Management

○ Installing BI Content

○ Creating documents

3. Setting up the source system:

○ Creating SAP source systems

○ And/or creating external systems

○ And/or creating file systems

4. Defining extraction:

○ For SAP source systems: Maintaining DataSources

○ Or for a SOAP-based transfer of data: Creating XML DataSources

○ Or for transferring data with UD Connect: Creating a DataSource for UD Connect

○ Or for transferring data with DB Connect: Creating a DataSource for DB Connect

○ Or for files: Creating DataSources for File Source Systems

○ Or for transferring data from non-SAP systems

○ Creating InfoPackages

5. Defining transformations:

○ Creating transformations

6. Defining data distribution:

○ Using the data mart interface

○ Creating open hub destinations

7. Defining the data flow:

○ Creating data transfer processes

○ Creating process chains

8. Scheduling and monitoring:

○ Checking process chain runs

○ Monitor for extraction processes and data transfer processes

9. Performance optimization:

○ Creating the first aggregate for an InfoCube

○ Or using the BIA index maintenance wizard

10. Information lifecycle management:

○ Creating data archiving processes

11. User management:

○ Setting up standard authorizations

○ Defining analysis authorizations