Monday, October 12, 2015

Project Server 2013 and manually entered baselines not saving to database

**Quick publish article.  Further tests follow**
**Update:  Only appears to apply to on-premise installs.  Project Online is unaffected**

Issue:  When manually editing Baseline(0-10) timephased data via task usage in MS Project Client, data is not saved to database.

Tested on:  SEPT 2015 PU (Server and Client)

Prep:
-------------------------------------------------------
Create a project with one task on it.  
add a resource from pool and assign to the task at 100%
Set Baseline (0)
Publish plan

Test:  Query DB and see timephased data populated correctly



Issue 1 Repro
-------------------------------------------------------
Edit Baseline Work values in Task Usage view
Save and Publish

Test:  Query DB and see timephased data is not changed



Issue 2 Repro
-------------------------------------------------------
Add Baseline 10 to task usage view
Manually enter values into timephased cells for Baseline10
Save and Publish

Test:  Query DB and see timephased data is not changed




Issue 3 Repro
-------------------------------------------------------
Close MSP file
Remove from Cache
open file

Test:  See that previously edited values in Baseline 0 and Baseline 10 are missing.  Original Baseline data (set using Set Baseline) is displayed


Summary findings
-------------------------------------------------------
It looks like manually edited baseline values are not moving from Cache to Database on Save and therefore the reporting db isnt being updated.




SQL Script for test:
-------------------------------------------------------

--Baseline 0
SELECT         b.TimeByDay, b.AssignmentBaselineWork
FROM (SELECT * FROM MSP_EpmProject WHERE ProjectName = 't1bltest') P
INNER JOIN MSP_EpmAssignment A 
         on           p.projectuid = a.projectuid
INNER JOIN MSP_EpmAssignmentBaselineByDay B 
         on           a.AssignmentUID = b.AssignmentUID
WHERE          b.BaselineNumber = 0

--Baseline 10:
SELECT         b.TimeByDay, b.AssignmentBaselineWork
FROM (SELECT * FROM MSP_EpmProject WHERE ProjectName = 't1bltest') P
INNER JOIN MSP_EpmAssignment A 
         on           p.projectuid = a.projectuid
INNER JOIN MSP_EpmAssignmentBaselineByDay B 
         on           a.AssignmentUID = b.AssignmentUID
WHERE          b.BaselineNumber = 10

Wednesday, June 24, 2015

This workbook contains external data connections or BI features that are not supported #projectonline

Just came across the joys of "enable/disable preview features" in office 365 SharePoint Admin.

My users were reporting that they were unable to refresh published Project Online reports in their browser.  They received the following message:

                      This workbook contains external data connections or BI features that are not supported.

The issue was caused by a setting in the SharePoint Online Admin Portal (Admin | SharePoint | Settings).  

Selecting Enable Preview Features (see below) allows users to refresh Project Online Reports using oData feeds in their browser.  

As a reminder, the following two elements also need enabling if you haven't done so already:


user group permissions:


Site collection features: 

Monday, June 15, 2015

TPG Apps Highlights - Risk Matrix #projectonline #projectserver #risk

This post is the first of a series to highlight the apps available for Project Server and Project Online from the SharePoint store  (https://store.office.com/search.aspx?productgroup=SharePoint&qu=tpg) and direct via your local TPG office.

The first of this series will look at the simple plug-and-play apps that all users of Project Online can make use of quickly and easily.  These are:
  • Risk Matrix 
  • Milestone Trend Analysis (MTA)
  • WBS Chart viewer

Next we will focus on the challenge of Resource Request Supply and Demand by demonstrating our more recent TeamLink and TeamManager apps.
  • Team Manager App is a Resource Manager/Owner app for allocating resource supply to Projects and BAU activities and monitoring demands against commitments
  • Team Link App is a PM tool for monitoring Project demands vs the supply provided by the Resource Managers 

Finally I will highlight some of the benefits of our integration tools when used in the context of Project Online
  • ResourceLink for the synchronisation of resources, custom fields and custom field values between your on-premise data sources and Project Online.
  • PSLink for transactional input/outputs from your on-premise data to Project Online 


So... here is part one of (many)....

Risk Matrix

TPG's Risk Matrix provides a quick and simple mechanism for aggregating and displaying project risks in a 5x5 matrix.

The app can be embedded either on a Project PDP, a Project Site Page or Homepage, or even viewed as a site level app where you can manually select the Project to interrogate (see below for screenshots).

 PDP embedded


PWA Site-level project selection

PWA Site-level project display

Project Site-level embedded on homepage.

Thursday, June 4, 2015

Project Online "upgrade" #projectonline #iconmadness

Looks like the peeps over in Redmond have been busy making some changes to the Project Online UI

I get the feeling they're not quite finished yet as the icons have gone crazy!!