Welcome to PCO Blogs

This is a place for Registered Users to share their technical view and opinions in form of blogs which they think might be useful to the greater PCO community. We invite prolific writers to share their insights and witticisms, but remind all contributors to be mindful of any copyright rules. ProjectControlsOnline will not be held responsible for any breach in rights and responsible users will be held accounted for the same.

Please note that you may NOT get badges, stars etc. by posting blogs here as they are pretty meaningless as they do NOT make you wealthier, fitter or more attractive to the opposite sex! The best you will get from contributing here is the satisfaction/self-respect from knowing you have helped others.  So, please continue to make positive contribution to this community portal and extend whatever help you can to your fellow colleagues.  Thanks!

 

Please read this help page before creating a blog

spacer
Latest blog entries

How To Find Relationship Lag in Primavera P6

May 15

Written by:
15/05/2012 13:37  RssIcon

  • Program: Oracle Primavera P6 Professional
  • Version: any
  • Difficulty: Intermediate
  • Time to Complete: 15 minutes

It’s not easy to find Relationship Lag in Primavera P6 project schedules. There aren’t really any features to highlight lag. But understanding how leads or lags are used on your project is an important part of really knowing your schedule.  We need a process to root out any relationship lags in P6.

What’s wrong with using Relationship Lag in my schedule?

The use of Relationship lag is widely discussed on Scheduling and Project Controls discussion boards. The concensus and best practice is that the use of relationship lag should be minimal if it’s used at all.   Why?

According to the Practice Standard for Scheduling, a document prepared by scheduling experts at the Project Management Institute, using Relationship leads or lags add significant schedule risk to a project.    The main reason is the lack ofvisibility of lag delays on project schedules.  Lag time is hard to identify and document – it isn’t obvious when looking at the Gantt Chart or when analyzing a schedule’s dates.   When lag time is used on a schedule, it is very rarely documented why the delay was added,  causing construction managers to scratch their heads.  Time IS money, after all.  As a best practice, any lag should always be documented in a Notebook topic on the activity.  Or better yet, follow PMI’s standard and use full activities to represent lead/lag delays.  This approach makes leads/lags very visible on a schedule and also allows for more flexibility.

It’s common for less experienced planners to submit schedules with lag.  In Primavera P6, we really need to be able to find out if a schedule uses relationship lag.

Unfortunately, inside the Activity screens in P6, there seems to be no way to sort or filter activities by Lag.  So we’ll need another approach, one that is easy and reusable.

Building a Reusable Relationship Lag Report in Primavera P6

It’s pretty easy to build reports in Primavera P6.  And the reporting features are able to report on a project’s relationships.  Using Filters, we can create a nice report that shows only Activities that have relationships with leads or lags.  Here’s how:

Step 1 – Create a New Report



Navigate over to the Primavera P6 Reports screen.   Click the Add button on the Command Bar to add a new report to your database.

Step 2 – Choosing the Report Subject



When the Report Wizard comes up, click Next to create a new Report.  On the following screen, select the “Activity Relationships” subject area and click next.

Step 3 – Choose Columns







Select the columns as shown.  Click OK.

**NOTE: I’ve discovered that both the “Predecessor ID” and “Successor ID” columns will always be renamed by Primavera to “Activity ID”.  If you click OK after selecting columns and go back to the column choosing screen, these two columns are renamed to “ID”.  I can’t change them either….c’est la vie!

Step 4 – Turn Off Group and Sort



Click the Group and Sort button and set it to or leave the Group By field blank.  Click OK.

Step 5 – Setting a Custom Filter for Lag




Click the “Filter…” button.  In the Parameter dropdown, find and select “Lag”.  Set the conditional dropdown to “is not equal to” and type ’0′ in the Value column.  This combination will filter for both leads (ie: negative lags) and lags.  Click OK to save your Filer.

Step 6 – Saving the Primavera P6 Lag Report



Click Next.  On the following screen, name your report “Relationship Lag Report“.  Click Next.  Before you click Run Report, click Next again and Save your report.  Click Finish to close the Wizard.

It’s ideal to Save your report first before running it.  It may not run if you do not have a project open first.

Step 7 – Open a Project and Run the Primavera P6 Lag Report




Open a Project and then run your report.  You should see some output similar to the above.

Wrap-up

Having this report pre-built will help you be prepared anytime you need to run some analysis on a schedule, perhaps even a schedule a contractor has submitted.  So keep it in your arsenal of analysis tools.

It’s worth mentioning that another approach that works is to export your project data to Excel, including the relationships table.  You can then use the filtering tools in Excel to zone in on relationships that have lead or lag delays.  I prefer to avoid Excel in this case because the export takes too many clicks to produce the proper dataset.  This report can be run with 3-4 mouse clicks max with the same end result.

Now remember to follow the best practice mentioned in the intro.  Avoid using lag or lead altogether in your schedules.  Instead you should use a well-defined activity to represent any lag or lead delay in your project plan.   Everyone will be much happier for it!

Created by Plannertuts.com
The tutorial is originated from http://www.plannertuts.com/tutorials/how-to-find-relationship-lag-in-primavera-p6-1184/
.



Your name:
Gravatar Preview
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment   Cancel 
spacer
Search Blogs
spacer