It's all about the answers!

Ask a question

BIRT Category report.


Russell Norlund (17221724) | asked May 03 '12, 2:42 p.m.
is there any way of getting a list of categories for a specific Project Area using BIRT? There is the Category table but when queried it returns all the categories from the repository.

4 answers



permanent link
VK L (8177157159) | answered May 04 '12, 7:35 a.m.
Hi Russellin,
try to pick tables containing project area and category names together and set filters to be equal to your specific project area.

is there any way of getting a list of categories for a specific Project Area using BIRT? There is the Category table but when queried it returns all the categories from the repository.

permanent link
Russell Norlund (17221724) | answered May 08 '12, 1:53 a.m.
Hi Russellin,
try to pick tables containing project area and category names together and set filters to be equal to your specific project area.

is there any way of getting a list of categories for a specific Project Area using BIRT? There is the Category table but when queried it returns all the categories from the repository.


There are some tablesthat provide this information but they require work items to have been created for the categories. We have 165 categories so initially not all categories would have a work item assigned to them.

permanent link
VK L (8177157159) | answered May 08 '12, 7:27 a.m.
There should be a mapping table taht does not relate to workitems, but contains projarea-category mapping alone

Hi Russellin,
try to pick tables containing project area and category names together and set filters to be equal to your specific project area.

is there any way of getting a list of categories for a specific Project Area using BIRT? There is the Category table but when queried it returns all the categories from the repository.


There are some tablesthat provide this information but they require work items to have been created for the categories. We have 165 categories so initially not all categories would have a work item assigned to them.

permanent link
Russell Norlund (17221724) | answered May 08 '12, 11:20 a.m.
There should be a mapping table taht does not relate to workitems, but contains projarea-category mapping alone.

I can only see these tables:Workitem_Chngs_From, Workitem_Chngs, New_Wi_Count, Live_Workitem_Cnt. However, they do not look suitable

I got these from: https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20


Hi Russellin,
try to pick tables containing project area and category names together and set filters to be equal to your specific project area.

is there any way of getting a list of categories for a specific Project Area using BIRT? There is the Category table but when queried it returns all the categories from the repository.


There are some tablesthat provide this information but they require work items to have been created for the categories. We have 165 categories so initially not all categories would have a work item assigned to them.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.