SSRS 2008 Add-In for MOSS 2007

Quick one here…I was recently setting up a SSRS 2008 dev environment integrated with a MOSS 2007 dev environment and encountered some strange problems with the SSRS 2008 Add-In for SharePoint. Basically every time it would run and state the installation was “interrupted” and nothing was changed. To my frustration nothing appeared to be wrong with the MOSS or SSRS setups however I did notice an error in the event viewer related to access to the SQL Server database. It turns out that wasn’t the problem either. There seems to be an issue with the rsSharePoint[_x64].msi installer as mentioned in Prash’s blog here (http://blogs.msdn.com/prash/…)

To overcome this hurdle you must follow the following steps:

  1. Open a command prompt with “Run as Administrator…
  2. Run rsSharePoint.msi SKIPCA=1.
  3. Locate rsCustomAction.exe file on the file system. This file is copied to your computer by rsSharePoint.msi and is generally located in the C:\Users\YourUserName\AppData\Local\Temp directory.
  4. Run rsCustomAction.exe /i

You will see lots of messages similar to those below in the command window but it will eventually finish and you’re setup of the SSRS 2008 Add-In for your MOSS 2007 environment will be complete.

SSRS 2008 Add-In for MOSS 2007 Install

Hope this helps!

Microsoft Healthcare User Group Presentation

Me and Rick trying to decide who is going to try the mic first

Me and Rick trying to decide who is going to try the mic first

Wow, what a day yesterday. Gave a presentation at the Microsoft Healthcare User Group Conference with Rick Garcia of Methodist hospital to two completely packed rooms. Funny thing, Rick and I had no clue we were supposed to be using the microphones because there was another room full of attendees that obviously couldn’t hear us without them.

In the presentation Rick talked about how they, with the help of Courtyard Group, have reformed their Business Intelligence (BI) organization to be driven by the end-user versus by the IT team. This is key in all BI organizations as, it is not something that IT (in most cases) will truly understand usually.

When IT is the driver behind BI initiatives what I’ve found is that users will simply take the data that IT is providing them, import it into Excel or Access, and then build their own BI from it. This is bad. From an organizational standpiont you have a valuable resource spending time collecting, formatting, and organizing data (something much better handeled by IT when given proper requirements) rather than doing the true analysis. From an Business Continuity (BCP) standpoint you are also now subject to a single point of failure since the analyst will most likely save the reports to their desktop

My portion of the presentation covered the Microsoft Business Intelligence stack and how we are using that to help Methodists IT group focus more on delivering the analysis tools to the users rather than doing the reports themselves. This falls into that category of “BI for the masses” and helping create that reality where IT’s main focus is to integrate the systems and present the analytical tools to the business users to do the analysis. This is how I believe BI works best and provides the most value to an organization. Of course, all of this is delivered in SharePoint as this is where all end-users are being driven to store, manage, and find any and all information.

I am really excited about where Methodist is going with their Business Intelligence initiative and hope to follow up with some more great details at the next Microsoft Healthcare User Group Conference.

Cheers!
Ben

References:

MS HUG Breakout Sessions: http://www.mshug.org/events/exchange_Sept2009.aspx

Presentation Slides: http://www.mshug.org/docs/exhange2009/Garcia_LeveragingSharePointBI.pdf
Methodist Hospital System: http://www.methodisthealth.com
Courtyard Group: http://www.courtyard-group.com/
SharePoint360: http://sharepoint360.com

Excelsius and the MS BI Stack

Recently I was on a call with a client and one of their IT guys asked if the Microsoft Business Intelligence stack can do everything Exclesius can do. In short, the answer is sorta. Through reporting services the MS BI stack can provide similar functionality however, it cannot provide the flash animations you get in Excelsius. The good news is however, that Excelsius can use the MS BI stack as a source for its data. This means if a client has already invested in Excelsius they can still reap the benefits of using the Microsoft Business Intelligence stack and are not locked in to using Business Objects for their entire Business Intelligence platform. I have included some links below of Excelsius demo’s you can view if you’re unfamiliar. Hope this helps!

Excelsius Demos – link

Business Objects SharePoint Integration Options – PDF