Category Archives: SharePoint

Fixing SharePoint Sync Errors in Project Server 2010

Posted on April 1, 2013 by

Here’s a common issue I am finally getting around to blogging up: certain projects always seem to throw an error on Publish, specifically on the part of the Publish job where the Publish database data is pushed into the Reporting … Continue reading →

Posted in Admin, SharePoint | 5 Comments

Filtering Excel WebParts in Office 365 (Part 3)

Posted on December 6, 2012 by

Just wanted to close out this discussion with filtered Excel reports in Project Online with a last use case.  In yesterday’s post, I talked about how to create an automatically filtered project dashboard.  In this post, I’ll talk about another … Continue reading →

Posted in BI, Project Online, Reporting, SharePoint | Leave a comment

Filtering Excel WebParts in Office 365 (Part I)

Posted on December 4, 2012 by

Following Mike McLean and my triumphant debut as Project Server 2013 BI masters at the recent SharePoint conference, I wanted to document one of the demos – specifically the one where we filtered Excel reports automatically based on external parameters.  … Continue reading →

Posted in BI, Project Online, Reporting, SharePoint | Leave a comment

SharePoint Conference Project Server BI Linkfest

Posted on November 14, 2012 by

Thanks everyone for coming out to #SPC171 just now, where Microsoft’s Mike McLean and I skimmed a rock over what’s new in Project Server 2013 BI.  Looking for more?  Well, you came to the right place. As we mentioned, we’ve … Continue reading →

Posted in Admin, BI, Project Desktop, Reporting, Self Referential, SharePoint | 1 Comment

Returning Reporting Database Values in the Project Workspace

Posted on June 21, 2012 by

Just a quick add on to yesterday’s post on leveraging InfoPath to create automatically filtered PerformancePoint reports on PDPs.  I figured that I’d extend the same approach to the workspace. For the workspace, we can simply pull the URL of … Continue reading →

Posted in BI, InfoPath, Reporting, SharePoint | Tagged | 5 Comments

Adding Filtered Project Dashboards to PDPs (Part 2)

Posted on June 20, 2012 by

In this post, we’ll take that InfoPath form we created in the last post, add it to a PDP, and link it to a PerformancePoint report to create an automatically filtered project dashboard.  For what it’s worth, I know it … Continue reading →

Posted in BI, InfoPath, PDP, Reporting, SharePoint | Tagged , , | 3 Comments

Houston Techfest Coming Up on October 15th

Posted on September 19, 2011 by

In Houston and looking for some free SharePoint content?  Houston Techfest will be offering two SharePoint tracks at the all day free conference held over at U of H next month. http://www.houstontechfest.com/dotnetnuke/HoustonTechFest/Agenda/tabid/55/Default.aspx …also lots of other content for developers and … Continue reading →

Posted in Events, SharePoint | Tagged | Leave a comment

10 Things Project Server Admins Should Know About SharePoint

Posted on August 16, 2011 by

A couple of days ago, I posted on 10 Things SharePoint Admins should know about Project Server. That prompted SharePoint consultant Shane O’Hanlon (@GetOffMyPatch) to challenge me to list 10 Things Project Server Admins Should Know About SharePoint. Now, I … Continue reading →

Posted in Admin, SharePoint | 1 Comment

10 Things SharePoint Admins Should Know About Project Server

Posted on August 2, 2011 by

It’s a rite of passage within every Project Server implementation.  At some point, I sit down with the SharePoint administrator and brief them on what it is exactly that they’ve gotten into it – what exactly they’ll be supporting going … Continue reading →

Posted in Admin, SharePoint | 13 Comments

Surfacing Risk Data in an External List

Posted on July 22, 2011 by

…so now that we have a custom SQL view developed and that data is surfaced in the form of an External Content Type, let’s add it to our SharePoint site. Navigate to a SharePoint site, select the option to View … Continue reading →

Posted in BI, External Content Types, Reporting, SharePoint | Tagged , , , | 3 Comments