Use the QueryByCube IQueryable extension method and build an analysis engine (engine processing GroupBy + Aggregation) over your EntityFramework model. No need SSAS or any other expensive OLAP technology. Define your cube by pur C# lambda expressions. LIN