Posted by Russell on September - 18 - 2009
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 ]
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
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
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:
Posted by Russell on March - 13 - 2009
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
Posted by Russell on March - 11 - 2009
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
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
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
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/
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