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.5k6171190) | 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.