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.

Read more...

 

Tags: ssrs, parent-child

 

2007-2015 VidasSoft Systems Inc.