Generating Excel 2007 workbooks linked to SSAS using SSRS and OfficeWriter

Here’s the second of my (paid-for) articles for the folks at Softartisans:


This time they wanted me to write something about using OfficeWriter with Analysis Services, and after a bit of thinking I came up with the idea of trying to generate Excel workbooks using OfficeWriter and Reporting Services that use the new Excel 2007 cube functions so that they have live links back to Analysis Services. After a lot of sweat I got it to work, and I have to thank Excel MVP Charley Kyd (the guy behind the Excel BI site http://www.exceluser.com/) for giving me the solution to the problem of OfficeWriter writing values to the cell Value rather than Formula property. Hopefully this is the sort of thing that could be made easier when/if OfficeWriter gets integrated with SSRS in Katmai.

2 thoughts on “Generating Excel 2007 workbooks linked to SSAS using SSRS and OfficeWriter

  1. Thanks for the info Chris, I was recently pinged by Softartisans to write a paid review of the new OfficeWriter 8 product. Just wanted to ask if you don’t mind what they pay for these articles and in your opinion is it something I should consider.


    1. Chris Webb – My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel.
      Chris Webb says:

      I’d rather not say what I was paid for the paper I wrote, and in any case it was a few years ago now. But I don’t think there’s any reason not to do it so long as you disclose that you were paid to write it. We all have to earn a living, after all…

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.