PerformancePoint Blog

A Blog about PerformancePoint and Microsoft BI technologies. Your host is Russell Christopher

On a fairly regular basis, customers I work with wonder out loud (read: gripe) why SSAS 2005 and 2008 don’t allow them to easily drill-down to the relational tables that back a cube using an action. SSAS 2000 did this nicely, but SQL Analysis Services 2005 and 2008 want to return rows from the cube vs. directly from the tables. There is a sort-of-but-not-too-painful workaround available which encompasses using ROLAP [ Read More ]

OMG! SQL Server 2008 R2 CTP2 hits the streets!

Posted by Russell on August - 11 - 2009

I’m giggling like a little girl because today (well, last night) CTP2 (also known as the “August CTP”) hits the streets. I jumped out to MSDN and TechNet and see subscribers will be able to download it today – I’m actually looking at the

Create Calculated Measures in Excel 2007

Posted by Russell on June - 29 - 2009

ProClarity users tend to miss the ability to create calculated measures when they first start experimenting with Excel-as-ProClarity-replacement. Fear no more! Tyler Chessman, another Microsoft Technical Specialist has created an add-in to allow y

Vanity vs. Actionable Metrics

Posted by Russell on May - 22 - 2009

I’m not a big fan of this guy, but a recent guest post was a great read. The author, Eric Ries essentially argues that if metrics you’re tracking aren’t actionable, they’re “vanity metrics” and not that useful:

Most people have discovered by now that in order to use Windows 2008 as a “client” in BI demonstrations that you need to install the “Desktop Experience” feature of the OS. Without it, you’ll have problems getting into SharePoint from Office. Du

I’m currently working on a project which leverages many PerformancePoint reports. The dashboards I’ve built use a fair number of analytic chart report objects on a single dashboard page  (at least 4, sometimes more).  When I ran many of these pag

Click Once Report Builder 2.0 now in SQL Server 2008 SP1 CTP

Posted by Russell on February - 27 - 2009

If you’ve been waiting for the Click Once version of Report Builder 2.0, your wait is over (as long as you don’t mind using non-RTM bits). The SP1 CTP will allow you to launch RB 1.0 or 2.0 as Click Once applications in both Native and MOSS integr

SQLCat strikes again! Hardcore SQL Analysis Services tuning aids

Posted by Russell on February - 6 - 2009

Carl Rabeler of the Microsoft SQLCat team has just released a really nice set of tools targeted at helping you analyze SSAS performance. You can read about it here: http://sqlcat.com/toolbox/archive/2009/02/05/a-solution-for-collecting-analysis

Where did Project REAL go?

Posted by Russell on January - 27 - 2009

For the past several months, Project Real got lost out on microsoft.com – those who wanted the whitepapers and/or samples were pretty much on their own. The materials have been restored and are now available at: http://www.microsoft.com/sql/bi/

My thoughts on PerformancePoint Planning’s sunset

Posted by Russell on January - 23 - 2009

As a BI Technical Specialist at Microsoft, PPS is (was?) my bread and butter – It’s how I eat. So the changes to the Microsoft’s strategy around the product hit pretty close to home for me. (What? You don’t know what they are? Go here.) And

  • RSS
  • Delicious
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Russell's About.Me Profile