SAP Testing for BI Lifecycle

[satish_talikota]

Hi,

Could you guide me to SAP BI Testing Strategy and Approaches.

Regards

Satish Talikota

[Former Member]

Hi

Unit Testing: In this we do all the technical tests like testing the data flow, logic in transformation, data loads, query properties etc

Integration Testing: In this we perform the function test to check that query is giving output which is functionally correct.

Regression Testing: If we are making changes to existing flow and query, it this testing one would like to test that no existing functionality has changed because of newly added changes.

Performance Testing: sometimes we write ABAP code in transformations, under this cap you may like to test the data load performance. If data load is taking a long time, you may want to optimize the code and check the performance again.

Authorization Test: in this you would like to test all the roles have been set up properly and data level access is also working fine at query level.

Please check the below,

https://scn.sap.com/docs/DOC-28811
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60981d00-ca87-2910-fdb8-d4a2640d6...

Note:Try to Search in the forum before Pasting Thread

Regards

NK

[anshu_lilhori]

Hi Naveen,

This thread is more than 2 year old so i don't think there is any point in responding to it.

By this time the thread owner might have got the answer for his queries.

Hope you understand.

Regards,

AL

[Former Member]

Hi,

The main part in SAP BI testing involvs reconciliation, that is done after data loading from source system. As loading the the prime activity happens in any BI system, it becomes necessary to check the loaded data in BI system, for this purpose we generally execute Reconciliation report in Source system and then execute query in BI and check the data.

This is one aspect of BI testing. The other parts comes into picture to validate the data which is flowing within BI system.

Or you can validate the output of particular report with the data in BI backend system, so as to do the Report validation.

Regards,

Durgesh.

[satish_talikota]

Thank you.

Can there be any automated testing for BW applications? Are there any vendors with test automation tools for BW applications?

regards

Satish Talikota