Have you ever migrated dozens or even hundreds of projects to a new Primavera P6 database? Perhaps your company is migrating several standalone databases to a new shared database, or perhaps you are archiving old projects. If you’ve done this before, you know how challenging this can be; it can take hours, if not days, to get ahold of all those projects and import them into your new database. That’s not even accounting for the dozens of hours that will be needed to clean up your global data, ensuring no old or outdated data pollutes your new database, and that different business units’ resources, codes, UDFs, and calendars aren’t impacting one another.
There’s a better and more efficient way of doing this. Emerald’s P6-Scrubber now allows you to skip over the tedium and monotony of importing projects into your new database, while cleaning these files at the same time.
Here’s how it works.
Written by Valerie Nicholson, B.A. - Implementation Specialist
on Monday, 30 March 2026.
Posted in P6-Scrubber
When creating your schedule in Primavera P6 Client, keep in mind basic best practices that can help make the process much smoother, both for creating the project and for project execution. Below, we have listed a few topics, in no specific order, and not meant to be an all-inclusive list.
Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist
on Wednesday, 18 February 2026.
Posted in Primavera P6
During schedule execution, there are common issues that can occur on a regular basis, whether or not the schedule is specifically a turnaround execution schedule. The items below are not an all-inclusive list of potential pitfalls, but are some of the issues that appear regularly.
Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist
on Friday, 13 February 2026.
Posted in Primavera P6
In version 8.0, we have introduced quality assurance checks, data analysis and auto-scrubbing. Choose from pre-defined validations and create your own to match your company's needs with configurable warn/fail checks. Peruse sleek and responsive reports to see any potential issues in your projects or activities, all bundled together with regular scrubbing capabilities. Dig into schedule details with our project statistics dashboards.
Written by Ravi Wallau
In version 8.0, we have introduced quality assurance checks, data analysis and auto-scrubbing. Choose from pre-defined validations and create your own to match your company's needs with configurable warn/fail checks. Peruse sleek and responsive reports to see any potential issues in your projects or activities, all bundled together with regular scrubbing capabilities. Dig into schedule details with our project statistics dashboards.
New Features
-
QA Validations - Include quality assurance checks when you scrub your files, ensuring that your projects and activities meet your company's specifications. Create your own specific validations.
-
Real-Time Reporting - Enjoy clear and responsive graphs and charts with your QA reports. See any potential issues at a glance, and delve into more detailed reporting with a click of your mouse.
-
Auto-Scrub - Drop a file into your folder and allow P6-Scrubber to auto-scrub and auto-import without having to lift a finger. Apply pre-configured rules to save your team time.
-
Project Statistics - The first phase of project data and statistics graphics in P6-Scrubber. See the details in your schedule in relation to activities and resources. Full blown comparisons are coming soon.
P6-Scrubber News Articles
on Thursday, 05 February 2026.
Posted in News, P6-Scrubber
Primavera P6 uses the Critical Path Method (CPM) of scheduling.
CPM Scheduling uses the Activity Durations and the Logic between the activities to calculate three pieces of data:
- Assigns dates to project activities (Early and Late Dates)
- Calculates your project’s Finish Date (Calculated during the Forward Pass)
- Calculates your project’s Critical Path (Identifies the longest sequence of dependent activities in a project)
The Critical Path Method does two passes through the schedule.
The Forward Pass starts with the first activity in the logic chain and moves forward through the schedule calculating the Early Dates of the activities - these are the earliest dates the activity can start and end based on the activities’ duration and logic ties. The calculation starts with the first activity in the logic chain (if it is not at the data date [DD] and does not have a hard constraint assigned it is moved to the project DD for the start date) and then moves forward through the schedule using the following calculation: Early Start (ES) + Duration - 1 = Early Finish (EF)
Written by Sue Fermelia - Implementation Specialist
on Thursday, 15 January 2026.
Posted in Primavera P6
Ideally in projects, the natural flow of time through the project using durations and logic should be respected. However, sometimes there are date restrictions that cannot be built into network logic. Constraints provide additional control over start and finish dates when specific deadlines or project conditions exist. A Constraint allows a scheduler to accurately reflect real-world aspects of a project.
Written by Sue Fermelia - Implementation Specialist
on Friday, 02 January 2026.
Posted in Primavera P6
Who this is for: Teams running Primavera P6 software with project data generated by P6-Reporter and stored in a self-hosted Oracle database, who want to light up Power BI—and now also Microsoft Fabric—without re-platforming their core systems.
Written by Max Wang - Integration Specialist
on Tuesday, 25 November 2025.
Posted in P6-Reporter
Emerald’s P6-Migrator - SQLite and Oracle allows you to export files from your Primavera P6 database, including SQLite databases, and then import those files into a P6 online or local database, cutting out the struggle of manually exporting and cleaning up each file before manually importing them into your database.
Written by Sue Fermelia - Implementation Specialist
on Wednesday, 22 October 2025.
Posted in P6-Migrator - SQLite and Oracle
At Emerald Associates, we are always looking to improve our tools and increase their functionality. We have recently released P6-Scrubber v7, which includes several new and overhauled features.
Written by Valerie Nicholson, B.A. - Implementation Specialist
on Tuesday, 23 September 2025.
Posted in P6-Scrubber
A Cost Breakdown Structure (CBS) in Oracle Primavera Cloud (OPC) is comprised of cost codes classified into three types: expense, capital, or none. The codes are organized based on segment definitions to form a flat or hierarchical structure. A CBS is used alongside the Work Breakdown Structure (WBS). The WBS breaks down project work, and the CBS represents the associated costs.
Familiarity with the workspace hierarchy and reporting requirements helps ensure that the CBS is set up to allow required rollup functionality.
Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist
on Monday, 15 September 2025.
Posted in Oracle Primavera Cloud (Prime)
Are you looking for a resource display in Oracle Primavera Cloud (OPC) that clearly indicates the under/overallocation of resources (and roles)?
Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist
on Tuesday, 02 September 2025.
Posted in Oracle Primavera Cloud (Prime)
Let’s have a quick look at a couple of functionality pieces now available in Oracle Primavera Cloud (OPC) that you may not have used yet. They were added in OPC v25.7.
When using task cards, you can now display the crew size on the task cards. When the task card is displayed, the icon with the crew size number can be included with the display.
Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist
on Monday, 18 August 2025.
Posted in Oracle Primavera Cloud (Prime)
Watch an example of how to make Gantt Charts using Emerald's BI-GanttView.
In this short video, we go over some examples of Gantt charts that can be made using Emerald's BI-GanttView. Using data pulled from Oracle Primavera P6, we discuss and demonstrate several different chart examples. Take a look to see how we utilize features such as the three-layer timeline, milestones, multiple columns, critical activities, and our customized colour scheme.
The Emerald BI-GanttView tool offers extremely configurable charts, with multiple columns, three-layer timelines, improved label control, top axis milestones, multiple hierarchy levels for a full WBS hierarchy display, and more. Just about everything is configurable, including the shapes and colours of your milestones, font styles and sizes, color coding of activity bars, robust sorting capabilities, increased label control, and much more. You can even display multiple projects, with information presented clearly for non-scheduling team members. The Emerald BI-GanttView can use any data incorporated into Power BI, regardless where it is from, so you can start building your charts from your existing data quickly and efficiently.
Interested in learning more about how the Emerald BI-GanttView can help you and your team? Feel free to take a look at the links below, or check it out on Microsoft AppSource/Marketplace.
on Tuesday, 12 August 2025.
Posted in Emerald BI-GanttView
With the new release of the Emerald BI-GanttView visual for Power BI, we wanted to take the chance to look at some of the features that this visual offers.
Written by Amy Paul B.A. - Marketing/OPS
on Tuesday, 22 July 2025.
Posted in Emerald BI-GanttView
You can add as many global changes as you need for your project in Oracle Primavera Cloud (OPC).
Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist
on Wednesday, 09 July 2025.
Posted in Oracle Primavera Cloud (Prime)
