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