Creating Pivot collections via Reporting Services & SQL Analysis Services: Challenges and Solutions! Written by Russell Christopher on 05 July 2010.