Russell Christopher's Semi-Useful BI Musings
This blog contains random one-off solutions to various problems I've encountered while using Microsoft's Business Intelligence tools SQL Server 2005 / Katmai
A new Tableau-focused blog: Tableau Love
Hanging up my blue badge and moving to Tableau Software. You can read about my adventures at the...
Date: 07/20/2011
Russell Christopher's two websites
My Personal site is here https://russellchristopher.me The Business Intelligence site for Russell...
Date: 01/16/2011
SQL Server 2008 R2 CTP2 hits the streets and I am psyched!
https://performancepointblog.com/2009/08/omg-sql-server-2008-r2-ctp2-hits-the-streets/
Date: 08/11/2009
Where did the Reporting Services 2008 Add-in for SharePoint go?
Date: 08/07/2008
Proof positive that SSRS 2008 is superior to SSRS 2005
Cross posting again!...
Date: 07/09/2008
SQL Reporting Services: What does that “Thread pool pressure” warning mean?
Cross-posting:...
Date: 06/17/2008
Language Packs and the PerformancePoint add-in for Excel
Here’s an interesting behavior I saw being discussed that you may run into when launching the PPS...
Date: 05/18/2008
Problems making web reference to ReportService2006: Unable to import operation "SetReportHistoryOptions"
Today I needed to write a bit of code to create a model on a SQL 2005 Report server which was...
Date: 05/15/2008
SQL Analysis Services error processing ROLAP partitions against Teradata
Today I was playing around with stacking SSAS on top of Teradata. Essentially I have AdventureWorks...
Date: 05/12/2008
PerformancePoint: Why can’t I see values for my KPI’s Actual and Target metrics in a scorecard?
While working on a KPI in PPS, I found that after binding an Actual and Target to my cube I couldn’t...
Date: 05/08/2008
Save your SSAS browser queries for re-use: new add-in
File this under "reclaim a few second of your life". If you build semi-complex pivots in the SSAS...
Date: 05/06/2008
Moving On…
Just a quick update on my status – as of 1-May, I’ll be changing my focus a bit. For the last 7-8...
Date: 04/29/2008
Fun displaying SSRS (integrated) reports using PerformancePoint SQL Server Report viewer
Disclaimer: the post below was written after 24+ hours traveling to India - I was pretty much (very...
Date: 03/02/2008
What I like about SQL Server 2008 Reporting Services: The Configuration Manager
I’ve been slacking a little bit in terms of blogging, but now that CTP6 is out with a bunch of new...
Date: 02/28/2008
SSRS File Share provider in a Workgroup
Today I was a lurker in a "news to me" conversation about the SSRS file share delivery provider –...
Date: 02/27/2008
SQL Server 2-D Matrix Builder available on CodePlex
If you need to build a very complex query that returns a matrix with dynamic columns and rows from...
Date: 02/16/2008
RSPreviewPolicy.config: Change in behavior for BIDS 2008?
For those who play around with custom assemblies in SQL Reporting Services, it’s pretty common...
Date: 01/31/2008
What does an exported PerformancePoint scorecard look like in Reporting Services report designer?
I was curious what would happen when I opened an RDL file created by PerformancePoint in Report...
Date: 11/28/2007
Minor idiosyncrasy exporting a PerformancePoint Scorecard to SQL Reporting Services
Today I started playing around with the ability to export/deploy PPS scorecards to SSRS: It’s...
Date: 11/28/2007
How to really, really remove PPS Dashboard Designer
The Microsoft Knowledge Base article 941749 explains (among other things) how to remove...
Date: 11/27/2007
Orcas/VS 2008 ReportViewer redist now available
A new version of the ReportViewer controls has been dropped for use w/ Orcas-created applications....
Date: 11/26/2007
SQL Server 2008 "Katmai" CTP5 released
Just got an invite from Microsoft Connect to download the November CTP of SQL 2008....you can, too!...
Date: 11/19/2007
Alerting without SQL Server Notification Services
Last week I worked with a customer who wanted to give users the ability to create and subscribe to...
Date: 10/24/2007
Bad password trying to process an SSAS cube against Oracle
Shout-out to my homies Chris and Thanh. Depending on how you set up the impersonation settings on...
Date: 10/19/2007
SAP buys Business Objects
https://www.msnbc.msn.com/id/21182779/
Date: 10/08/2007
PerformancePoint Server 2007 Ships! (as in, you can download it)
Last week I got all excited when I saw that PPS had launched - only to discover "launch" was really...
Date: 09/26/2007
Dell and Microsoft engineer BI offering
Today at SQL PASS, Dell and Microsoft announced a new set of Business Intelligence and Data...
Date: 09/20/2007
Mosha Pasumansky releases new Analysis Services MDX tool
Mosha just announced the availability of a new tool he wrote called MDX Studio: MDX Studio is tool...
Date: 09/19/2007
At SQL PASS? Don't miss these sessions!
Right now I'm in Ocean Shores, WA for team meetings, so I won't be attending SQL PASS. However, if I...
Date: 09/18/2007
File under: Cool feature in Reporting Services editor I never knew existed
It's been, what - 3 years? 4 years? since Reporting Services was released and I JUST stumbled upon...
Date: 09/05/2007
Hot off the presses: resolving MDX query performance bottlenecks
Carl Rabler et al have just released a really nice looking best practives article on how to resolve...
Date: 08/29/2007
AMO Error when adding an attribute to an existing dimension: The transaction cannot be committed because one or more objects were invalidated during the transaction
Today’s tale from the front: I needed to write some POC code and kept on running into the error...
Date: 06/14/2007
Microsoft acquires Dundas’s data visualization components, SQL 2008 news & download CTP3!
This morning @ TechEd, Microsoft announced that we’ve purchased Dundas’s data visualization...
Date: 06/04/2007
Holy Snikes the Dundas OLAP Services stuff is nice!
Looking for different ways to allow users to browse your cubes? Dundas has an online demo of their...
Date: 05/31/2007
OfficeWriter functionality could be included in Katmai
It's time for our own press release now, thank you! In the link below, you'll see that today Jeff...
Date: 05/09/2007
SAP Acquires OutlookSoft
What's up with that?! This week is supposed to be all about Microsoft and our BI conference. This is...
Date: 05/09/2007
How do you set “(Select All)” as the default for multi-value parameters in Reporting Services?
The short answer is that you can’t, although there is a workaround. Essentially, “(Select All)” as...
Date: 05/07/2007
MDX Script Performance Analyser on CodePlex
I forgot about this one - Chris "Master Chief of MDX" Webb is among the contributors to the MDX...
Date: 04/25/2007
SQL Analysis Services Load Simulator released on CodePlex
Just a little while ago ASLoadSim was realeased on CodePlex. It "...contains a set of utilities used...
Date: 04/20/2007
PPS CTP2 VPC now available, too!
Last week I mentioned that PerformacePoint CTP2 was ready for download...
Date: 04/17/2007
First Cumulative Update for SQL Server2 2005 SP2 Released
This doesn't have much to do with BI per se, but is interesting nonetheless - Looks like the SQL...
Date: 04/17/2007
The curious saga of “(Select All)” and multi-valued parameters in Reporting Services
The back- story: Once upon a time, when Reporting Services 2005 was just barely gold, one was able...
Date: 04/09/2007
PerformancePoint CTP2 now available for download
CTP2 was just released, and can be downloaded at Microsoft Connect...
Date: 04/04/2007
New SQL Server Reporting Services Guided Tours
A set of 5 guided tours around Reporting Services have recently been created and are available...
Date: 03/30/2007
How to use URL Access in Reporting Services SharePoint integration mode
URL Access still works if you’ve put your SSRS instance into MOSS integration mode, it just takes a...
Date: 02/24/2007
Installing SSRS (via SQL Server Express Advanced Edition) on Vista 64-bit
I saw an interesting thread on this topic earlier last night, and I thought I’d pass along the...
Date: 02/22/2007
Using the “old” Reporting Services web parts in MOSS 2007
(Thanks to Carolyn Chau) If necessary, you can use the old SSRS web parts we provide in Reporting...
Date: 02/20/2007
SQL 2005 SP2 most likely available this Monday, 2/19
Get ready to download, because SP 2 was declared "ready to ship" last night. The SQL team is hoping...
Date: 02/16/2007