Davy's Blog

Last week I had to build some PPS Dashboards in an existing SharePoint 2010 environment. One of the requirements for the dashboards was to support English, Dutch and French. Because the data was loaded from an Analysis Services Cube, I added the extra required translations to the Analysis Services Project: Dutch-Belgium and French-Belgium. The SharePoint [...]

At a current project I needed to create a deploy script for the MDX calculations of a cube. SQL Server Management Studio makes it very easy for you to create XMLA-scripts to create or alter cubes, dimensions, etc… But it’s not possible to use Management Studio to create an alter-script that only contains the MDX [...]

Microsoft has made the sessions presented on SQL Server Day 2009 available on Chopsticks Opening Keynote by Wesley Backelant and Ritchie Houtmeyers Best Practices for SQL Server Consolidation by Tom Van Mulders Breaking the ETL world record with Integration Services by Henk van der Valk Designing Effective Aggregations in Analysyis Services 2008 by Chris Webb [...]

I recently struggled with the following challenge in Analysis Services: In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″. bing brought me to the following great article, where Mosha [...]

The newest version of MDX Studio, now also has intellisense! With Visual Studio and other modern IDEs, Intellisense became a must have tool in the developer’s toolset, boosting productivity. MDX developers have asked for it, but full, context-dependant intellisense wasn’t available. Until now. MDX Studio now features comprehensive support for intellisense. The first version with [...]