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. Partial screenshot of the attached sample report output:
Particular areas to note / steps:
Recursive hierarchies can also be very useful for relational data sources, not just parent-child hierarchies in cubes. I hope the explanations in this posting and the attached sample report resolve some of the mystery around parent-child / recursive hierarchies, and using regular vs. recursive aggregate functions. Enjoy!
The Reporting Services demo during the " BI Power Hour " session at the Microsoft Business Intelligence