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
. Deploy your solution by clicking Build
-> Deploy SQL
-> Deploy SSAS
. Sample is included with comments.Application screenshotCannot resolve image macro, invalid image name or id.ResultsResulting cubeResulting SQL DatabasePrerequisites
- 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 http://blogical.se/blogs/jahlenMore reading
Read more about InstantCube at http://blogical.se/blogs/jahlen/archive/2009/11/17/instantcube-building-a-sql-server-modeling-application-for-quicker-cube-development.aspx