Can I build a business-grade OLAP cube using Microsoft Access?
I’m pretty familiar with relational databases. I’ve built them, normalized data, etc. But what about OLAP? Can I do this with Microsoft Access?
Perhaps you already know that you can create multi-dimensional views of the data for your users by using the crosstab query (SQL Transform). True, this isn’t strictly speaking OLAP because it’s not "OnLine" or user rotatable/customizable.
However, if you can anticipate the range of multi-dimensional views that make sense from the data, then you can create any view with any crosstab query. That view can then be used as a subquery or a form/report record source.
Regards.