Business Intelligence Use Case Scenarios
Now that you’ve had a chance to understand the vast array of BI features—both those built into SharePoint Server 2007 and those additional BI products that can be integrated into SharePoint Server 2007 for enhanced data analysis and reporting—let’s consider which features you should use in specific scenarios and how to use them properly.
Note
The following recommendations do not include programmable solutions, such as using the SharePoint Server 2007 SDK or other XML/Web service–based solutions.
Scenario I. I have existing Reporting Services reports I want to have exposed in SharePoint Server 2007.
How you do this depends on your existing SQL Server version. If you are running SQL Server 2005 Service Pack 2, ...
Get Microsoft® Office SharePoint® Server 2007 Best Practices now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
