About the changes in PerformancePoint

If you haven’t heard, Microsoft has made changes to the PerformancePoint product alignment. Basically this means PPS no longer exists as a separate product – the dashboard and analytic (M/A) components are being folded into MOSS, while Planning is being “end of life”d. Effective (almost) immediately, if you own rights to PerformancePoint, you now get…

2

Pro PerformancePoint about to hit the shelves!

Well, it took the better part of a year, but my second book, Pro PerformancePoint Server 2007: Building Business Intelligence Solutions (Pro) (APress) should be rolling off the presses as you read this. It’s almost 500 pages, and I tried to cover Microsoft’s entire business intelligence “stack” – from SQL Server (Integration Services, Analysis Services,…

1

Dimension Security in SQL Server Analysis Services

I know, the mind boggles – a developer writing about security… While I was doing the research for this, I was startled by the number of articles on this topic that immediately talk about using MDX queries for dimension security. While MDX queries offer powerful fine-tuning capabilities for restricting access to data in Analysis Services,…

0

Scorecards - SharePoint, SQL Server, or PerformancePoint?

A few years ago, if you asked Microsoft how to build a scorecard, they may have shrugged. Then we released the “Business Scorecard Accelerator” – a free technology mainly designed to showcase SQL Server Analysis Services. It was so popular that Microsoft made a product out of it – Business Scorecard Manager 2005. While BSM…

5

SQL Server Analysis Services in ten minutes

Analysis Services has been part of SQL Server for a while, but it’s underappreciated by most. I’ve posted another video on Channel 9 to try to share what a powerful capability this is for understanding large volumes of aggregated data. More than just the simple demo (showing a cube, clicking through some dimensions, pulling the…

1