I was working with a client recently and I was giving the typical demo of MOSS functionality. As I was showing off My Sites and the web parts available the client immediate asked about the ability to use KPIs. The idea that a user could have their personal start page that showed personal KPIs of the projects they were working on sounded fantastic! Right?
Not so fast. I agree that it is a great idea that would provide tons of value, but the truth is that the KPI web parts will not allow you to access a KPI List located in another site collection, let alone another web application (most companies put My Sites on their own web applications).
The rumor that this functionality will be available in future versions of the product, but until then we've got to be creative. I'm a huge fan of the KPI and BI tools available out of the box. Unfortunately, I don't think enough people are talking about them! C'mon people, these are the types of things senior management loves -- and who signs checks?? Senior management!
For one of my clients we integrated Project Server's task lists with a MOSS Intranet -- they are both built on WSS so it wasn't too bad. Then we used the KPI webparts to point to the task lists generated by Project Server. Now my question is, what is everyone else doing with the KPIs and other BI tools?