Sharing SSAS cube data in SharePoint with PerformancePoint Server 2007

Let's say you've just spent many hours designing a SQL Server 2005 Analysis Services (SSAS) unified dimensional model for the sales managers in your company, perhaps even with complex formulas from financial planners incorporated. For business intelligence (BI) professionals, the most important aspect is how to make the knowledge and information relevant to the business in a visible and easily consumable fashion.

This tip walks you through the process of taking a cube created in SSAS 2005 and sharing the related reports and scorecards in a cohesive dashboard application that can be easily published enterprise-wide through Microsoft SharePoint.

Read more...