InstantCube demonstrates how to autogenerate SSAS cubes and the underlying relational database using a simple XML language for describing the cubes and dimensions. Works with SQL Server 2008 Analysis Services / Database Engine.

Problems processing your cubes? Make sure SSAS Service has read access to your SQL Database and that you have enabled TCP/IP connections to SQL Server Database Engine. You may want to check the
"Automatically grant permission..." checkbox in the Settings dialog.

If you add or change names of cubes, you may run into problems with foreign keys when you redeploy. Click
Build -> Drop SQL Database to recreate database.