Browse by Tags
All Tags »
MDX (RSS)
Chris Webb MVP can, to quote a friend of mine can, “Make MDX sound interesting”. I have to say when I first when on a course on MDX the tutor went for the “Make MDX confusing and boring” approach. Chris has recently coauthored a book on Expert Cube
Read More...
Excel and analysis services are pretty open technologies so it’s very easier for anyone to grow their own stuff in for a richer experience, and even Microsoft provide things like the data mining add-ins which follow this principle. These add-ins are not
Read More...
Compared to T-SQL and the database engine , MDX and analysis services is a somewhat poor relation and is usually catching up. There’s no resource governor in SQL Server 2008 or intellisense for MDX in management studio. I expect this is because
Read More...
Let me start with a little history of Microsoft BI. Microsoft acquired an OLAP tool from a company called Panorama , project name Plato, which was bundled in with SQL Server 7.0 and from this grew the present incarnation of Analysis Services which IMHO
Read More...
Excel already has always had excellent support for analysis services, but to get the best form it you need to use a version of office later than than the version of SQL Server you are connecting to. So for analysis services 2000 excel 2003 is OK
Read More...
If like me, you are trying out the new stuff in SQL server 2008 you might need some data to work with. The standard Adventure Works sample databases for OLTP and data warehousing are not in the CTP nor is the the analysis services project. So you'll need
Read More...
Hugh McLeod is quite correct, On-Line Analytical Processing (OLAP) is actually about business, it just sounds like a science project. Basically OLAP is an awful name, Nigel Pendse , author of the OLAP report calls the same thing FASMI, which I think is
Read More...
Subscribe in a reader" />
