As far as I know, the SQL Server Analysis Service (SSAS) is NOT supported by SQL Server Express Edition (2005/2008/2008R2). Does anyone know if there is any third party SSAS equivalent component / service / system (free or commercial) that does the same job?
Many thanks.
You've several Olap servers in the market, check the wikipage : OLAP Server comparison
Amongs them you've icCube as a In-Memory OLAP server with a community edition. If you ever wonder about what is going on behind an MDX query do not miss the MDX Debugger and Profiler