How to analyze Code Coverage Results with SAP Design Studio on top of HANA
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.
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
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
Add the table into Data Foundation and add all the fields to Output Columns
Click the Logical Join and Create Calculated Columns which are required in our case.
Let’s see the definition of each of these calculated columns
MISS and PERCENTAGE are not required, just ignore them.
Go to Semantics node and assign the Attributes and Measures
Save and Activate the Analytic View and check the Data Preview
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.
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 %
Consuming in Design Studio :
Create an ODBC connection to the HANA system through odbcad32.exe
Launch Design studio, Add a Data source by connecting to this HANA system and open the view
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
Edit the Initial View of inserted Data Source as shown below
Similarly insert the Calculation Views also and set the Initial View as
Now in the Application->Properties->On Startup, write the following Script
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
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
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
Here on clicking each tiles (DASHBOARD in this case), the respective coverage of Java Script(.js) files shown in each of the charts
On clicking HELP tile, there are no files with the coverage in the range of 0 – 25 % and 50 – 75 %
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,