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.
At Prospect360 UK we specialize in providing targeted data for all your marketing needs. We source and supply Business to Business (B2B) and
Business to Consumer (B2C) data for the purposes of telemarketing, mail shots, email broadcasts and SMS campaigns at prospect360.co.uk
The B2B sales cycle is complex with long lead times. Lead Creation develop & implement marketing strategies to shorten the sales cycle using Social Media.
Social Media always a good help the development and strategies works faster.
Simply want to say your article is as astounding. The clearness for your submit is simply spectacular and i can think you are a professional in this subject. Fine together with your permission allow me to grasp your feed to stay updated with drawing close post. Thanks a million and please carry on the gratifying work.