index > Team Foundation Server - Reporting > cubes issue

cubes issue

Hi All,
I'm trying to create a report where the data would come from tfswarehouse database. I need to generate:
Columns:

G S

In order to build this report out of the Team System cube you will need to use the "Work Item" dimension, the "Changeset" dimension and the "Work Item Changeset Count" fact. This last fact is the one that ties together the two dimensions. You will use that fact to know what changeset is related to what work item and then you will get the necessary fields from the Work Item and Changeset dimensions base on that.

Federico Kolliker Frers - MSFT

Thanks for the reply. I was caught up with other things, so couldn't focus on this. But I think I got the Work Item changesets report close enough.

On a similar note, I am trying to get a report that would tell me what changesets were merged. For example, I merge 10 changesets from my Dev line to my Test line and then commit the merge by checking it it. This would create a changeset coz of the checkin and the merge operation is complete. Now, can I generate a report that tells me what 10 changesets went in to the Test line.

Thanks.

G S

reply 3

You can use google to search for other answers

More Articles

·report designer don`t find all fields

·How the change in the data of Cube will be reflected?

·problems passing parameters to subreport

·Unplanned work report incorrect

·reports not showing up on home page

·Render and Create PDF File directly from an aspx page

·Bug Rates Report - Getting very weird report

·Passing new parameters to Microsoft VB.Net Report(.rdlc)

·Quality Indicators Report

·date current state was set

Welcome to Bokebb New Update Joins the collection

New Articles

·Turning a Work Item Query Into a Report
·error uploading reports
·how to produce reports using rs with fea��
·Errors when deploying to ReportServer
·Scenarios With No Tasks
·Only Team Sytem cube is visible
·How to debug the subscription function
·How to create a new Report in Team Found��
·Deploying cube so as to make reports bas��
·Failed to load adapter
·Reuse query definition in reports ?
·Reports not accessible through project p��
·Reporting Services Hidden Lines
·Reports against Version Control
·Another TFS Warehouse problem...

Hot Articles

·Unable to generate a model from the OLAP��
·TFS Reporting does not work due to wareh��
·Can't get access to reports if the data ��
·error uploading reports
·TF53010 An unexpected exception occured ��
·Failed to generate reports
·DateTimes become Dates in Warehouse/Repo��
·Create Report Problems
·Build metrics
·Issues with dimension after following wa��
·Parameters in Report Server
·Render and Create PDF File directly from��
·Error when trying to display a report
·How to create a new report and include i��
·Reports for all current active projects

Recommend Articles

·Recreate Reports
·Where are the Models?
·Having trouble deploying to the report s��
·Create Report Problems
·"TF53010: An unexpected condition h��
·TFS Report Error
·reports don't work in projects created w��
·How to create report on custom defined p��
·Did report updating frequency change sin��
·Related WOrk Items With Code files?
·Label reports
·Cross Project Reports
·What's the difference between TfsReportD��
·What is the formal definition of Priorit��
·Requirements Test History and Overview n��