Skip to main content

Emerald Blog

Stories, Tips And Tricks From Our Team’s Experiences With Primavera Since 1995

Ensuring Accuracy When Reverting Changes in Primavera P6 Using P6-Loader

Recently, I was working with a client who was reorganizing. This client has many business units (BU) that work in the same database, so they have a prefixing standard for each BU.

When they reorganized, all the prefixing for several BUs needed to be brought into alignment with the reorganized BU structure. This involved moving their EPS structure around and updating the prefixes on calendars, codes, resources and roles. I had started moving the structures to accommodate the changes and updating the prefixes with P6-Loader, but I also did some updating directly in P6. I had completed roles and was partially through resources when the client realized their reporting may be effected by the changes. They wanted to revert all the changes I had made. While I did have several P6-Loader change files that I could use to revert the changes I made using P6-Loader, I wanted to be sure the manual changes I made were also restored.

Restoring Deleted P6 Data - Never Happens Right?

A solution for common cases of accidental data deletion in Primavera P6

upset at computer 800

Accidental deletion of important data is something that happens. Everyone has done it at some point.

In Primavera P6 EPPM, some of the most common cases of accidental data deletion are:

  • Deletion of the wrong resource
  • Deletion of the wrong project
  • Deletion of the wrong WBS node or nodes

Put the Best Tools in Your Scheduling Tool Kit

Your project schedule will be created in P6, and you are looking to provide the best schedule tools for your project team. What can you add to your team tool kit to assist the project team, address building the schedule, monitor schedule quality, utilize options for updating the schedule and make reporting quick and easy? Let’s look at a few examples for some food for thought.

Are Resource Codes Helpful In a Turnaround Schedule? Yes!

Often on a Turnaround, or any large project, you need to report resource availability and requirements in your schedule by Craft (trade) and Company. But often, that’s not how the resource dictionary hierarchy is set up. How do we solve this problem? Well, an easy solution to the reporting requirement is using resource codes.

TAPS - Take Advantage of Streamlining P6 Updates and Data Calculations

TAPS is not just a tool to streamline P6 project file updates. Are you looking to monitor and report on earned value (EV) at the resource level? P6 out of the box (OOTB) calculates EV at the activity level. Using TAPS Classic or Mobile provides some additional background calculations which are available for monitoring and reporting from P6 itself or from P6-Reporter (if you are using that tool). Even when multiple resources are assigned to an activity, the EV calculated in P6 OOTB is at the activity level. With EV calculations at the resource level you can gain more insight into where you may need to step in because a subcontractor is struggling (for example). With any issues easily identified, the assistance required can be coordinated and implemented to help bring activity progress closer in line with the execution plan as well as document lessons learned to prevent repeat occurrences.

P6-Reporter - Project Detail Dashboard

Access your self-serve Project Detail Dashboard for easy to digest project information (displayed below in Tableau). Just choose the project and snapshot you want to view using the filters at the top left corner of the dashboard. The project displayed in the dashboard below is a drilling project. This example is food for thought on reporting options available for your projects.

TAPS Mobile - Streamline Primavera P6 Schedule Updates

Are you processing updates to your schedule manually and think that is the best option? I recently assisted a team with a project where, in order to complete the project schedule updates in an acceptable timeframe, their company decided to hire additional people just for the updates. I understand the time constraint they were under, but for follow-up projects, there are more efficient, less costly options available that also keep your updates less prone to data entry errors. One example is TAPS Mobile. 

TAPS Mobile allows update processing from your mobile device. That may not sound like a high-impact item, but keep in mind, every time data has to be handled, it is a labor spend (time and dollars). There is also the introduction of another data touch point where a data entry error may occur. You can streamline the update process by submitting updates directly from a mobile device. Instead of filling out a report and then inputting those updates into the project manually, consider completing your status checks, inputting the information into your mobile device, and clicking save to send the update(s) directly to P6. This streamlined update process can provide additional time to analyze the schedule updates. Proper schedule analysis is an important step and can get severely crunched if the entry of schedule updates is not streamlined but instead a labor-intensive, time-consuming process.

P6-Reporter – Scenario Comparisons

Often we need to compare and analyze multiple scenarios for our projects. Using P6-Reporter (previously EP-datawarehouse), we can store a snapshot of each scenario. These snapshots can be compared directly using P6-Reporter. The user can compare assignments as well as costs. Let’s have a look at an example of rig assignment scenario comparisons. Utilizing P6 scheduling functionality, build the scenarios in P6. Once the scenarios are created, create snapshots of the scenarios in P6-Reporter.

Creating a Snapshot with P6-Reporter

Taking snapshots can be an automated process, but you can create them manually as well. Creating a snapshot manually is easy to accomplish.



Complete the required updates in your P6 schedule and then create a snapshot.

To create the snapshot, go to the projects tab in P6 and set the 'P6R - Snapshot - Period' (previously 'EP-dw – Snapshot – Period’) and the 'P6R - Snapshot - Run' (previously ‘EP-dw – Snapshot – Run’) fields.

P6-Reporter - Project Reports at Your Fingertips

Easy access to up-to-date, easy-to-digest reporting is available by including Power BI reports on your projects. Keep the process convenient and streamlined to allow your team to focus their efforts on the project while simply digesting the dashboard reports. P6-Reporter (previously EP-datawarehouse) brings with it a set of standard reports. That does not mean the users are confined to that specific set of reports. As additional reports are added to P6-Reporter, you will have access to all the new reports as well. You and your team can also add to the P6-Reporter report collection by creating additional reports yourselves. These options put you and your team in a position to not only fill all reporting requirements on your project but to streamline your reporting and improve project communication.

In this blog, we will look at couple of examples in Tableau and Power BI. These dashboards are not an all-inclusive list but meant as food for thought.   

Handling Codes Prior to XER/XML Import with P6-Scrubber

This blog is a deep dive into what can be accomplished with codes using P6-Scrubber prior to importing an XER/XML file. Frequently, when importing a schedule from an outside source into our existing database, there are codes we want to either delete, rename or, in the case of activity codes, rolldown to the project level. P6-Scrubber is able to handle all of these cases.

P6-Reporter – Portfolio Summary Self-Serve Dashboard

In P6-Reporter, the Portfolio Summary Self-Serve Dashboard provides easy access to portfolio level information. In the screen shot below, the user has summary information for all the projects in the portfolio displayed. Across the top of the dashboard are easy-to-use filters allowing the user to filter for exactly the information they need to focus on if the entire portfolio is not their current focus requirement. The report date indicates the snapshot information being displayed, and the user can filter for other snapshots if required. Previous snapshots remain available for display. Keep in mind, the snapshot process can be automated or manual.

TAPS - Not Just for Turnaround Schedules

Although TAPS was originally developed to assist with the large number of updates that need to be processed into a turnaround schedule for every update, do not limit your imagination! TAPS can be used to process updates to schedules other than just turnaround schedules. Consider where this tool can assist in addition to updates on turnaround schedules. Keep in mind that TAPS is also available on mobile devices.

Below is just one of a large number of scenarios for how TAPS can be used.