It's all about the answers!

Ask a question

RTC burn down graph data location in Insight


Naweed Jaulim (632732) | asked Nov 26 '13, 7:54 a.m.
Hi,

Would anyone know where I can find the exact location of the RTC burndown chart data in in the DW model?

I am looking to replicate this in an Insight report.

RTC version: 4.0.2
Insight: 1.1.1.1

Many Thanks,
Naweed

One answer



permanent link
Kevin Ramer (4.5k8183200) | answered Nov 27 '13, 10:11 a.m.
In RRDI ( little brother of Insight )  The CCM sample reports have an Iteration Burndown report.  I opened this in Report Studio.  Under Query Explorer are:

Project
Team Area
RequestIteration
IterationDetail

And a join of the last 2.  
Request Iteration is probably from ODS / Requests / Requests / Request Iteration Extension
Iteration Detail, likely from ODS / Iterations / Iteration Detail

ODS == Operational Data Store.

I'd suggest you perform a similar exploration in Insight

Comments
Naweed Jaulim commented Nov 27 '13, 12:14 p.m.

Hi Kevin,

Thanks for pointing this out, I'll have a look at this report and see if I can re-use the queries.

Thanks,

Naweed

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.