index > Team Foundation Server - Reporting > cube versus warehouse

cube versus warehouse


hi

my experience was that it is much easier creating reports directly from the warehouse, instead of using the cubes. what are the advantages of using the cube?
thomaskremmel

Queries for values which are aggregated in the cube will be much faster because they are precalculated. Also the data has been coalesced for reporting a little more in the cube than in the Warehouse.

These befefits may be outweighted if it takes you much longer to develop the report and you do not need the additional performance. I am not sure what you are using to create your reports, but Report Designer (VS Report Server Project) can build quite a few report queries by dragging measures etc into a query window. Give it a try - or import an out-of-the-box report for some ideas.

Nick Ericson - MSFT

Recreating the totals at a point in time to facilitate burndown charts (like, how many bugs were active on each day last month) is very easy using the cube, and very difficult using the relational warehouse. Also, if you want to slice and dice in an ad-hoc manner using excel or other client applications, the cube is a good option.

For simple lists of the current version of work items, using the relational database can be a good option.

Tom Patton
ok thanks
thomaskremmel
reply 4

You can use google to search for other answers

 

More Articles

ReportServer asking for username and password
Problem with data stored on Warehouse in custom work item field
Error in Reporting
Another warehouse not updating :( - now FIXED :)
date current state was set
Edit reports from Agile process template?
Report server problem.
Reporting Services Error
Report not showing in Team Explorer
Reporting Changeset Details
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

Workitem trends and filters
Error in Customising a existing report
No report image in Project Portal, but d…
Importance of Work Items - Remaining Work
Error 28806. Something is wrong with Re…
date current state was set
The synchronization issue of the reporting
Recreate Reports
report designer don`t find all fields
How do I set default value for a dimensi…
Report server error
Quality Indicators Report
Where are the Models?
msmdsrv using 50% cpu for minutes
"TF53010: An unexpected condition h…

Hot Articles

How to recreate the TFSWarehouse Databas…
Creating a custom report -- help
how to create entirely new report
report designer don`t find all fields
TFSWarehouse shows data but reports come…
Build report not displaying build data
Report for finding Defect/Bug Frequency
problems passing parameters to subreport
Reuse query definition in reports ?
An attempt has been made to use a data e…
Accessing Global Lists From Reporting Se…
Simple query to find work items resolved…
More Warehouse problems
urgent: Connection Problems
Can not find any Perspective other than …

Recommend Articles

Error 28806. Something is wrong with Re…
Adding Data Region to existing items
Using Excel pivot charts, can I filter o…
What's the difference between TfsReportD…
Report for finding Defect/Bug Frequency
custom views in TFSWarehouse
How can I create Dynamic Query between t…
Label reports
TFS Reporting does not work due to wareh…
Creating a custom report -- help
Can I customize the VSTS bug report?
Source Control Reporting
Setting for URL in Reporting services
rsRenderingExtensionNotFound
Reporting on inforamtion in work item hi…