THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

InstantCube: a DSL to design cubes

During a conversation I expressed the idea of making a DSLs to model cubes by leveraging the “Oslo” platform – my needs was having a human readable source file, easy to compare if you have two versions of the same entity (cube, dimension, or something else). Chris pointed me to InstantCube, which seems exactly what I thought! The implementation is a little bit different, because it also creates the relational model behind the cube (and it could be too much for me in several cases), but having a DSL for defining SSAS entities is definitely a good idea!

Published Tuesday, November 24, 2009 1:29 AM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Johan Åhlén said:

Hi Marco,

I came up with the same idea a few years ago. I've developed two previous DSLs using other platforms than "Oslo". I would say the most useful area for DSL is the ETL logics (which I so far have skipped in InstantCube).

The objective of InstantCube is to automate the development of cubes as much as possible, with a bit less control (relying on good default settings). However it could be extended with more optional settings.

Any clever contributions to the DSL are welcome! :)


November 24, 2009 10:21 AM

Marco Russo said:

I'd like to reverse engineer existing cubes (and SSIS packages!) just to be able to track changes between versions in a more understandable way.

It's a different approach than your, but I think it could be possible. However, there should be a complete VS integration, so that this proces would be transparent when you make check-in of source in the repository.

November 24, 2009 10:31 AM

Johan Åhlén said:

Yes, I agree reverse engineering should be interesting. I've actually done a lot of reverse enginnering to find out how to generate SSIS packages and SSAS projects.

Integration with VS would be great. I've looked into the Visual Studio SDK, but it really isn't straightforward... Would encourage someone who has plenty of time to try... ;)

November 25, 2009 7:52 AM

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement