Tricia J

I'd like to change the default iteration that displays on the Remaining Work report. I changed the default values section of the IterationParam from queried to non-queried and specified [Iteration].[Parent_ID].[117]. 117 is the id of the iteration in which I am interested. I had seen a post about changing the default Work Item type for this same report but the solution does not seem to work for iteration. Any ideas

Re: Team Foundation Server - Reporting & Warehouse Change the default iteration that displays on the Remaining Work Report

Mauli Shah - MSFT

Hi Tricia,

Try this instead:[Iteration].[Parent_ID].&[117]

This is the value as it's stored in the cube.

This user has a pretty good explanation on the SSRS forum:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=470094&SiteID=1

In addition to what the user in the forum post suggests, another way to figure out what the value in the cube is the following:

1 - Open SQL Server Management Studio

2 - Connect to the cube.

3 - Click "New query" - this will open up an MDX query window.

4 - In the left pane with the tree view, navigate to the value you're interested in.

5 - When you find the value you want, drag it out onto the query editor -- this will get you the value for that item.

HTH,

mauli





Re: Team Foundation Server - Reporting & Warehouse Change the default iteration that displays on the Remaining Work Report

Tricia J

Thanks Mauli - that worked!