Browse by Tags

All Tags » SSAS (RSS)

SQL 2016 Technical Deep Dive Video – BI and Integration and reporting

This is the set of videos from the SQL Server Engineering Team on SQL Server 2016. This post is covering BI, Reporting and Integration . For the other groups of videos have a look at. Customer Stories And End To End Implementations Azure Big Data and...

SQL Server Training in the UK–SSIS, MDX, Admin, MDS, Internals

If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb. Why this company rather than any others? Training based on real world experience...

Introduction to MDX–Training–London

if you are looking to work with Analysis Services then you need to learn MDX and there is no better person to learn it from than Chris Webb Chris is a Microsoft MVP and a leading expert on MDX. He is the co-author of two books, "MDX Solutions"...

In memory aggregations in .Net

Very interesting idea brought up by Jamie ( http://blogs.conchango.com/jamiethomson/archive/2009/04/08/programmable-in-memory-aggregations.aspx ) and one that i've been thinking about a few months ago after using LINQ to do aggregations. Before LINQ...
Posted by simonsabin | 3 comment(s)
Filed under: ,

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

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

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 | 1 comment(s)
Filed under: ,

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...
Posted by simonsabin | with no comments
Filed under: ,