Monday, 1 September 2014

Project Online 2013 Built-in reporting Issues with Refreshing

We have been deploying quite a few project Online Deployments for clients of ours. One of the things that I have noticed (Among others) is the fact that there seem to be a random issue with the Built-in Reports from time to time, after initial deployment.

When a user, that has the appropriate permissions try to refresh anyone of the 3 default reports :
  • Project Overview Dashboard 
  • Project Overview
  • Resource Overview
The refreshing fails as per image below :

Refreshing Report Fails

What I did to resolve the issue is to Edit the report in excel, go to the Data Tab, then click on connections, which will open the data connections Window, similar to the window below. Click on each of the connections and the on refresh. It will refresh the connection, and in some cases if there are data, you will start seeing the data in the report. Do this for all connections and lastly SAVE the Report back to the server.
Once that has been done, close the report in the Excel Online viewer and re-open the report and the refreshing should then work.
If you have any questions please let me know.



Thursday, 26 June 2014

Free Training Material on Project 2013

Project 2013 Webinar Videos:


  • Getting Started with Project 2013 (Watch here)
    • In this 15 minute webinar, you’ll learn the very basics: adding tasks and linking tasks. You’ll also learn how to add holidays to the project calendar so that you can plan for days off.
  • Assigning Resources in Project (Watch here)
    • In this webinar, we'll assign people to tasks and use the Resource Sheet to track people in your project. Plus, we'll learn how to add vacation days--and adjust the project accordingly so that we make our deadline.
  • Create a Timeline in project 2013 (Watch here)
    • This webinar will get your project ready for kickoff. You’ll learn how to make milestones, summary tasks, and subtasks. Plus, we’ll show you how to create a graphical timeline you can share with stakeholders.
  • Tracking Progress in Project 2013 (Watch here)
    • This webinar tutorial will show you how to track progress once a project starts. We’ll show you how to mark tasks complete, and we’ll run some reports that can give you an idea of what’s on time and what’s not. We’ll also explain a couple of key concepts on the way too: critical tasks and baselines.


  • Make the switch to Project 2013 (Watch here)
    • Watch these videos to make the switch to Project 2013. Get started with the new version to see how to do everyday tasks.

And on the lighter side of things :

  • It's so easy an 6th grader can do it (Watch here)


Thursday, 30 May 2013

SharePoint 2013 Pre-requisites (AppFabric)

Project Server 2013 Installation - Issues with AppFabric Pre-Req.

Aaaaargg!!! Microsoft AppFabric !!! Took me a whole morning to get the Pre-Req's Installed on an Offline 2012 Server. (Offline meaning not connected to internet to download the Pre-Req's as part of the Install of SharePoint 2013) 

So with Project Server 2010 all we needed to do was to download all the Pre-Req's and install them one by one. This always worked. Now with SP 2013 this does not seem to be the case with all the items, especially AppFabric, as there are configuration that should be done as part of the Install of the Appfabric Pre-Req. 

Managed to eventually find a Script by Craig Lussier ( to help me to get the Pre-Req's for SharePoint 2013 installed. Find these scripts here.

Please note: I do not own these scripts. Please have a look at the Authors blog, quite a bit of valuable resources on there.

Monday, 13 May 2013

Why Project Server Implementations Fail

So many times i have been asked the question : Why do some Project Server implementations fails at a client ? or why did it only last a few months before it became a white elephant ?

We have had support calls from clients where they wish to "resurrect" the implementation, that was done a year or two again. Just to come on-site to find out someone has formatted the server and re-allocated it to another application ! Which I'm sure it's normal IT practice but, no one new about it for about a year that the server is off. Only when a new person started in the PMO he wanted to use a tool, but the tool was not there.

I have a done a bit of research on why Project Server Implementations fails and have spoken to may people that i work with on what caused things to go south. I will try to highlight them below in a manner that makes sense to all.
  1. Scoping of the Project not done properly, when requirement workshops starts everybody is amazed at how much work is actually involved
  2. Buy in from Senior Stakeholders is a key success factor for a successful deployment. How do you drive the adoption of a new tool from the bottom up?? That will simply not work. I have dealt with clients where executives had come to a point, after numerous change management processes, training, begging and pleading, came to a point where the users KPA's and KPI's are influenced by participation of the system. Unfortunate, but a reality. But today 8 years on Project Server works like a dream in the same said organization, having upgraded from 2003 to 2007 and then to 2010.
  3. Buy in from "the rest of the community" In some cases too little focus is on the general community and too much focus on executives and Senior Personnel. By not letting them know the benefits and how it can make their work better, you actually just aggravates them. I have had Project Managers tell me that this new system will not be used and that they will use "Offline" scheduling to plan and track their projects, as they feel the "Visibility" makes them vulnerable. 
  4. Change Management - So many organisations thinks by telling resources to use a new system is classified as change management.  User training is NOT the only aspect of change management. In some cases management seem to think that change is driven from the bottom up and not from the Top downwards. This tool as with any other Enterprise tool requires an amount of change management.
  5. Thinking the Tool will define a process. The tool is supposed to support a properly defined process, not the other way around. If there is no governance or processes in place, many clients think this tool will now "Make it all better" 
  6. Overestimating Maturity. Many organisations when asked the question "On a scale of 1-5, how mature are you. The general response is: "We are at least a 4!" In 95% of these cases a 2 on that same scale is an overkill. Once you are a in workshop and you start asking about base-lining procedures and the response is "We don't set baselines on schedules" but they are still trying to manage things like "Planned vs. Actual" and in some or other way try to actually report against that!! 
  7.  Over complication of the Configured Solution. Many clients wants to have a solution that is so complex and can do so many things that the basics are forgotten about. Having a large complex solution that no one understands just adds to the end user frustration.
  8. People overestimating the Project Professional skills. So many people think they know Microsoft Project, having worked in a stand alone environment for years. Once a Project Server is installed that picture changes significantly. There are added complexities, and a heap of new functions to use.
  9.  Customers don't follow advice. Most reputable implementation partners have done this for a number of years and all of them have "War Stories" to tell. Clients take that lightly and does not listen to advise or suggestions given. We have a very good idea of what will and what wont work!! Trust us.
  10.  Cutting Training. Allot of clients think by cutting training from the deployment they will save time and money, when in fact what happens is is costs more and the learning and adoption curve is so much longer. In my humble opinion this is one of the most dangerous things to do. And i am sure some implementation partners will hang me for saying, that some Partners Allow clients to cut training so that they still get the business.
  11. Infrastructure cost and or complexity. Allot of the smaller clients tend to underestimate the complexity of n proper designed Infrastructure. Most of them do not want nor understand the need of a Development environment. 
Adeline Cruywagen - TPG Africa 
Shimone Bezuidenhoud - TPG Africa
Christhoper Pond - TPG UK
Rob Carswell - TPG Africa
Nico Oosthuysen - TPG Africa

Tuesday, 8 January 2013

TPG PSLink For integration bewteen PWA and SAP

TPG PSLink is a SAP-certified product for a bidirectional data exchange between Microsoft Project and SAP. Its extensive checking mechanisms ensure the complete consistency of all data shared between the two systems at all times. The product is very flexible for use in a range of different scenarios with extensive configuration options, which offer you an unrivaled rapid implementation time – even if the SAP PS module has not been implemented.
A difference analysis shows you the changes in the data before they are written to the other system – and only these changes are transferred. This is what makes TPG PSLink so unique, compared to other solutions.

Look here for more info

If you would like to know more please do not hesitate to contact me.