HP Quality Center Tutorial (Day 7) – Project Analysis Using the Powerful Dashboard Tools


Here we are at the end of the QC series. If you are here for the first time, I highly recommend you to go through all the Quality center tutorials published as of now. I’m sure after reading these tutorials you should be able to start using this tool on your live projects. You can also recommend it to management team for evaluation if you are thinking to introduce a test management tool on your project.

This last topic will help you use the inbuilt analysis feature of Quality Center in a way that reduces a lot of work on the tester or test manager’s end to explicitly record, collect and understand the data related to the entire QA process.

Quality Center Dashboard:

The analysis feature in HP ALM/QC is so robust and extensive that I believe this is what makes many companies or projects to go for it. Nobody wants to go deeper into their projects without knowing how far you have come and how much longer you need to keep going or if you need to keep going at all. ALM provides excellent insights into this.

There are many graphs that are readily available and if that does not work for you, you can always define what you would like to view.

Apart from the graphs, ALM can generate Excel reports and Project reports for you.

QC Dashboard has the following 2 components:

1) Analysis View
2) Dashboard View

Let’s discuss these components in detail:

1) Analysis View module:

Contains the analysis tree in which you organize all your analysis items.

There are two tabs to this view.

  • Analysis View
  • Analysis Menu

Tab #1) Analysis View:

You can use the “Graph Wizard” that will guide you to add the graph or you can add a custom graph.

a) Using the “Graph Wizard”:

Choose the following option

Quality Center Analysis View

Choose the graph type:

Quality Center Analysis View

Choose Entity:

Quality Center Analysis View

Choose Project:

Quality Center Analysis View

Choose filter:

Quality Center Analysis View

Select graph attributes and click “Finish”

Quality Center Analysis View

The graph gets generated and you will have an option to add it to the analysis tree.

Quality Center Analysis View

b) Custom Graph:

Here you can create graphs and reports that are custom to your project. To do so, you can create a folder. Under the folder you have an option to create the following:

Quality Center Analysis View

Choose the relevant option. I am going to go with “New Graph”. The following dialog opens up:

Quality Center Analysis View

Under Entity, you have the following option and depending on the entity you choose, the graph type field is populated.

Quality Center Analysis View

For example, for defects, these are the options:

Quality Center Analysis View

I am going to leave the default values as is and choose the graph name as “Test” and click ok.

As you can see, “test” graph is added under the folder. I can now configure the values as I wish and view the graph.

Quality Center Analysis View

Tab #2) Analysis Menu:

This second tab to the analysis view has a lot of inbuilt reports based on each side bar menu item. Choose the report you would like to view. I chose “Tests with Linked Defects”. In the right hand side you can see its details:

Quality Center Analysis View

Once you click on the “Configuration” tab, you can set the proper parameters for the report or graph you would like. Set the parameters and click on “Generate”.

Quality Center Analysis View

------------

The view tab will have a link to the previously generated reports:

The report:

Quality Center Analysis View

2) Dashboard View Module:

This is more like the port folio page of your Demat account.  This is where all the graphs and reports that you have created using the analysis view are displayed for you in a single view.

Click on this icon, Quality Center Dashboard View to create a new dashboard page.

Provide a name for the page and click OK.

Quality Center Dashboard View

Once the page is created, you can add what graphs that you would like to be a part of this page. The graphs will be from the analysis view.

You can choose the graphs you would like. I am going to choose just one, “test” for the sake of this tutorial. It gets added to my “Configuration tab” and I can view it from view.

Quality Center Dashboard View

View tab:

Quality Center Dashboard View

Now let’s add both the graphs to our dashboard page and see how it looks.

Configuration tab:

Quality Center Dashboard View

View tab:

Quality Center Dashboard View

So, there you have it, all in one place!

Miscellaneous Topics:

I am now going to introduce to you the other options that are available in the sidebar of ALM. They are not widely used (at least not so far) but I believe they come with a huge potential. So, I encourage you to try and use them in your projects (if applicable) and see if they would help. The topics are:

1) Libraries and Baselines: Libraries are nothing but a set of entities in your projects and the relationships between them. For example: A library can be all the requirements that are specific to UI changes that are being made to your AUT

ALM lets you share libraries among projects so you can identify dependencies.

To create a library – Click on the “Libraries” option from the side bar and on any folder (or create a folder), right click and choose “New Library”. The following window opens up and as you can see, a library can consist of Requirements, Resources, Components and Tests. You can choose them in the below window.

Quality Center Liabrary

Once you create a library you can create a baseline with it. A baseline is a snap shot of your library at any given time. To create a base line you can right click on any library and select “Create Baseline” option.

So when you compare different baselines you will know what the progress of your library has been like at a certain time.

2) Test Resources:

  • If in your project you have a consolidated sheet (MS Excel) of user IDs and password that you use for your testing. Instead of having a local copy on each machine you want to maintain it in ALM. You can do so by uploading it to QC as a Test Resource
  • A Test resource can be used by one or more tests.
  • You can also define what tests depend on what resources.
  • To sum up – You can upload and download resources, link resources and view dependencies through ALM.

