SQL Server Analysis Services 2005/2008 Articles

Articles about Microsoft SQL Server Analysis Services 2005/2008 and related technologies grouped by categories.
  • AMO   ( 95 Articles )
    Analysis Management Objects (AMO), AMOMD, WSH, Powershell and other scripting for Analysis Services (SSAS).
  • Connectivity   ( 24 Articles )
    Analysis Services connectivity - http, tcp, firewalls, ports, connection string properties, etc.
  • Data Mining   ( 42 Articles )
    Articles about using data mining with Microsoft SQL Server Analysis Services (SSAS).
  • Design   ( 267 Articles )
    Articles about cube design, dimension design, attribute relationship, hierarchies, etc.
  • Drillthrough   ( 12 Articles )
    Articles about drillthrough implementation with Analysis Services (SSAS).
  • Excel   ( 76 Articles )
    Articles about using Microsoft SQL Server Analysis Services (SSAS) with Excel.
  • Local Cube   ( 7 Articles )
    Articles about building local cubes with Microsoft SQL Server Analysis Services (SSAS).
  • Management   ( 327 Articles )
    Articles about Analysis Services management - processing, locks, XMLA, Query Log, server properties, etc.
  • MDX   ( 397 Articles )
    Articles about MDX language specific issues and solutions. Includes MDX tutorials, MDX how to step-by-step guides, sample MDX scripts (cube and select).
  • Parent-child   ( 16 Articles )
    Articles about parent-child hierarchies in Analysis Services.
  • Performance Tuning   ( 66 Articles )
    Articles about performance tunning techniques in Analysis Services - aggregations, caching, partitions, server configuration, etc.
  • Reporting Services   ( 113 Articles )
    Articles about building Microsoft SQL Server Reporting Services (SSRS) reports with Analysis Services.
  • Security   ( 59 Articles )
    Articles about security in Analysis Services.
  • SSAS 2008   ( 43 Articles )
    Articles about SQL Server Analysis Services 2008.
  • Time Dimension   ( 40 Articles )
    Articles about building time dimension in Microsoft SQL Server Analysis Services (SSAS).
  • Uncategorized   ( 36 Articles )
    Articles that did not fit in any other category.
  • Performance Point   ( 72 Articles )

    Articles related to Performance Point 2007.

  • Data warehouse   ( 10 Articles )
    Genearl articles about Data Warehouse.
  • SSAS 2008 DMVs   ( 4 Articles )
    Microsoft SQL Server Analysis Services 2008 DMVs
  • PowerPivot   ( 2 Articles )

    Articles about Self Service BI features of the next version of Microsoft SQL Server (Kilimanjaro) - PowerPivot (code name Gemini).

  • Tabular   ( 193 Articles )
    SSAS Tabular model (BISM, PowerPivot, Vertipaq...)
  • Tabular DAX   ( 133 Articles )

Latest Author Articles

     

    XL Cubed