Udostępnij za pośrednictwem


Reporting From Analysis Services Data

The SQL Server Customer Advisory Team published a new technical case study on Analysis and Reporting Services, Design and Implementation.  You can read the summary here, as well as download the full 55 page document.

Among other topics, the case study explains how to use so-called server aggregates in reports calculated by Analysis Services, report parameters bound to dimensions, utilizing recursive parent-child hierarchies in reports, and building KPIs in Reporting Services 2008 reports, and much more.  Btw, Reporting Services 2008 R2 simplifies using KPIs significantly.