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.

Download and install InstantCube. Write your cube definitions. Check your definitions by clicking Build -> Parse. Deploy your solution by clicking Build -> Deploy SQL and Build -> Deploy SSAS. Sample is included with comments.

  • Need SQL Server 2008 Standard Edition or higher installed.
  • Need .NET Framework 4.0

Application screenshot

Cannot resolve image macro, invalid image name or id.


Resulting cube

Resulting SQL Database

  • 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.

Feel free to contact the author, Johan Åhlén, at

More reading
Read more about InstantCube at Blog Article about InstantCube

Last edited Apr 28, 2011 at 7:26 PM by JAhlen, version 16