RRDI - How to view current iteration?
One answer
There is nothing that I am aware of that will auto-detect the current iteration without some user customization. You could potentially include a filter that looks at the iteration start and end date and if the current date is in between those, then it will display the results. This will indicate the current iteration.
For example, look in the data model at Operational Data Store > Iteration Area > Iteration. Include the items 'Name', 'Start Date' and 'End Date' in your query. Then create a 'Detail Filter' that looks like this. The returned result will be the current iteration. Furthermore, you can join this data with the 'Request Area' to get results for work items.
current_date > [Start Date]
AND
current_date < [End Date]
For example, look in the data model at Operational Data Store > Iteration Area > Iteration. Include the items 'Name', 'Start Date' and 'End Date' in your query. Then create a 'Detail Filter' that looks like this. The returned result will be the current iteration. Furthermore, you can join this data with the 'Request Area' to get results for work items.
current_date > [Start Date]
AND
current_date < [End Date]
Comments
Not sure what version of CLM you are running, but here is a link to the CLM to Data Warehouse mappings for v4.0.1 in Infocenter: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/index.jsp?topic=%2Fcom.ibm.rational.reporting.overview.doc%2Ftopics%2Fc_reference_datadictionary.html
We use the method Marc outlined to determine the 'current iteration' as well, but one note is that if you have an Iteration hierarchy or overlapping iterations you will get multiple results for that query.... just one thing to look out for.