I’ve had some questions from people using the AdventureWorks tutorials on Analysis Services 2012, so I thought I would answer them here. When deploying the
I was asked recently if it is possible to create HTTP msmdpump.dll (Per user identity) connection to an SSAS cube. Microsoft have produced a White
There has been a lot of buzz from SQLPass and in the SQL Server community about the Business Intelligence Semantic Model (BISM), which will be
Here is another Analysis Services error message which I’ve seen crop up from time to time: Errors in the OLAP storage engine: A duplicate attribute
I have decided to write about SSAS 2008 errors that I come across occasionally, either by my own hand or things that I see my
Further to my earlier theme of Intelligent Laziness, here is some key advice before setting out on the journey of creating Analysis Services cubes. Hopefully
I have been interested recently in applying different methodologies to delivering Business Intelligence projects, particularly in Analysis Services 2008. In particular, Agile and Kaizen seem
Chris Webb, Marco Russo and Alberto Ferrari have produced a book on ‘Expert Cube Development in SSAS 2008’.Personally I think it’s the book that is
I’m a big fan of intelligent laziness when it comes to Business Intelligence. Although in another arena, one famous adherent of ‘intelligent laziness’ was Napoleon
In Analysis Services 2008, query and process performance can be optimised by looking at aggregations. I’ve distilled the main points from the SQL Server Best
In SQL Server Analysis Services 2008, hierarchies are important because they are critical to optimising dimensions, and thus improving the performance of the solution as
In the current blog, there is a summary of Type 1 and Type 2 attribute dimension changes in terms of their implementation of attribute relationships