I am currently working on a project where I will integrate PerformancePoint Server 2007 with SharePoint 2007 and use the SQL Reporting Services add-in for MOSS built-in rich capabilities to empower users to run reports based on deployed Data Models.  For a full list of benefits in using Integrated Mode, check out this post from the Microsoft SharePoint Team Blog

Problems I ran into while installing it

Reporting Services Section does not show up on the Central Admin
When installing Reporting Services add-in for SharePoint 2007 using Integrated Mode, I was not able to see the Reporting Services section on the Central Administration site.  I know I followed all steps and made sure I had all prerequisites. So why am I not able to see the new section on the Central Administration?

Easy, make sure the Feature is activated!

After you activate the Feature, you should see the Reporting Services section under Application Management on the Central Administration.

 

Get 401 Unauthorized when clicking on Set server defaults
Once I had the new Reporting Services section and clicked on Set server defaults, 401 Unauthorized message.  Long story short, apparently, Alternate Access Mappings are not supported!  Once I changed the url of my site to something like http://moss:8321 instead of a url like http://mysite.sharepointace.com it worked just fine. 

About PerformancePoint Server 2007

PerformancePoint 2007 is awesome, it comes with a tool called PerformancePoint Dashboard Designer which allows you to quickly build Scorecards, Dashboards, PKIs and more.  It generates Dashboard Pages which are just WebPart Pages in MOSS.  The one thing I found out about the WebParts it deploys, is that these are actually quite different than the SharePoint WebParts.

Currently, I have the challenge to figure out how to have multiple dashboard pages created with Dashboard Designer, and pass parameters to a page, so that I can filter the view.  I read that the PerformancePoint Dashboard Designer allows you to publish your dashboard to multiple pages and still be able to filter the other pages…

[UPDATE] If you have any functionality suggestions, please submit those via the CodePlex project site.  Or if you would like to take on enhancing it please let me know, I welcome the help :) 

Well, I finally got an opportunity to package this WebPart and make it available to the public.  There is definitely some work left, and it is an Alpha version.  The download includes the Visual Studio Solution, you can immediately build your WSP using cool tools like the WSPBuilder.

This WebPart allows you to display (you guessed it), recurring calendar events.  It also provides additional functionality. 

To learn more, go to the CodePlex workspace at http://www.codeplex.com/CQWPRCE
Enjoy!

Oscar

P.S.  I also welcome your feedback either via this blog entry, or the CodePlex project site url above!