Changing #SharePoint Central Admin Regional Settings stops the #PowerPivot Dashboard timer job #SP2013 #PS2013

Take care when updating the Central Admin regional settings as certain things stop working. The link to update the region settings doesn't exist on the Site Settings menu probably for this reason but you can type the URL manually and access the page. Just add _layouts/15/regionalsetng.aspx to the URL. Central Admin region settings were updated...

#ProjectServer #PS2013 / #SharePoint #SP2013 site template issue

When creating new site templates in SharePoint 2013, ensure you check the box to include content. If you don’t do this, any sites created from your new template will have the “Change the look” functionality missing, it will load a blank page as shown below: To resolve this, include the content when saving the new...

#ProjectServer #PS2013 #Excel Pivot Table limitation

Just a quick post to highlight a limitation / issue with Excel Pivot Tables that I hadn’t seen before, details below. This particular Pivot Table uses a Data Model that contains two OData feeds from Project Server 2013, one for Project details and one for Task details. The connections can been seen below: The relationship...

#ProjectServer 2010 field calculation in PWA #PS2010 #MSProject #SP2010

A quick blog post to highlight an issue and workaround for editing plans in PWA when using custom fields that use the inbuilt fields. This post uses Finish Variance as an example. The Finish Variance field doesn't recalculate in PWA after making edits to plans, this only updates after changes in Project Pro. This post...

#SharePoint 2010 error setting PerformancePoint unattended account #SP2010 #PS2010 #HP

A short blog post to highlight a workaround to a recent issue we experienced on a Project Server 2010 deployment. When trying to set the PerformancePoint unattended account we received an error: The account credentials for the Unattended Service Account are not valid. Verify the domain user name and password are correct and that the...

Update #SharePoint list item author and editor #SP2010 #PowerShell #PS2010 #SSRS

Recently while working on a client deployment we had an issue relinking the SSRS reports to the data sources within the same library – SSRS was in SharePoint integrated mode. We had developed the Project Server solution internally and migrated it to the clients environment at a later date. All worked as expected apart from...

#ProjectServer 2013 ribbon in different browsers with different zoom levels #PS2013 #SP2013

A quick post just to highlight how different browsers will render the ribbon differently based on the zoom level of the session. Some examples below to show the differences between IE 9 and Chrome version 26. At the default 100% all browsers render the ribbon identically. All pages / ribbons are affected. IE 9 –...

#SharePoint 2010 Missing Server side dependencies Central Admin Help site orphaned #SP2010 #PS2010 #PowerShell

Whilst working on a client site today to deploy the June 2012 CU to their SharePoint / Project Server 2010 farm I came across an issue in the pre-update health check. The issue was identified by the SharePoint health analyser as Missing server side dependencies. This particular missing dependency was an orphaned site in the...

Some #ProjectServer default fields not in the Reporting Database #PS2010 #MSProject #SP2010

Not all default fields are available in the Project Server Reporting database, for example the Contact and Resume fields. To be able to easily include these fields in reports using direct T-SQL you will need to get the values for these fields in the Project Server Reporting database. The easiest was to achieve this is...

#ProjectServer 2010 Resource assignment behaviour when adding another resource to an existing task with a Generic Resource #PS2010 #MSProject #EPM

Recently an issue came up at a client where they would get “Unknown Resource” error pop up when adding a second resource to a task using the Resources Tab on the Task Information dialog box in Project Professional. It is probably easier to explain the issue by showing the repro steps below. Firstly create a...