Skip to Content
Author's profile photo Sourabh Deo

SAP BW Testing Episode 2 – System testing

1         Introduction

1.1        System testing

System testing of software or hardware is testing conducted on a complete, integrated system to evaluate the system’s compliance with its specified requirements. System testing falls within the scope of black box testing, and as such, should require no knowledge of the inner design of the code or logic.(refrence: wikipedia)

1.1.1       Relation with SAP BW

SAP BW is a business Intelligence product centered on a data warehouse. SAP BW includes preconfigured data extractors, Analysis and Reporting tools .i.e. Analyzer,
Query Designer, Report Designer. Through BW testing we are validating Objects, Rules, Connectivity, flow of data within BW and various connected Systems \ Applications. SAP BW system needs to be tested in-&-out for better and smoother performance. Handshaking/Connectivity mechanism with the external system should
be tested. Transfer & Quality of data should be tested while moving in-&-out of BW. These activities are covered in system testing for SAP BW.

Below objects were considered for testing in SAP BW in system testing:

  1. Info Cube
  2. DSO InfoObject
  3. Multi-Provider
  4. Info-Set
  5. Data Sources
  6. Transformation
  7. InfoPackage
  8. DTP
  9. Process chains
  10. BEx Queries & BEx Components
  11. Data loading process
  12. Output data
  13. Input data
  14. Query Output

If we consider the case study mentioned in previous blog (SAP BW Testing Episode 1 – Introduction) the system testing consisted of few phases as follows:

  1. Smoke testing
  2. ECC-BW Layer testing
  3. LSA Layer objects testing & BW Reporting Layer objects
  4. Reconciliations between LSA layers
  5. Reconciliations between BFC and BW Reporting Layer
  6. BEx queries and BEx components such as filters, RKFs (local, global), CKFs (local,
    global), etc.
  7. Reconciliations between BW Reporting Layer and BEx queries along with calculations.
  8. Reconciliations between BEx Query Output and BO report Output


  •   LSA Layer objects testing











                    Data Source:




                        Data Loading Process:


                        Process Chain:






                         BEx Related testing – (Blog by Aditya Bakshi –  SAP BW Testing – BEx Testing )


To be continued … (System Integration Testing)

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Sourabh,

      Nice One 🙂