Data Warehousing: Step by Step

Use

To build a data warehouse, you have to complete a number of process steps.

Prerequisites

When you configured your BW system, you set up the source systems.

More information:

• Creating SAP Source Systems

• And/or Creating External Systems

• And/or Creating File Systems

Process

1. Data Modeling:

   • Installing BI Content

   • Editing DataSources from SAP Source Systems in BW

   • Creating DataSources for File Source Systems

   • Creating a DataSource for UD Connect

   • Creating DataSources for DB Connect

   • Creating DataSources for Web Services

   • Creating InfoObjects: Characteristics

   • Creating InfoObjects: Key Figures

   • Creating Data Flows or Data Flow Templates

   • Creating DataStore Objects

   • And/or Creating InfoCubes

   • And/or Creating HybridProviders

   • And/or Creating InfoSets

   • And/or Creating MultiProviders

   • Or creating VirtualProviders

   • Creating Transformations

   • Optional: Creating Documents

2. Defining the data flow:

   • Creating InfoPackages

   • Creating Data Transfer Processes

   • Using the Data Mart Interface

   • Creating Open Hub Destinations

   • Creating Process Chains

3. Scheduling and monitoring:

   • Process Chain Log Display

   • Monitor for Extraction Processes and Data Transfer Processes

4. Performance Optimization:

   • Creating and Managing BWA Indexes in the BW System (recommended) or

   • Creating the First Aggregate for an InfoCube

5. Information lifecycle management:

   • Optional: Creating Data Archiving Processes

6. User management:

   • Setting Up Standard Authorizations

   • Defining Analysis Authorizations