Flexible grouping on data from your DW in Excel 2007

May 15, 2009

I have recently built a data mart containing all the data of budgeting and accounting in SQL Server 2005 and created a Report Model in Report Builder for it. My users were looking for a flexible way to define different grouping on the data, without having to ask for my assistance. Defining new formulas in Report Builder isn't the most comfortable thing to do (specifically if they get complex and long), so we had to find another way.   There was a suggestion of creating a view in the database with their definitions for the grouping straight to SQL, but I...

More News on SQL Server 2010 Madison

May 12, 2009

You know how they say “time just flies by you”? I think the year 2010 is coming quicker than I thought, and with it the new SQL Server 2010, code named Madison. Microsoft has announced that it is planning a Technology Preview for Madison in early July, so if you have a petabyte size DW then you might be one of the lucky customers invited to take project Madison for a test drive.Other announcements (coinciding with TechEd 2009), are of new features available in SQL Server 2008 R2 such as Master Data Services which should serving as a central...