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 [...]

Reporting Services 2008 is a great reporting tool, but displaying Analysis Services data with Reporting Services doesn’t always display the data as you would expect. A Parent-child hierarchy is one example of this: When you browse Parent-child hierarchy from an Analysis Services cube with Excel, Excel automatically displays it with nice drill-down functionality. But when [...]

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 [...]

Excel 2007 is great tool for browsing OLAP cubes. But 1 thing a lot of people don’t know about or at least don’t use enough, is Member Properties. When they want to add a property of a specific attribute, they just check this item in the field list. By using it this way, you’re kind [...]

Today I got this error while trying to browse a cube from the Business Intelligence Development Studio: The detailed error information told me that the connection failed, because the server actively refused it. Connecting from another pc worked perfectly, so it had to be a problem with my computer. To solve this problem I needed to [...]