How does Primavera P6 summarize data in the Summary / Grouping Band

We may wonder How does P6 calculates and displays summary information for costs, quantities, user defined fields, dates, durations, float, progress…

I will explain it in this article.

These calculations and display summaries are based on the currently visible activities. Activities removed from the layout by filters are not included in the calculations and summaries.

Costs and quantities:

P6 totals cost and quantity data items, such as budgeted cost and budgeted quantity, by adding the values for each activity in the summary.

Dates: 

If you display early dates, P6 shows the earliest early (or actual) start and the latest early (or actual) finish dates. The same rules apply for late dates and baseline early and late dates. Continue reading “How does Primavera P6 summarize data in the Summary / Grouping Band”

Advertisements

Primavera P6 Professional : “Unable to connect to the database” error

When connect SQL database in Primavera P6 Professional, we usually have problem like:

  • Error Message:  Bad public user Name or password. SQL Server Error: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
  • Error message: Bad public user name or password. SQL Server Error: [DBNETLIB][ConnectionOpen (Invalid Instance()).] Invalid connection.;”
  • Error Message:  Bad public user name or password. Database Server Error: Login failed for user ‘pubuser’.

Below are some Reason and Solution:

CAUSE 1:
Incorrect hostname, instance or database name
Bad public user Name or password. SQL Server Error: [DBNETLIB [ConnectionOpen(Connect()).]SQL Server does not exist or access denied.;

The default configuration entries for a standalone installation are localhost\primavera for the server host name and PMDB$primavera for the database name.

FIX 1:
Click back to the Database Configuration and correct the database name or hostname or instance.

Primavera P6 Professional Unable to connect to the database error-1

Continue reading “Primavera P6 Professional : “Unable to connect to the database” error”

How to Print the Legend for Stacked Histogram in Resource Usage Profile in Primavera P6

We create a Stacked Histogram like below picture:

How to Print the Legend for Stacked Histogram in Resource Usage Profile in Primavera P6-1

We need to Print the diagram with the Legend but there is no option to show the Legend:

How to Print the Legend for Stacked Histogram in Resource Usage Profile in Primavera P6-5

 

In other diagram (not stacked diagram) we can easily see the option to show Legend: Continue reading “How to Print the Legend for Stacked Histogram in Resource Usage Profile in Primavera P6”

What is Primavera P6 Professional latest version?

Primavera P6 Version History

Version Release Date Detail Information
17.7 21-Jul-2017 What’s new in version 17.7

P6 Professional Version 17 Documentation

16.2 30-Sep-2016 What’s new in version 16.2

P6 Professional 16 R2 Documentation

16.1 31-Mar-2016 What’s new in version 16.1

P6 Professional 16 R1 Documentation

15.2 30-Sep-2015 What’s new in version 15.2

P6 Professional 15 R2 Documentation

15.1 31-Mar-2015 What’s new in version 15.1

P6 Professional 15 R1 Documentation

How to define Resource Productivity in Primavera P6 and create schedule

When create a schedule, we can based on Resource Productivity to estimate duration.

For example:

  • We have a team which can cast 10 m3 of concrete per day (This is Productivity)
  • We have an Foundation which take 100 m3 concrete.
  • Duration of Foundation activity will be  100 / 10 = 10 days

Now we will do it in Primavera.

Supposed that we have a schedule like below picture:

How to define Productivity in Primavera P6 and create schedule-1

First we need to change Duration type of all activity to “Fixed Units/Time” Continue reading “How to define Resource Productivity in Primavera P6 and create schedule”