Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Generating Excel 2007 workbooks linked to SSAS using SSRS and OfficeWriter

with 2 comments

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

http://officewriter.softartisans.com/officewriter-410.aspx

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.

Written by Chris Webb

June 2, 2007 at 10:12 pm

Posted in Uncategorized

2 Responses

Subscribe to comments with RSS.

  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.

    Thanks!

    pforsthoff

    January 5, 2012 at 5:18 pm

    • 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…

      Chris Webb

      January 5, 2012 at 8:09 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,070 other followers

%d bloggers like this: