Maturity history of CR

[jfrankovich]

Does anyone have any insight into how I can collect the Maturity History of all CRs in a report? I need to generate a report that calculates the time difference between the "Under Review" promotion date and the "Implemented" promotion date.
This seems easy but I haven't found where the data resides.

John Frankovich
GSI Group LLC
www.gsiag.com<">http://www.gsiag.com>

[AL_ANDERSON]

Using Query Builder, in the From tab, select "Life Cycle History" and
"Life Cycle Managed" or "ECR" or whatever you want the history for.

Then in the Join tab, you join your lifecycle managed type to Life Cycle
History using the "Object History" link.

I usually limit this to one context because of the number of results. To
do that, add "Context" to the From tab, and join the lifecycle managed
object to Context using the Context Reference.

In the Criteria, you want Life Cycle HIstory.Action to = "Enter_Phase" in
order to avoid duplicate records.

You may also want to time bound your query to further limit your results
(i.e. object created >= some parameter or constant).

I then Sort by the lifecycle managed object number first, and by the Life
Cycle History Created date second.

You then get all the hisotry in order for each object.

If you don't like the results of date fields in seconds and minutes, then
use the Left Trim function to trim the result down to just day, month, and
year.

Of course, you have to be careful if your process allows a state to occur
more than once. In that case, you need an excel formula or macro to pick
the first occurance of your first state, and your last occurance of your
last state if you want the time from the first to the last. Or, you might
want the time from the firs occurance of one to the first of the next, and
then again from the 2nd occurance of the first to the 2nd of the next, and
so on. You'll have to look at your data to figure out what you want.

Al Anderson







John Frankovich <->
09/19/2011 03:21 PM
Please respond to
John Frankovich <->


To
"-" <->
cc

Subject
[solutions] - Maturity history of CR




Caterpillar: Confidential Green Retain Until: 10/19/2011



Does anyone have any insight into how I can collect the Maturity History
of all CRs in a report? I need to generate a report that calculates the
time difference between the ?Under Review? promotion date and the
?Implemented? promotion date.
This seems easy but I haven?t found where the data resides.

John Frankovich
GSI Group LLC
www.gsiag.com


Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your subscription
Use of this email content is governed by the terms of service at:

[ddemay]

LIFECYCLEHISTORY .I think Mike Lockwood gave out an example report for a
different object before? You would just have to tweak it to calculate time.

[MikeLockwood]

Please see attached.
The key is to use the Lifecycle History table (as Dave Demay said), joined multiple times to the Change Request, different alias for each state, then add criteria as shown in attached (Action=Enter_Phase and state=xxx).
[cid:image002.png@01CC76E3.9F39C980] [cid:image003.png@01CC76E3.9F39C980]

Can do the averaging / other statistics either in Windchill (as shown above) or externally (Excel) with a CSV file output.

Note: Relatively major limitation (bug)!! Only works with multiple states for the root Change Request type; doesn't work with any subtypes, so attributes specific to a sub type cannot be included in the same report, and other subtypes have to be filtered out.

[jfrankovich]

Thanks all for the info. I had started looking at the LifeCycle history data but without all of your contributions I could have been spinning my wheels for a while. Now it looks like I might actually be able to generate the report a couple of hours after the initial request. Cheers!

John


From: Lockwood,Mike,IRVINE,R&D [