Austin Agile DevOps

DevOps in the Cloud
posts - 68 , comments - 7 , trackbacks - 0

Passing in report parameters to TFS 2010 OLAP Web Parts on the Team Portal

There is some helpful information from Ewald Hofman on passing in parameters to the TFS SQL Server Analysis Services OLAP reports.

But, the 2010 schema has changed. You can use the SQL Server Mgmgt Studio to access the metadata and query the tables to seee the new schema and record values.

As an example of the Task Burndown report on the TFS 2010 Project Portal, here's the URL that worked in a browser:

http://{your tfs server}/Reports/Pages/Report.aspx?ItemPath=%2fTfsReports%2fDefaultCollection%2fCcMsd1.0%2fDashboards%2fBurndown&rc%3atoolbar=false&rs%3aCommand=Render&IterationParam=[IterationName].[ParentIterationSK].%26[{the IterationSK value}]

Here's the URL that was accepted in the web part:

/sites/DefaultCollection/CcMsd1.0/_layouts/TfsRedirect.aspx?tf:Type=Report&tf:ReportName=Dashboards%2fBurndown&tf:ShowToolbar=0&Width=381pt&Height= 180pt&tf:Command=Render&tf:Parameters=IterationParam=[IterationName].[ParentIterationSK].%26[17]

To-date though, even though the report processes without error, the passed in parameters don't make any difference/change in the report. So, I gave up on this approach and was somewhat successful with this approach (see my subsequent blog article).

Print | posted on Tuesday, May 15, 2012 8:48 AM | Filed Under [ Agile SCM Talk Blog ]

Feedback

Gravatar

# re: Passing in report parameters to TFS 2010 OLAP Web Parts on the Team Portal

Did you ever find a solution to this problem I'm also attempting to pass a pararmeter to a TFS report but am in the same situation.

http://stackoverflow.com/questions/12723486/how-can-i-pass-a-parameter-in-a-url-to-a-tfs-report-2010

The link above suggesting an alterative approach is broken

10/4/2012 3:56 AM | Will Hearn
Gravatar

# re: Passing in report parameters to TFS 2010 OLAP Web Parts on the Team Portal

I have corrected the link. It pointed back to my old blog site. I always work directly with the SSRS reports now and I like that fine.
10/4/2012 12:51 PM | Bob Hardister
Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 

Powered by: