Testing in BW

How can you perform testing in BW?
Testing is done two ways: Backend and frontend
Backend is done using data flow or data model. Frontend is done on reports.

How can you test if you have a start routine on the cube or ODS?
Start routines involve transfer routine and update routines. They are used to modify the source system data or adding additional data to bw for reporting. To test routines we run infopackage and go to the monitor & view the records in PSA. PSA always has the raw data which is identical to that of a source system.

How can you test the selections in the infopackage?
We run infopackage which brings the data from source system to bw. Then in the monitor screen under header tab we can look at the selections.

What Transaction used to validate extraction on source system (R3)?
RSA3

What transaction used to verify the datasource is active or not?
For business content: rsa6
For custom content: rs02

What transaction used to verify the batch job?
sm37

Where can you see the log for that batch job?
Goto sm37, enter the job name, click ok. In the next screen we can see the logs, click on it to show.

Difference between ODS and CUBE?
ODS: its is an flat structure, always updatable.
Cube is an multi- dimensional view which has a history data, and data can always be added to it. It is based on extended star schema.

Can you define Remote cube?
Some times data resides in other servers. The cubes residing in other servers are called remote cubes. The cubes are only used for reporting purposes.

Difference between Update rules and Transfer rules?
Trransfer rules is matching b/w ss and bw
Update rules is matching b/w communication struct and cube

How can look at the customer profile on R3?
Xd03


Difference between Regression test and Integration testing?
Integration testing: Integrating the functionality of different applications is integration testing Regression testing: it done to test whether any changes have taken place or not due to changes in other system.

What defect management system used to log the defect?
Tool: clear quest, Test director,

What are the documents refer to write the test scripts and conditions?
Business req, fs, design spec., ts

Three major components in test plan and strategy?
1 objective

2 scope
3 assumptions
4 dependencies
5 constraints
6 risk litigation
7 entrance and exit criterion


How can you test the BI report?
By giving the input variables and run the reports. We then compare the data with cube data upon which the reports are created. The cube data can be validated by going to the screen using the t-code listschema, and giving the same same selection as in reports and compare the data.

Difference between workbook and Query?
Work book is collection of queries.

How Can you schedule the BI Reports thru batch?
It can be done in two ways: Report agent, Information Broadcasting.

What are the three major process type used in process chains?
Start, joining the cond, infopackage, program, index deletion and recreation.

What is PSA?
Persistant staging area


Test script:

It is a document In which we describe how to run the test case.
Serial no functionality actual result expected result pass/fail description.
Test case: it is an doc that we provide input to test a particular functionality of the application

Test plan:

A document which contains the objective and scope and approach and focus of a test report.