It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×7,426
×6,018
×1,235
×403

question asked: May 06 '13, 5:11 p.m.
question was seen: 5,131 times
last updated: Jul 15 '13, 5:20 p.m.

Related questions

Why do metrics tables not go back in time as far as ODS tables in reports and how do I fix?

0
Michael Walker (992●15●201●157) | asked May 06 '13, 5:11 p.m.
One of the teams we support is using RRDI 2.0.1 with CLM 4.0.1.  They created a report using the Request Metrics tables, but the chart produced only shows request info back to November 2012.

I looked in the Requests table in the Data Warehouse and the Requests there go back to 2010 and if I create a simple List Report using the Operational Data Store it shows them all from 2010.

How do I sync up the metrics tables with the Data Warehouse tables so they go back to 2010 like the Data Warehouse tables show?  Is it as simple as running the full Data Collection job in CLM or something else?

thanks,
Comments
Michael Walker commented May 08 '13, 3:17 a.m.

bump bump bump

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Petroula Pantazopoulos (366●1●2) | answered Jul 15 '13, 5:20 p.m.
JAZZ DEVELOPER
Some of the tables just capture information as a snapshot at a point in time.  If your data goes as far back as Nov 2012, then that's when you most likely started to run your etl and populating the tables.  F_REQUEST_METRICS is one of those trending fact tables that just takes a snapshot of some of the ODS request data and computes facts/measures for them.  There is no way to fabricate past data in this case for past dates.

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.