OLAP on SQL Express

stevenrcfox picture stevenrcfox · Sep 16, 2010 · Viewed 7.5k times · Source

I'm wondering if there is any desktop OLAP solution that can use SQL Express (and therefore does not require Analysis Services)

I've been tasked with finding a way to allow our customers to do 'Ad-Hoc' reports, but the vast majority of them are on Sql Express, In previous jobs, customers have had Analysis Services and typically Cognos or Crystal Reports, so all that was required was to design the cube.

Answer

JumpingJezza picture JumpingJezza · Sep 16, 2010

SQL Express is pretty limited, I don't know of any OLAP capabilities.

Although, we use DevExpress OLAP Pivot Grid with ROLAP to get around this problem.

Just create a cube-like SQL query and plug it in.

SELECT productname, reasonforsale, salestotal
  FROM orderdetail