InstantCube - Creates cubes quickly by auto-generating the underlying code (Free)

Posted in SSAS Tools

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.

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

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

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

Author
Feel free to contact the author, Johan Åhlén, at http://blogical.se/blogs/jahlen

More info and download here...

Related blog post - InstantCube - building a SQL Server Modeling DSL application for quick cube development

Tags: tool, software