Will you be at SQL Rally Nordic?

  I got my session submission accepted to SQL Rally Nordic. I will be speaking about how to build a forecasting and planning solution based on SQL Server, Excel 2010 and SharePoint 2010. If you have the opportunity to attend you can come around and say hi.


Enabling Crescent in SharePoint 2010

  If you followed my earlier post (http://blogs.msdn.com/b/querysimon/archive/2011/07/18/installing-sharepoint-2010-together-with-denali-ctp3.aspx) about installing Denali CTP3 together with SharePoint 2010 then you will find that Reporting Services have not been enabled in the SharePoint site. One thing that has changed in Denali compared to SQL Server 2008 R2 is that Reporting Services is a shared service when it is…


Installing SharePoint 2010 together with Denali CTP3

Now that Denali CTP3 is out I would like to setup a complete demo environment on one of my VM’s for a base image I suggest that you can use the pre-installed one from http://www.microsoft.com/windowsserver2008/en/us/virtual-hard-drive.aspx. The installation of Denali CTP3 was very straight forward, I did a complete install of all the features and I…


Problems with the SSAS Tabular Model Projects Denali CTP3 samples

      UPDATE: The samples have been refreshed if you experience this problem please download the samples again and it has been fixed.       As part of understanding the new Tabular Model in Analysis Services I downloaded the sample databases from http://msftdbprodsamples.codeplex.com/releases/view/55330 I always finds it valuable to go through all the…


First impressions installing Denali CTP3 SSAS

Now that Denali CTP3 have been released to the public I wanted to post a blog post of the installation procedures. Installation is very similar to previous versions. First thing to do is to run the SQLFULL_x64_ENU_Install file that will unpack the installation files. By default it will unpack the files to C:\Users\<username>\AppData\Local\Temp\<guid>\ After this…


SharePoint 2010 SP1 is here, what’s in it for BI

The new service pack for SharePoint 2010 has been released to the web as communicated in the official blog at http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=984  You can now download it from here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26623 There is a lot of new stuff in the service pack that enhances the functionality in SharePoint 2010, more detailed information can be found in the…


How to control allocations when using write-back in Excel 2010

One of the first questions that I usually gets when showing write-back in Excel 2010 to Analysis Services cubes is how you can control the allocation of values between dimension members. By default you will get an equal allocation based on the number of dimension members. This setting will divide the value by the number…


Handling Dates in PowerPivot

Recently a former colleague contacted me on how to format dates in PowerPivot. She had a date column in a PowerPivot workbook that she wanted to show on the row axis in a PivotTable. However no matter how she formatted the column either in the PowerPivot window or in the PivotTable it always showed as…


Writeback to Analysis Services cubes from Excel 2010

 Analysis Services have had write back functionality for a long time; however there has been no client support for writeback in the most used BI client on the market (Excel). One of the new features in Excel 2010 is the ability to perform writeback to Analysis Services cubes. In order to write back to a…