We solve complex problems of data modeling and develop tools and solutions to let business perform best through data analysis.

Complex challenges made simple

SQLBI is a consulting firm with a strong and unique experience in Business Intelligence, centered around Microsoft technologies – SQL Server and SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).


We help companies make sense of the information they have available so that they can take strategic informed decisions that deliver better results and performance. 

DateTool Dimension Project

DateTool

DateTool is a special dimension containing regular members that act as calculated members similar to those generated by Time Intelligence Wizard, without some of the limitations of the Time Intelligence Wizard. We still don't have a complete document describing this features in detail. This is currently a work in progress and we would like to get feedback about issues and possible improvements.

The project is freeware, full source code is available.

Download

2006.09.09 DateTool 0.6.0.0 Project source for SSAS (it requires AdventureWorksDW database installed on SQL Server)

FIX: fixed incompatibilities with OWC 11 and BIDS/SSMS browser

2006.09.02 DateTool 0.5.0.0 Project source for SSAS (it requires AdventureWorksDW database installed on SQL Server)

Articles and History

2006.09.02 See the DateTool blog post by Marco Russo to get more information. A more complete article will be released with a future version.