InstantCube creates cubes quickly by auto-generating the underlying code using Microsoft Oslo 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.

Application screenshot

Cannot resolve image macro, invalid image name or id.


Resulting cube

Resulting SQL Database

  • Need Microsoft Oslo installed.
  • Need SQL Server 2008 Standard Edition or higher installed.

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

Last edited Nov 19, 2009 at 5:25 AM by JAhlen, version 11