SSAS (RSS)

Too Dim or not Too Dim

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Too Dim or not Too Dim
The new RSS feed is here

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 in a UDM model where tables can easily be dimensions and facts. What happens then, should it be DimFactOrder or should it be FactDimOrder, sounds like something from a Chinese menu.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Too Dim or not Too Dim

SSAS - AverageOfChildren only applies to the time dimension

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSAS - AverageOfChildren only applies to the time dimension
The new RSS feed is here

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=17

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSAS - AverageOfChildren only applies to the time dimension