Sign in
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
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Popular Tags
Excel 2007 (2)
Excel Services (2)
MOSS (12)
Pages (2)
PerformancePoint (10)
Project Gemini (1)
SQL Analysis Services (17)
SQL Server Integration Services (7)
SQL Server Reporting Services (102)
Archive
Archives
July 2011
(1)
January 2011
(1)
August 2009
(1)
August 2008
(1)
July 2008
(1)
June 2008
(1)
May 2008
(6)
April 2008
(1)
March 2008
(1)
February 2008
(3)
January 2008
(1)
November 2007
(5)
October 2007
(3)
September 2007
(5)
August 2007
(1)
June 2007
(2)
May 2007
(5)
April 2007
(6)
March 2007
(1)
February 2007
(9)
January 2007
(7)
December 2006
(4)
November 2006
(5)
October 2006
(2)
September 2006
(1)
August 2006
(2)
July 2006
(6)
June 2006
(2)
May 2006
(1)
April 2006
(3)
March 2006
(9)
January 2006
(4)
December 2005
(6)
November 2005
(11)
September 2005
(5)
August 2005
(8)
July 2005
(13)
June 2005
(12)
MSDN Blogs
>
Russell Christopher's Semi-Useful BI Musings
Russell Christopher's Semi-Useful BI Musings
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Russell Christopher's Semi-Useful BI Musings
A new Tableau-focused blog: Tableau Love
Posted
over 3 years ago
by
Russell Christopher
1
Comments
Hanging up my blue badge and moving to Tableau Software. You can read about my adventures at the company and with the product at Tableau Love
Russell Christopher's Semi-Useful BI Musings
Russell Christopher's two websites
Posted
over 3 years ago
by
Russell Christopher
2
Comments
My Personal site is here http://russellchristopher.me The Business Intelligence site for Russell Christopher is here: http://performancepointblog.com
Russell Christopher's Semi-Useful BI Musings
SQL Server 2008 R2 CTP2 hits the streets and I am psyched!
Posted
over 5 years ago
by
Russell Christopher
1
Comments
http://performancepointblog.com/2009/08/omg-sql-server-2008-r2-ctp2-hits-the-streets/
Russell Christopher's Semi-Useful BI Musings
Where did the Reporting Services 2008 Add-in for SharePoint go?
Posted
over 6 years ago
by
Russell Christopher
4
Comments
http://performancepointblog.com/2008/08/where-did-the-reporting-services-2008-add-in-for-sharepoint-go/
Russell Christopher's Semi-Useful BI Musings
Proof positive that SSRS 2008 is superior to SSRS 2005
Posted
over 6 years ago
by
Russell Christopher
2
Comments
Cross posting again! http://performancepointblog.com/2008/07/proof-positive-that-ssrs-2008-is-superior-to-ssrs-2005/
Russell Christopher's Semi-Useful BI Musings
SQL Reporting Services: What does that “Thread pool pressure” warning mean?
Posted
over 6 years ago
by
Russell Christopher
0
Comments
Cross-posting: http://performancepointblog.com/2008/06/sql-reporting-services-what-does-that-thread-pool-pressure-warning-mean/
Russell Christopher's Semi-Useful BI Musings
Packing up and moving to performancepointblog.com
Posted
over 6 years ago
by
Russell Christopher
0
Comments
I had $140 burning a hole in my pocket and saw a great domain name was available, so I've purchased 2 years of hosting for the next incarnation of this blog - performancepointblog.com . The content will be similar to what you've seen here, but with a...
Russell Christopher's Semi-Useful BI Musings
Language Packs and the PerformancePoint add-in for Excel
Posted
over 6 years ago
by
Russell Christopher
3
Comments
Here’s an interesting behavior I saw being discussed that you may run into when launching the PPS add-in for Excel when you have (or not) language packs installed: The PerformancePoint Add-in for Excel could not be loaded. The language pack for the...
Russell Christopher's Semi-Useful BI Musings
Problems making web reference to ReportService2006: Unable to import operation "SetReportHistoryOptions"
Posted
over 6 years ago
by
Russell Christopher
2
Comments
Today I needed to write a bit of code to create a model on a SQL 2005 Report server which was running in Sharepoint integrated mode. Boy, what fun I had! After creating my web reference, I got this error: Custom tool error: Unable to import WebService...
Russell Christopher's Semi-Useful BI Musings
SQL Analysis Services error processing ROLAP partitions against Teradata
Posted
over 6 years ago
by
Russell Christopher
1
Comments
Today I was playing around with stacking SSAS on top of Teradata. Essentially I have AdventureWorks DW moved over into Teradata and I’m trying to build a dumbed-down version of the AdventureWorks cube against it. Things went fairly well while my partitions...
Russell Christopher's Semi-Useful BI Musings
PerformancePoint: Why can’t I see values for my KPI’s Actual and Target metrics in a scorecard?
Posted
over 6 years ago
by
Russell Christopher
0
Comments
While working on a KPI in PPS, I found that after binding an Actual and Target to my cube I couldn’t see values for these metrics after adding the KPI to Scorecard and updating. The indicator image these metrics showed was “No Data”. I broke out...
Russell Christopher's Semi-Useful BI Musings
Save your SSAS browser queries for re-use: new add-in
Posted
over 6 years ago
by
Russell Christopher
0
Comments
File this under "reclaim a few second of your life". If you build semi-complex pivots in the SSAS browser, you probably get annoyed when you have to rebuild them time and time again after you close the cube designer. Well, Yossi Elkayam has written the...
Russell Christopher's Semi-Useful BI Musings
Moving On…
Posted
over 6 years ago
by
Russell Christopher
1
Comments
Just a quick update on my status – as of 1-May, I’ll be changing my focus a bit. For the last 7-8 years, I’ve been an Application Development Consultant in the Services organization here at Microsoft. Well, on Thursday I’ll be moving over to the Communications...
Russell Christopher's Semi-Useful BI Musings
Fun displaying SSRS (integrated) reports using PerformancePoint SQL Server Report viewer
Posted
over 6 years ago
by
Russell Christopher
14
Comments
Disclaimer: the post below was written after 24+ hours traveling to India - I was pretty much (very much) out of my mind at the time... I just spent more than a few minutes messing around with the “SQL Server Report” report viewer in PerformancePoint...
Russell Christopher's Semi-Useful BI Musings
What I like about SQL Server 2008 Reporting Services: The Configuration Manager
Posted
over 6 years ago
by
Russell Christopher
1
Comments
I’ve been slacking a little bit in terms of blogging, but now that CTP6 is out with a bunch of new stuff I can “officially” talk about, I suspect I’ll be a bit more active. Today while building a VPC image of CTP6, it occurred to me how small improvements...
Russell Christopher's Semi-Useful BI Musings
SSRS File Share provider in a Workgroup
Posted
over 6 years ago
by
Russell Christopher
3
Comments
Today I was a lurker in a "news to me" conversation about the SSRS file share delivery provider – thought I’d pass this interesting (to me) tidbit along. When using the file share extension on a box which was NOT part of a domain, the user kept on...
Russell Christopher's Semi-Useful BI Musings
SQL Server 2-D Matrix Builder available on CodePlex
Posted
over 6 years ago
by
Russell Christopher
1
Comments
If you need to build a very complex query that returns a matrix with dynamic columns and rows from T-SQL, you might want to take a look at this new project posted on CodePlex : SQL Server 2-D Matrix Builder http://www.codeplex.com/SQL2DMatrixBuilder...
Russell Christopher's Semi-Useful BI Musings
RSPreviewPolicy.config: Change in behavior for BIDS 2008?
Posted
over 6 years ago
by
Russell Christopher
1
Comments
For those who play around with custom assemblies in SQL Reporting Services, it’s pretty common knowledge that it is not necessary to add a <CodeGroup> element for your custom assembly in RSPreviewPolicy.config in order to use it while previewing...
Russell Christopher's Semi-Useful BI Musings
What does an exported PerformancePoint scorecard look like in Reporting Services report designer?
Posted
over 7 years ago
by
Russell Christopher
1
Comments
I was curious what would happen when I opened an RDL file created by PerformancePoint in Report Designer, so I tried it. Here is what I discovered: 1. For whatever reason, PPS exports RDL using the SSRS 2000 RDL spec (xmlns= http://schemas.microsoft...
Russell Christopher's Semi-Useful BI Musings
Minor idiosyncrasy exporting a PerformancePoint Scorecard to SQL Reporting Services
Posted
over 7 years ago
by
Russell Christopher
1
Comments
Today I started playing around with the ability to export/deploy PPS scorecards to SSRS: It’s actually a pretty cool piece of work! I did run into one problem up which I’m documenting here to save someone else some time. I wanted to deploy my report...
Russell Christopher's Semi-Useful BI Musings
How to really, really remove PPS Dashboard Designer
Posted
over 7 years ago
by
Russell Christopher
1
Comments
The Microsoft Knowledge Base article 941749 explains (among other things) how to remove PerformancePoint Dashboard Designer. However, it appeared to me that the steps (“Method 1” and “Method 2”) were semi-cosmetic : We’re really not explicitly told how...
Russell Christopher's Semi-Useful BI Musings
Orcas/VS 2008 ReportViewer redist now available
Posted
over 7 years ago
by
Russell Christopher
1
Comments
A new version of the ReportViewer controls has been dropped for use w/ Orcas-created applications. From what I understand, you can also use these in 2005 as long as you remove the old 9.0 references and replace them with references to these brand-spanking...
Russell Christopher's Semi-Useful BI Musings
SQL Server 2008 "Katmai" CTP5 released
Posted
over 7 years ago
by
Russell Christopher
1
Comments
Just got an invite from Microsoft Connect to download the November CTP of SQL 2008....you can, too! http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=en
Russell Christopher's Semi-Useful BI Musings
Alerting without SQL Server Notification Services
Posted
over 7 years ago
by
Russell Christopher
5
Comments
Last week I worked with a customer who wanted to give users the ability to create and subscribe to alerts for changing KPI Values. This is a pretty standard scenario, and one we covered with BSM 2005. However, with the “loss” of Notification Services...
Russell Christopher's Semi-Useful BI Musings
Bad password trying to process an SSAS cube against Oracle
Posted
over 7 years ago
by
Russell Christopher
3
Comments
Shout-out to my homies Chris and Thanh. Depending on how you set up the impersonation settings on your Analysis Services cube’s data source to Oracle, you may run into the following error when trying to process: Login failure: Unknown username...
Page 1 of 7 (154 items)
1
2
3
4
5
»