Skip to main content

Articles in Category: All Articles

P6-Reporter: Self-Serve Dashboards - Commodities

Can you readily monitor commodities on your P6 projects? For example, if your business is oil and gas, can you readily track the requirements of casing or the production levels of oil? For tracking your projects, consider self-serve dashboards for your portfolio of projects.

P6-Reporter - Progress Summary Reports in Tableau

How are you reporting summary progress information on your project? For example, how are you tracking and reporting inspections? Does your team have access to Valve, Exchanger or Piping Summaries in their project reporting dashboards? Provide your team access to easy to digest status reports on progress specifics on your project that are updated using automated snapshots in P6-Reporter (previously EP-datawarehouse). The added information availability is not an extra task that your team needs to spend time on. Once the regular updates to your schedule are completed/reviewed/analyzed, a snapshot of the project is taken. The snapshot process can be automated or you can do it manually if you prefer. The snapshot provides the current information to P6-Reporter dashboard reports. The information the dashboard user views are the latest available from the snapshots. Have regular snapshots of your projects to feed dashboard reports which work to streamline the reporting process. This ensures all team members have access to the most current information with no printing and/or emailing of the reports required for distribution. Previous snapshots are available for easy access if required in P6-Reporter self-serve dashboards; just change the Report date in the drop down menu. Below are some examples of Summary reports displayed in Tableau. Similar reports can be displayed using ODV and Power BI as well.

P6-Reporter - Green Up and Racetrack Reports

Whether it is inspections, pressure safety valves, piping or other elements you are tracking in your P6 Schedule, you can use P6-Reporter Green Up reports which are easily created and maintained right from your P6 schedule. That is correct - no separate spreadsheets required!

P6-Scrubber v5 - New Release

Work online or offline to define and scrub your XER files and now, in the new release, XML files. Version 5 makes scrubbing files even easier for schedulers.

December 5, 2022

Written by Ravi Wallau

Work online or offline to define and scrub your XER files and now, in the new release, XML files. Version 5 makes scrubbing files even easier for schedulers.

New Features

  • XML support! Now the P6-Scrubber can scrub XER or XML files.

  • Simple prefix - lets you add a prefix to global objects such as resources, code types, UDFs, calendars, etc. to identify where it came from.

  • XML sanitation - when scrubbing an XML file, its contents are saved accordingly to the XML schema file. If the file cannot be imported into P6 EPPM because of schema errors, processing the file with the P6-Scrubber may fix it.

  • Version control - setting the version you are uploading back into P6 is now in the GUI for easier control for both XER and XML importing.

  • Parent role & resource - to land all the resources and roles in the scrubber file under a specific role or resource in the P6 database.

  • OBS definition - it is possible to choose an OBS that will be associated to the project when it is imported when scrubbing XER files.

  • SSO/ SAML support - if you are using SSO/ SAML for your P6 Cloud environment, you can perform SSO/ SAML login with the P6-Scrubber.

Enhancements

  • UI improvements - the last imported project (or projects) is shown in the UI, and it is possible to access the scrubbed files directly from the main page of the application.

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.