Sorun Cevaplayalım

İşinizle ilgili öngörüler edinin, gerçek zamanlı bilgilere göre karar alın.

SAP Eğitim ve Sertifika Dönemleri

Uzmanlığınızı ve deneyiminizi SAP çözümleri kullanarak tasdik edin.

Çözüm Ekibi Başvurusu

Kullanıcılara hızlı ve pratik çözümler üreterek görev almak isteyenler.

SAP BLOG SAP BW Query: Automation test setup, step-by-step

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
988
Tepki puanı
6
Hi, community!

In the post I’d like to share my experience and thoughts about automation of testing BW(Bex) queries. During upgrade/migration projects customer wants to be sure that its BW(Bex) queries return the same result before and after upgrade ceteris paribus. It’s not always true because SAP as a vendor make modification in the standard function modules, classes and so on, used in BW(Bex) queries. Even if we know wht was changed in recently installed service pack, the question “How it influence particulary to the set of critical BW(Bex) queries?” is open. That’s why automation of testing BW(BEx)-queries can guarantee that you never miss unaffordable changes. And it saves project costs, because it will take your only a couple of minutes to perform the comparative test and find out the problem areas.

The blog consist of 2 parts: summary and detail.

In the summary part I post the only one screenshot. It shows final screen with test results: Bex-query result set before changes [in the system / in the query data / in the query logic or smth. like that] and after changes. Red color in cells means that comparion fails: query executed “after changes” (upper part) produces different result in comparison with query executed “before changes” (lower part).

025-1.png


In the detail part I post series of screenshots “step-by-step” to set up the most part of relevant settings.

Firstly, decide what query you would test. Prepare their technical names and variable values for their selection screens. Then run tcode: RSTT and activate trace for ther user

003_01.png


Now you can start recording query results to be compared after changes. During my investigatoin the best way to record query results is by using tcode RSRT with HTML-presentation. Unfortunately this type is not relevant for BW4/HANA. But other types of presentation like list, BICS are difficult to compare. Try’em by your own and I you can understand what I mean.

001-2.png


002-1.png


Then return to RSTT and stop tracing. Lets review trace results

004-1.png


005-1.png


006-1.png


In the tab “Ref.Data” you can see recorded results of query execution (in my example I recorded 2 bex queries, that’s why 2 records in log you can see on some previous slides).

007-1.png


Here the recorded result:

008-1.png


Then I made some settings for automation of testing process. I created test package with the trace record…

009.png


010-1.png


… and test job for execution test package next time, after some changes in the BW system.

011-1.png


012-1.png


013-1.png


014-1.png


You can see results of job execution by clicking on reporting icon in the grid (see above picture). Then you drill into separated BexQuery with job log (see filter on Log GUID field) which stated that everything was OK (Message Type S)

021-1.png


Next I made some changes in the BW system which lead to Bex query result changes. And execute the job immediately (again)

019-2.png


after job finished I went to job log tab and drill into BExQuery with job log again

020-1.png


Error status in Message Type!

021-2.png


So we need to make detail investigation next! Go to CATTS TRACE and execute trace record again

022-1.png


023-1.png


We see error status which means that saved results are differ from last recorded results.

024-1.png


Go to detail information and see.. the same slide as in summary part of the blog.

025-2.png


.

Okumaya devam et...
 
Üst