SSAS - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » SSAS (RSS)
04 December 2007 22:58

Installing Visual Studio 2008 and SQL Server 2005

If you are upgrading to Visual Studio 2008 then be careful with SQL Server. You may or may not know that the Business Intelligence Development Studio (BIDS) is a visual studio shell. If you don't have Visual Studio installed when you install SQL Server...
Posted by simonsabin | with no comments
Filed under: , , ,
21 November 2007 16:01

SSAS Debuging MDX

I've been delving into the world of MDX recently and it is another world. You really have to get your head thinking all sorts of different ways to try and grasp the tuples, slices, hierachies etc. What writing calculated measures I have often found the...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
21 May 2007 12:08

SSAS - AverageOfChildren only applies to the time dimension

I've just spent a morning trying to figure out why my average measure doesn't average but sums. I guess I should have googled straight away. In doing so I found this forum post http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=548837&SiteID...
Posted by simonsabin | with no comments
Filed under: ,
18 May 2007 17:54

Too Dim or not Too Dim

No i'm not talking about a new Harry Enfield sketch about a posh bloke that's a bit thick, I 'm talking about tables in a warehouse. Many people insist on naming tables DimCustomer, Dim Product etc and FactOrderLine. What is the purpose of this, especially...
Posted by simonsabin | with no comments
Filed under: ,