Implementation

In implementing our products, we follow a process that has proven successful in many projects.

Conception

• Development of a data model
• Loading processes (effective and high-performance data loading)
• Reporting

 Definition of ETL (Extraction-Transformation-Loading) processes within the BW

• Extraction and transfer of source data from different source systems (SAP and non-SAP) (e.g. flat files or MS SQL database)
• Saving of data in the structures and formats required for data analysis
  • Data enhancement
    • §  Derivation of information
      •  e.g. derivation of the corporate account number
    • §  Calculation of new key figures
      • e.g. determination of the number of orders
  • Data harmonization
    • §  e.g. standardization of customer master data
  • Merging of transaction data
    • §  e.g. financial and sales data from different source systems
  • Assurance of data quality
    • §  e.g. semantic data check during the loading process

Periodic data extraction

Process chain design

• Control of loading processes by means of process chains

Use of Business Content (if possible)

• Objects predefined by SAP that may be activated as needed
• Benefits:
  • Requires only minimal configuration
  • Can be extended
  • Objects available in the SAP standard need not be remodeled

Definition of a reporting system

• Creation of SAP BW queries and SAP BO reports
• Integration into the SAP Enterprise Portal

 Translation

• BW objects
• BW/BO reports
• Portal objects