• Very interesting article. Always neat to see how other people go about solving problems and coming up with solutions. I also had to deal with getting SSAS data into SSRS and putting it in a format that would easily work with SSRS. I looked at SSIS as a source for the report and actually combining the data within SSIS to output to SSRS. I did like that approach, but in the end we ended up going with a linked server and using stored procedures to use as the source for the SSRS reports.

    Using Reporting Services (SSRS) with SSAS data

    You don't see me using relational data in the example, but he had to in some reports where we would actually configure how to rate items based on a tie breaker in the rankings.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com