This might be a strange topic given that the release of SharePoint 2010 is just around the corner, but I wanted to respond to a couple of questions and debates I have been involved with in my temporary role in the partner team.
I would like to start by going back to the early days of Microsoft BI, analysis services (and OLAP services before it) were just getting established but there was no analysis services client from Microsoft to give users full access to the cubes in analysis services. There were two third party contenders out there Panorama NovaView and ProClarity. These were both web clients and as they evolved they both developed portals form which reports and content could be accessed and changed. They also had security baked into them on top of what was in analysis services itself. ProClarity was acquired by Microsoft and the descendants visualisations in that tool (such as the decomposition tree) are now in SharePoint 2010 enterprise.
Panorama continues to be a Microsoft partner and is a good choice for business who just want a web client to get at their analysis services cubes, or even to get more functionality out of PowerPivot. They also continue to have their own portal or can integrate with SharePoint as desired. There also another 40+ products form partners out there which also provide web access to cubes, and here is a good a list as I’ve found of them
The other key Microsoft BI offering is reporting services which either has its own portal complete with security (Report Manager) or can be integrated into SharePoint.
So you don’t have to use SharePoint to provide Microsoft based BI to your users, but I would submit you are going to need some sort of portal, even if this is just a set of web pages where users can see content they are allowed to see and add more content to it (again subject to security).
However if you want to provide access to reporting and analytics to your users then SharePoint or a similar dedicated portal would be a better option as you can then provide a single point of entry and a single security mechanism to control access to BI.
On the question of cost you could just use SharePoint Foundation (the successor to Windows SharePoint Services), and SQL Server Standard edition, this would give you reporting services integration, and the other key parts of the Microsoft BI stack (analysis services and integration services). However you won’t get the performance point monitoring and analytics (which is in SharePoint enterprise) so the money you save by doing this must be off set against the need to buy a third party tool (like those I have listed above) to replace this functionality. You might not actually save any money and the solution could be more complex, but it might be exactly what your users need. This is a good thing, both for business and for Microsoft:
What I would suggest is to at least have a look at SharePoint 2010 as it’s scarily easy to set up and use even for this old DBA.
Thanks for sharing this insight and info. I was not aware of Sharepoint Foundation, and came to learn about it from this article. I intend to soon blog about it :)
good article. I think it's important to remember that many people are still using WSS 3.0 and SQL 2005. For those folks, the decision to 'go SharePoint' feels like a strategic thing which requires much evaluation.
The approach you describe can be pitched as a no-cost 'proof of concept'. Further, when combined with the new Dundas widgets in SSRS 2008 can be a real eye-opener to people used to bulky report listings.
It just requires a bit of initiative.
Cheers, Donna Kelly
What about Excel for accessing the Cube, this does not 'need' Sharepoint.
and most of my users have it on thier desktop and 'know' how to use it.
Of course you are right Excel is a very good cube browser. However what I should have made clearer in this post was that I was looking at web based tools, whihc is why I didn't mention it.
apologies for the confusion,