Points to note:

  1. ALM can be used for Agile, Iterative or Sequential models of projects.
  2. Version control is an inbuilt feature.

In Conclusion:

This finishes our QC tutorial and I sincerely wish that you got to get a feel of what this tool is all about and what it can do for you through this series.

If you feel we missed any Quality Center topic, let us know and we will try to include it in coming days.

Please leave your comments and questions.


The Best Software Testing Training You'll Ever Get!

software testing QA training

43 comments ↓

#1 Lakshmi on 06.26.13 at 4:33 pm

Hi Swathi, Thats a great explanation.
Could you please explain us about Test Resources and Libraries also the same way

#2 Swati on 06.27.13 at 12:34 am

@Lakshmi: Test resources and libraries are very specific to individual projects and not a part of the main stream QA process. So it is beyond the scope of this series to go into them in detail. So, may be, later.

#3 Revathy on 06.27.13 at 1:32 am

Excellent explanation…I have few questions.
1) Can we run automated test cases using QC? how?
2) how can I list out all the defects found by me and /or assigned to me using QC?
3)Suppose i have found a bug. I need to inform this to my manager. how can i do this? Where can i prepare the Defect Report? in QC or in other word files?

Can you clarify these. Thank you

#4 Sorabh on 06.27.13 at 8:58 am

thanks!

#5 swapna on 06.27.13 at 12:51 pm

i really like the way he explains i am going through all his classess they are excellent.thanks for your help

#6 Swati on 06.27.13 at 8:33 pm

@Revathy: There are the answers:
1. You can integrate automation tools like QTP with QC. You will need an addin for the same.
2. You can list all the defects logged or assigned to you by simply choosing to filter the defect list based on the Created by or Assigned to fields.
3. You can email a chart or report, or an individual defect directly from QC to whoever you would like.

#7 Renuka on 06.28.13 at 5:31 am

Thanks for the helpful information. I have read that we have to write queries and VB script to create reports in ALM. Can you provide some information on that?

#8 Mahesh on 06.28.13 at 7:18 am

Excellent effort and all the tutorials helped me in understanding ALM. Thank you so much :)

#9 palanivel on 06.28.13 at 7:26 am

Hi to all ..
Any body has the manual the tasting notes please send to my mail id and you know any testing opening please inform to me my mail id palani1388@gmail.com .

#10 Swati on 06.30.13 at 1:37 am

@Renuka: For reporting there are times when SQL queries and VB script are used for analysis(even for data creation in ALM). It is done using Excel Query builder and tools similar to that. For this you will need to have admin access on your QC DB which is normally not available to testers. So the answer to your question in a nut shell is, regular users don’t need to have an understanding of this.

#11 Priya on 06.30.13 at 3:38 pm

Gone thro the entire ALM tutorials.. way of explanation is very simple and gud even for a beginner who has never used QC..! kudos n thanks

#12 Priyabrata on 07.01.13 at 1:35 am

Hi
This is a great tutorial and I have achieved a lot after going through all the 7 tutorials. I was just wondering that;
– How do we export our Test Cases to Excel file?
– How can we import our existing Requirements or Test cases from excel file to QC ?

Thanks & Regards
Priyabrata

#13 Swati on 07.01.13 at 4:32 pm

@Priyabrata: if you want the test cases in your test lab to be exported to Excel there is a direct menu option available. I believe it is “Test Sets->Export”.
If you want to upload the test cases from Excel into QC, you will need an addin. Once you install that you will have to create a map between the column in the excel sheets to the columns in ALM.

I hope this answers your question.

#14 ramya on 07.07.13 at 10:52 am

What is the use of document generator and Analysis…when both are same functionality..Is ther eany postive or negative side to analysis or document generator that makes each other unique?

#15 Pravin on 07.08.13 at 1:59 pm

Hi,
This is a great tutorials and I have learn more through all the 7 tutorials
How to export excel worksheet to HP QC

#16 Swati Seela on 07.08.13 at 7:51 pm

@Pravin: You can export content in excel sheets to QC. You will need an addin for the same. Once you install the add, you can map the columns in Excel to the columns in QC and export. Hopefully we will do an article on how to do this soon.

#17 Swati Seela on 07.08.13 at 7:57 pm

@Ramya: document generator and the analysis tools are two different aspects. Document generator will have a word document with the details you wish to include and might include graphs. Analysis module is where you create the actual graphs and customize them as needed. I hope I answered your question.

#18 Pravina on 07.18.13 at 4:55 am

Hi,
I’ve lately come across the tutorials on QC, and I went through the first two tutorials only.
I’ve not installed QC yet. Is it possible to install on Windows xp(32 bit)? Please clarify.

Thanks in advance.

#19 Vanitha on 08.09.13 at 6:35 am

Can you please add another tutorial about exporting and importing excel sheets to/from QC and also about integrating automation tool with HP ALM.

#20 Parvin on 08.13.13 at 9:16 am

all the articles explained by you are very useful to understand QC . Thanks a lot for this wonderful explanation . I was hoping for a series for the articles of Load Runner tool for performance testing . Hope you will provide that also . looking forward for your continuous support……..

