In Primavera P6 -> Resource Usage Profile, we may have a problem that Unit of measure is not showing.
There could be various causes for this issue:
1) If the resource is a Material resource, the Unit of measure is not specified.
If the resource is a Material resource, you will need to specify the Unit of measure in Enterprise, Resources in the Details tab.
2) If it is a Labor or Non-labor resources, the Show Unit label is not selected.
If it is a Labor or Nonlabor resources, then make sure that in Edit, User Preferences in the Time Units tab the Show Unit label check box is checked. Continue reading “Why is Unit of Measure not showing in Resource Usage Profile in Primavera P6”
Sometimes we work in a project which use a different currency other than US dollar.
I will show you how to create new currency and using it for the new project.
Let’s say we have a new project:
This project will use Malaysia Ringgit (MYR). To create new currency, we go to menu Admin -> Currencies.
Click Add and enter information like below:
Now we will change to display currency in MYR. Continue reading “How to change currency in Primavera P6 and How is data stored when using multiple currencies”
When we use Earned Value Management technique, we focus on:
- Planned Value Cost (PV) = Budget At Completion * Schedule % Complete
- Earned Value Cost (EV) = Budget At Completion * Performance % Complete (usually equal to Activity % Complete)
- Schedule Variance (SV) = EV – PV
- SV > 0 : project is good, ahead of schedule
So Planned Value Cost play a very important role here.
By default when we assign resource to activity, the unit is distributed equally (linear). Then calculation of Planned Value is as above.
However in reality, we always adjust unit for each month/week differently.
Then How ‘Planned Value’ is calculated for Activities without linear distribution, by using Resource Curves or Manual distribution?
I will explain it in this article.
We have an simple project:
The resource assignment use Back Loaded curve: Continue reading “How does Primavera P6 calculate Planned Value Cost for Activities without linear distribution (using Resource Curves or Manual plan) in Earned Value Management”
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.
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”
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:
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.
Click back to the Database Configuration and correct the database name or hostname or instance.
Continue reading “Primavera P6 Professional : “Unable to connect to the database” error”