Report Portal

Using Analysis Services Parent-Child Hierarchies in Reports

One of the questions that I answer somewhat frequently, is about recursive groupings in Reporting Services and how to utilize parent-child hierarchies from an Analysis Services cube.

The attachment of this posting contains a small report example I put together based on the Analysis Services 2005 Adventure Works DW sample cube, and demonstrates a recursive hierarchy using the employee dimension.  It works both in Reporting Services 2005 and 2008.



Tags: ssrs, parent-child


2007-2015 VidasSoft Systems Inc.