Dennes Torres Creating a Date Dimension in a Tabular Model As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery... 15 March 2016 23 min read
Dennes Torres Creating a Date Dimension in an Analysis Services (SSAS) Cube A walk-through can be a great help to understanding SQL Server Analysis Services, especially when it solves the problem of providing an effective date dimension... 24 February 2016 33 min read
Richard Morris Bill Baker: Geek of the Week Bill Baker had a considerable influence on the way that SQL Server evolved to deliver reporting services and business intelligence. Until 2008, Bill Baker headed... 04 December 2012 8 min read
Robert Sheldon Adding a KPI to an SQL Server Analysis Services Cube Key Performance Indicators, which vary according to the application, are widely used as a measure of the performance of parts of an organisation. Analysis Services... 02 March 2010 14 min read
Robert Sheldon Implementing User-Defined Hierarchies in SQL Server Analysis Services To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on the database dimensions. Then you'll... 02 February 2010 13 min read
Robert Sheldon Five Basic Steps for Implementing an Analysis Services Database To learn an application, nothing beats getting it up and running. Getting started with Analysis Services can be frustrating unless you have a clear and... 05 January 2010 18 min read
