SQL Server Analysis Services design and MDX FAQ

List of Frequently Asked Questions (FAQ) and answer related to Microsoft SQL Server Analysis Services and MDX. Most of the examples could be run on Adventure Works sample database.
  • MDX FAQ   ( 51 Articles )

    List of frequently asked questions (FAQ) and answers releated to building MDX queries in Microsoft SQL Server Analysis Services 2005. Most of the code here was tested on Adventure Works database that comes with SQL Server.

  • Design FAQ   ( 12 Articles )

    List of frequently asked questions (FAQ) and answers releated to designing SQL Server Analysis Services (SSAS) database, cubes, dimensions, partitions and other objects.

  • Management FAQ   ( 44 Articles )

    List of frequently asked questions (FAQ) and answers releated to managing Microsoft SQL Server Analysis Services 2005 (SSAS).

  • Excel FAQ   ( 4 Articles )

    List of frequently asked questions (FAQ) and answers related to Microsoft Office Excel 2007 and Microsoft SQL Server Analysis Services 2005 (SSAS).

  • Reporting Services FAQ   ( 5 Articles )

    List of frequently asked questions (FAQ) and answers related to Microsoft SQL Server Reporting Services (SSRS) and Microsoft SQL Server Analysis Services 2005 (SSAS).

  • SSAS 2008 DMVs   ( 11 Articles )
    Analysis Services 2008 Data Management Views (Schema rowsets)
 

XL Cubed