In a world where Computer applications go hand in hand with the user to make a life easier, it’s very important to identify how effectively they have been designed and developed. There are various methods to validate the software out of which one of the most important methodologies is “Code Coverage”.


The Code coverage is a measure which says how much code is effectively covered when the user uses the application. It’s important that this measure should be analyzed effectively, to improve the quality of a software application.


Let’s assume that there is an application for which the no of statements and hits are identified and I want to analyze the code coverage results on a weekly basis using SAP Design Studio with the help of HANA as a backend.


The application has sub features and each feature is developed using set of Java Script(.js) files.

Let’s name the sub features as Login, Help, Dashboard, etc


Now I know the Feature name, the name of the files(.js) under each feature, No of Statements in each file and No of Hits(how much lines covered).


Uploading the Data into HANA:

This data can be loaded into HANA using the Flat file upload option which is very familiar and easy to use approach.

Image_1.jpg

Once the Data is loaded into HANA Table, do a data preview by navigating through the Schema where the table is uploaded. It will look like as below

/wp-content/uploads/2014/02/image_2_390386.jpg


Modeling in HANA:

We can make use of this table directly for analysis, but it’s not recommended and hence let’s make use of HANA Views to model this data

I created an Analytic View as shown below

/wp-content/uploads/2014/02/image_3_390387.jpg

Add the table into Data Foundation and add all the fields to Output Columns

/wp-content/uploads/2014/02/image_4_390388.jpg

Click the Logical Join and Create Calculated Columns which are required in our case.

Image_5.jpg

Let’s see the definition of each of these calculated columns

Image_6.jpg

MISS and PERCENTAGE are not required, just ignore them.

Go to Semantics node and assign the Attributes and Measures

Image_7.jpg

Save and Activate the Analytic View and check the Data Preview

Image_8.jpg


Now the View is ready and can be consumed in Design Studio. But before that for the ease of analysis, I would like to see the coverage as different value buckets.

Eg :      

            Below < 25 %

Between 25 to 50 %

Between 50 to 75 %

            Above 75 %


For this purpose, I created four Calculation views using Projection, covering each bucket and applied the filter in it. Below one shows the filtering of < 25 %

Image_9.jpg


Consuming in Design Studio :

Create an ODBC connection to the HANA system through odbcad32.exe

Image_10.jpg


Launch Design studio, Add a Data source by connecting to this HANA system and open the view

Image_11.jpg

Click the Application and go to its Properties pane, add a Global Script variable. The reason for adding this variable is, we can pass this variable as URL parameter and filter the data based on calendar week while launching the application

Image_12.jpg

Edit the Initial View of inserted Data Source as shown below

Image_13.jpg


Similarly insert the Calculation Views also and set the Initial View as

Image_14.jpg


Now in the Application->Properties->On Startup, write the following Script

Image_15.jpg


Place the components in the canvas as shown below

The Title, Calendar Week filter drop down, Separate tiles for each feature to show the respective Code coverage, Four charts to show the four categories (buckets) of coverage

Place the background image for better look and feel

Image_16.jpg


Assign each Calculation views to each of these charts

Now the four charts have to show the coverage of the underlying files in four buckets for a particular feature when the user click on it


For Eg, If the user clicks on the coverage value of second tile (DASHBOARD), the files having coverage in different range should be shown in the charts accordingly


To achieve this, we can write following script for the OnClick event of Text placed in the tile which shows the value

Image_17.jpg

Image_18.jpg

The same code can be copy pasted and changed accordingly for other Text placed in the tiles

Now Save the Dashboard and Execute


As mentioned earlier, here the Global Script variable value can be passed as URL parameter

http://<server>:50130/aad/web.do?APPLICATION=<DashboardName>&Xcw=CW_06


Here on clicking each tiles (DASHBOARD in this case), the respective coverage of Java Script(.js) files shown in each of the charts

Image_19.jpg


On clicking HELP tile, there are no files with the coverage in the range of 0 – 25 % and 50 – 75 %

Image_20.jpg


So if the user wants to find the list files covered < 50 % in each feature then he can focus more on Charts 1 and 2 which can show the files having coverage 0 – 25 % and 25 – 50 % and optimize the code.


Thanks for spending time in reading my article and Hope you find this helpful 🙂


Thanks & regards,

Murali

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply