MOSS (SharePoint) – PerformancePoint Scorecard Comments (Annotations)

 

“Where are PerformancePoint ScoreCard comments stored and how can we access them?”

Last Tuesday evening I delivered a presentation, Summing up BI features in MOSS. There was a lot of discussion and questions around Reporting Services integration as well as PerformancePoint Server 2007 integration. One question asked was where comments (or annotations) added to scorecards via the browser and/or Dashboard Designer are stored, from the perspective of accessing and doing comment roll-ups (and no, it’s not a SharePoint list as someone suggested :-)). This is something I’ve also been pondering so jumped in earlier today to take a look. This post details my initial findings.

MOSS (SharePoint) – PerformancePoint Scorecard Comments (Annotations)

Interactive Developer Map

PerformancePoint sits smack dab in the middle of this map.  Coincidence or subliminal message?

Microsoft Office Interactive Developer Map

The Microsoft Office Interactive Developer Map is a Windows Presentation Foundation (WPF) application that helps developers visualize the different programs, servers, services, and tools that will help them build solutions. It allows them to drill down to each product and technology and learn about new features, objects, Web services, namespaces, and schemas required to extend Microsoft Office and build custom Office Business Applications (OBAs).

Interactive Developer Map

K2.net and MOSS Collaboration Distillery: MOSS 2007 Architecture and Performance Considerations

An excellent overview of Sharepoint & reporting/workflow tools and architecture.

After working with Excel Services, it appears to be great for hosting static and formula-driven Excel spreadsheets on the web, however programming it is a different story.  Don't expect it to web-ify your Excel LOB application.  Look for VSTO + VIsual Studio 2008.

I would focus on using Reporting Services + Proclarity + PerformancePoint as a BI solution with a lot of flexibility and room to grow.  Throw in some Analysis Services for some high-performance slicing and dicing.

3.2.1) Excel Services
This is quick overview of excel services however it Excel Services is not a robust tool. After reading the list of Unsupported Features in Excel Services you will find out it may not provide what is needed for Excel power users (macros are not supported). It would not be recommended to use Excel Services as a replacement for enterprise reporting platform while tools such as Performance Point Server are built for this. Understand its limitations before using it.

K2.net and MOSS Collaboration Distillery: MOSS 2007 Architecture and Performance Considerations