Rational Insight - filter report data by project area and work item type
Hello,
I am trying to create an Insight report on RTC workitems and I need to filter the data from the data warehouse based on project area and work-item type. I have identified how to filter by project area, but I have yet to figure out how to determine the work-item types that are associated with the selected project area and filter on those.
Does anyone know how to do that?
Thanks.
I am trying to create an Insight report on RTC workitems and I need to filter the data from the data warehouse based on project area and work-item type. I have identified how to filter by project area, but I have yet to figure out how to determine the work-item types that are associated with the selected project area and filter on those.
Does anyone know how to do that?
Thanks.
Accepted answer
Hello Dan,
the work item type is in the following data item:
Operational Data Store > Request Area > Request > Request Type
You can find the link between Request Types and Project Areas in:
Operational Data Store > Request Area > Request Type
Best Regards,
Francesco Chiossi
the work item type is in the following data item:
Operational Data Store > Request Area > Request > Request Type
You can find the link between Request Types and Project Areas in:
Operational Data Store > Request Area > Request Type
Best Regards,
Francesco Chiossi
One other answer
Hello Francesco,
Thank you for the tips. Now here is the next question. The behaviour I want to implement in my report is this:
1. Display a list of available project areas and filter out those which do not have the classification name "RTC Project Area". Make this list single selection.
2. When a project area is selected, display a 2nd filter that shows all the request types available in the selected project area. This is a multiple select list.
3. When the selection is done, the next filtering criteria are : request planned start date, request planned end date.
At this point, the filtering is finished and a result set is to be returned in the report. This result set is to be processed, one result at a time, and it's data used to populate a table with relevant information.
How would I go about implementing the filtering logic?
Once I have the query defined and tested, I need to create a new report and use that query to generate the result set. What are the mechnisms by which I can iterate through the result set and populate the table as needed?
Thank you.
Dan
Thank you for the tips. Now here is the next question. The behaviour I want to implement in my report is this:
1. Display a list of available project areas and filter out those which do not have the classification name "RTC Project Area". Make this list single selection.
2. When a project area is selected, display a 2nd filter that shows all the request types available in the selected project area. This is a multiple select list.
3. When the selection is done, the next filtering criteria are : request planned start date, request planned end date.
At this point, the filtering is finished and a result set is to be returned in the report. This result set is to be processed, one result at a time, and it's data used to populate a table with relevant information.
How would I go about implementing the filtering logic?
Once I have the query defined and tested, I need to create a new report and use that query to generate the result set. What are the mechnisms by which I can iterate through the result set and populate the table as needed?
Thank you.
Dan