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 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.com/sqlserver/reporting/2003/10/reportdefinition). When you attempt to open the report up with BIDS, you’ll be prompted to…


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 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 to the root of my SSRS server’s home folder, as…


How to really, really remove PPS Dashboard Designer

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 to remove the actual bits from our machine. Step 4 of the article holds a clue: 4….


Orcas/VS 2008 ReportViewer redist now available

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-new beauties (your mileage may vary as I haven’t tried this myself). http://www.microsoft.com/downloads/details.aspx?FamilyID=cc96c246-61e5-4d9e-bb5f-416d75a1b9ef&displaylang=en


SQL Server 2008 "Katmai" CTP5 released

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


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 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 in SQL 2008, PerformancePoint server does not include alerting functionality out…


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 your Analysis Services cube’s data source to Oracle, you may run into the following error when trying to process:   Login failure: Unknown username or bad password.   If you bump into this, open up your data…


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 a marketing thing and there were no new bits to grab. Well, last night PerformancePoint actually shipped – And I have some links for you:  To see all the stuff you can download: http://www.microsoft.com/downloads/Browse.aspx?displaylang=en&productID=F52B1E9C-E169-4654-9A83-14A58A51C275 Eval…


Dell and Microsoft engineer BI offering

Today at SQL PASS, Dell and Microsoft announced a new set of Business Intelligence and Data Warehousing solutions. They include a stack of server hardware, storage arrays, operating system, database and analytics software, management and reporting tools. The entire solution is based on the hardware and software many customers are using right now. What is…