How to Change Working or Non-Working time for an Enterprise Resource

v4Steps:

  1. Project Web App > Resource Center > Select the resource as per below snapshot:

v1

2. Click Open in the Resource tab in ribbon. This will open the selected resource in the Microsoft Project Professional to edit the working time or change any other properties

v2

3. Double click on the resource in the resource sheet as per below snapshot:

v3

4. Click on Change Working time > Exception Tab > Select the exception row then click on Details and set the working time as required. Refer the snapshot below:

v4

5. Save and Check in the Enterprise Resources. Now you will find the capacity of the resource is showing in the schedule. Refer the snapshot below:

Enterprise Gantt chart view

v5

Resource Usage view

v6

Resource Availability in Project Web App – (I would update the below image to display two entire weeks and then emphasis that the resource has 48hrs of availability in the second week as opposed to the 40 hrs in the first)

v7

Hope this helps you.

 

How to perform a bulk publish via PowerShell

Background:

For a number of reasons you may wish to perform a bulk publish of all projects. Reasoning include the desire to force a refresh of permissions to project sites or to update the Project Server reporting database, with updated project site workspace URL’s after existing sites have been deleted and new sites created.

Solution: Perform a bulk publish of all projects.

To bulk publish the projects via PowerShell you can use the below script:

#Replace the highlighted text with the PWA URL and fully qualified domain name.

$svcPSProxy = New-WebServiceProxy -uri “https://PWA.com.au/PWA3/_vti_bin/PSI/Project.asmx?wsdl” -Credential “DomainName\PWAadminUserName”

$svcPSProxy

$EPMTYGUID = [system.guid]::empty

$ProjectList = $svcPSProxy.ReadProjectStatus(“$EPMTYGUID”,”WorkingStore”,””, “0”).Project | format-table proj_uid -hidetableheaders | out-string -stream

$ProjectList

foreach ($projectUid in $projectList)

{

                if ($projectUid -ne “”)

                {

$G = [System.Guid]::NewGuid()

$svcPSProxy.QueuePublish(“$G”, $projectUid, “true”,””)}}

An error has occurred during report processing

Environment: Project Server 2010, Report Server in Native mode

Background: Report throws a below error message when runs in the Report Manager. Refer the Snapshot below:

1

Solution:

The cause of an issue is that the password is incorrect or expired for the report reader account (‘DomainName\svc_aumhd_bas02_) configured in the report data source.

For example, we have refreshed the password for the data source (“PROD – WSS Reporting”) associated with the above report in the report server and it has fixed the issue. Enjoy!!

Active Users report Last Accessed

Environment: Project Server 2010, SQL Server 2008 R2, Business Intelligence Development Studio (BIDS)

Background: Client requested for a report requirement to find out the users those have connected/accessed the system in last 12 months or had not accessed more than 12 months.

Solution: Follow the below steps to develop the SSRS report. Please note we are hitting ProjectServer_Published DB in this report which is not supported by Microsoft. Please use it at your own risk.

a. Create the Shared Data source pointing to Project Server Published DB.

b. Create the report dataset with the name of ‘getResourcesAccessed’

–Fetch the Resources those have accessed in last 12 months.

Select

Res_Name as ResourcesName,

WRES_EMAIL as EmailID,

WRES_LAST_CONNECT_DATE as LastConnect,

RES_TYPE

from

dbo.MSP_RESOURCES

Where RES_TYPE Between 1 AND 19 –Filter the active resource who can logon to PWA

AND (WRES_LAST_CONNECT_DATE > Dateadd(yyyy, -1, getdate()) AND WRES_LAST_CONNECT_DATE is NOT NULL)

Order by WRES_LAST_CONNECT_DATE, RES_NAME

c. Create the second dataset called “GetResourcesNotAccessed”.

–Fetch the Resources those had not accessed in last 12 months.

Select

Res_Name as ResourcesName,

WRES_EMAIL as EmailID,

WRES_LAST_CONNECT_DATE as LastConnect,

RES_TYPE

from

dbo.MSP_RESOURCES

Where RES_TYPE Between 1 AND 19 –Filter the active resource who can logon to PWA

AND (WRES_LAST_CONNECT_DATE <= Dateadd(yyyy, -1, getdate()) OR WRES_LAST_CONNECT_DATE is NULL) Order by WRES_LAST_CONNECT_DATE, RES_NAME

d. Create the Report Parameter as per below snapshot:

d

 

e. Specify the default value of the report parameter as per below snapshot:

e

f. Add the two tables in the report design mode. The next step is to associate the datasets created in step b and c then add the fields in both table. Refer the snapshot below:

f

g. Set the Visibility expression for the table associated with the datasource “getResourcesNotAccessed”.

g

h. Set the Visibility expression for other table associated with the datasource “getResourcesAccessed”.

h

I. Now your report is ready to use. Bingo!!

i

 

 

Archive a Look-up table old values

Environment: Project Server 2010/2013

Background: Customer has a large list of account code in the look-up table – some are current and some every old. Users were complaining that they needed to scan a long list of expired values before finding valid options.

Solution:

As there is no out of the box option available to archive the values of the lookup table, we suggest you create one level hierarchy with the name ‘Do not Use’ and indent the Account code values which is very old.

This results in retaining the old account code values for existing projects and means users don’t need to scan these old when looking to select a current value.

Let us know if you know any other better solution.

Hope this helps you.

 

 

Project Archive/Hide in Project Center

Environment: Project Server 2007, Project Server 2010, Project Server 2013

Solution:

There are two options to hide projects in the project center as per below:

Option 1: Set the project filter for the project center views based on enterprise custom field. For instance, custom field has following values – Archived, Live, On-hold.

Below are the steps to hide the projects in a project center view:

a. Logon to Project Web App. Click on Server Settings > Manage Views > Click on Project Center View in which you don’t want to see the ‘Archived’ Projects. Refer snapshot below:

b2

b. Apply the filter using the Enterprise field in your environment. For example, we have used the ‘Project Status’ field as per below snapshot for the Project Center Summary view.

b3

 

 Option 2: Daily Schedule Back up/Administrative Back up

a. Configure the daily schedule back up or perform the Administrative Back up as per TechNet link below –

Daily Schedule Back-up       http://technet.microsoft.com/en-us/library/jj590896(v=office.15).aspx

Administrative Back-up     http://technet.microsoft.com/en-us/library/dd207304(v=office.15).aspx

b. Make sure to validate the project availability in the archive database before you delete it. Steps as below –

Launch Project Web App > Server Settings > Administrative Restore

b4

c. Once you have confirmed the project availability in the Archived DB then you are ready to delete the project so that it won’t appear in the Project Center. Following are the steps:

Project Web App > Server Settings > Delete Enterprise Objects > Select the project you want to delete > Make sure the option ‘Delete the associated Microsoft SharePoint Foundation sites is not ticked.  Refer snapshot below:

 Note: In case you need to restore the deleted project in future if required then you can associate the existing Project site after restoring the Project. If you tick this option while deleting your project then the Project site will be deleted permanently as Daily Schedule back up/Administrative back doesn’t archive a Project site.

b5

Master projects and Views

Background: PM unable to view an individual projects that are also subprojects within a master project in the project center.

Solution –

Tick the option ‘Subprojects’ as per below snapshot. This will fix the issue.

b1

Hope this will save your couple of hours.