Data Warehousing: Step by Step

Data Warehousing: Step by Step

     To build an Optimal Data Warehouse solution in SAP BI, the following steps are the sequential process.

       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