#21 Chandra on 09.10.13 at 7:36 am

Hi Swathi,

I am planning to do QC Admin training. Could you please let me know the job market in this area?

Thanks,
Chandra

#22 Anjali on 09.13.13 at 7:29 am

Really a helpful tutorials… thanks Vijay

#23 Sudha on 09.13.13 at 4:02 pm

Hello Swathi

Thank you so much for explaining it step by step. It was easy for me to understand it easily. I was wondering about Requirement Traceability Matrix. I am curious to know about it in detail. Thanks in advance Swathi..

#24 vivian on 09.16.13 at 3:32 am

how to add user to QC? for example, testers who will run the cases, or developer need to know the defects. the user type maybe different.

#25 mahesh on 10.03.13 at 7:19 pm

hi,
best website for learn the QC 11.5 with installation.

thanks to s/w testing help
mahesh

#26 Mitesh on 12.01.13 at 10:17 am

Hi Vijay, I am very thankful to you for Posting articles on QTP and ALM/QC. Can you also post articles related to QC\ALM administrator.. since this field is also emerging, It will be helpful as to how we configure various artifacts related to project in QC\ALM.

#27 parul on 12.02.13 at 12:57 pm

Thank you so much,
Really nice series of tutorial. It is very helpful for beginners.
expecting some really nice and useful tool tutorial series in future also.

#28 Vamsi on 12.06.13 at 9:19 am

Wonderful explanation… thanks a lot.

#29 Satish Namburi on 12.13.13 at 7:20 am

Hi,

Thanks for your valuable tutorial, i was very impressed after seeing this 7days tutorial’s.

I like the way of explanation among all the features in HP ALM. By Seeing this complete tutorial am able to work with ALM in all phases. It helped me lot.

Thanks,
Satish Namburi

#30 Brahmendra on 12.30.13 at 8:41 pm

Thanks a lot.

#31 Syed on 01.02.14 at 4:07 am

Hi All .. thanks alot for the very useful tutorials..I just started my new job in software testing and these information is really iuseful 4 me as a beginner in testing field..

Syed Faizal
KL , Malaysia

#32 Sanjay on 01.17.14 at 12:49 am

Hi,

Thanks for this tutorials, it is very useful. I need some guidance on requirement & test case mapping. Following is my scenario:
1. Created two requirements – R1 & R2
2. Created a generic Test Case in Test Plan as T1
3. Mapped this test case to both requirements R1 & R2
4. In Test Lab, created two Test Sets for each requirement TS1 & TS2
5. Selected test case T1 to both test sets TS1 & TS2
6. Executed both test sets
7. TS1 is Passed & TS2 is Failed
8. When checked requirements R1 & R2, both shows Failed status, even if TS1 for R1 is Passed while TS2 for R2 is failed

How can I show correct status in Requirements Direct Cover Status

#33 kumar on 01.25.14 at 7:24 pm

Few Questions for QC experts……..If you Know you can answer it.
1) How to bring all defects of same project from different versions in to one excel sheet?
2) If We execute same Test case twice nor thrice in Test Lab how to import those execution times of that particular Test case in to excel sheet?
Waiting for answers guys…………

#34 saurabh on 02.10.14 at 2:44 pm

Hi,
this is really helpful thanks.

#35 Barrakuda on 02.19.14 at 2:29 pm

Hi,

I need to report defects which are not linked to any test cases. Can i create a graph to see this? or is there any other way to find them out.. Please help…

#36 babu on 03.10.14 at 6:53 am

Hi,
This is very good work.

#37 Anand on 03.18.14 at 10:44 am

Hi,

This is good effort from the group to share the knowledge on QC and to also implement in the Projects

#38 Gracey on 03.24.14 at 7:27 am

Hi Swati, with regard to Priyabrata’s question #13, is HP ALM/QC able to export Test Cases to Excel?

This has been a feature that I had been waiting for HP QC. Once test cases have been exported from Excel to HP QC, and you update Test Cases in HP QC, there is no way that all Test Case details are exported from QC to Excel. Is this all possible now?

Thank you,

Regards,
Gracey

#39 Devi on 03.30.14 at 10:16 am

Hi Swati,

Thanks much for the well presented tip-of-the-iceberg about QC. Would it be possible to add some Information about SELENIUM too? THanks

#40 Ashish on 05.12.14 at 12:59 pm

Hi all,
if we wan to import the content from excel sheet to QC where we can see the plugin to install and how much time does plugin usually take to install.

#41 Yusuf on 06.04.14 at 9:34 am

Hi,

Can anyone help me, i am using ALM 11.53

I am trying to create a view for how many defects are detected and closed trand for each day…is this possible?

I can do it in Excel but not in ALM11

#42 Venkatesh on 06.18.14 at 8:16 pm

Hi,

This is very helpful tutorial for the beginners.

Thanks.

#43 Grace on 06.25.14 at 8:43 am

Hi

I’ve tried to upload my test scripts (with 5 test steps) in HPQC using the Excel Add-In. However, only the 3rd step was uploaded. What could I have done incorrectly?

Leave a Comment