Articles:
1. Create OLAP Cube
2. CUBE Functions 4: Deconstructing the PivotTable
3. Creating data cubes with Excel and a database
4. Use MS Query to Treat ExcelAs a Relational Data Source
I have not yet found my prefered solution to create and maintain OLAP Cubes.
The process to create Cubes must be easy enough and update automatically or reguarly.
And the software must be Free of charge.
In the process I come across a few interesting alternatives:
OlapCube.com. This software does basically what MS Query could do previous to Excel 2007.
Google spreadsheets have started to cooperate with Panorama to deliver Pivottables for free and to be published on a website Panorama Analytics gadget. At the same time they offer a product called Cubeslice, but it is hard to tell if it's offered for free and exactly what it does.
Article: How to Use Google Spreadsheets for No-Cost Data Analytics
Blog
