Monthly Archives: June 2013

Cube Status – a new open source project for BI in SharePoint

I have released my Cube Status project ( to


This web part for SharePoint provides the possibility to visualize both the current status of a SQL Server Analysis Services (SSAS) cube or tabular model (BISM) and some of its metadata.

This web part can be used in BI portal type pages in SharePoint to show the current status of a cube used for reports and analysis. This means that there is no need to guess the update status or last process time etc. of a cube.

Both the source code and a .wsp solution file for deployment are available for download from the project page:

This project is described in more detail here

This project also works quite well together with the SQL Server Agent Job Status project found at and with more details here

Please, feel free to suggest updates and new features etc. either here on the blog or on CodePlex.

Update to Create Time Dimension App

I have published an update to the Create Time Dimension Application for Excel that includes a new Date Integer Id column (in the format 20130616 for June 16, 2013) and Dutch language support.

The update is made on the server so it is available for everyone right away, no update needed on the Excel/Client side.

Big thanks to Frederik Vandeputte (Web: Twitter: for suggesting the id column and helping with the Dutch translations.



Screenshot: Updated app UI with the Dutch language choice