SQL 2005 Reporting Services add-in for MOSS 2007, PerformancePoint Server 2007 and MOSS 2007

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…