This discussion is archived
3 Replies Latest reply: Dec 11, 2012 9:39 AM by MattMilella RSS

Excel add-in to Smartview migration

978855 Newbie
Currently Being Moderated
Hello,

Our client has a significant number of reports that use Excel add-in functionality.These reports need to be migrated to Smartview due to Hyperion no longer supporting the Excel add-in functionality.These reports have macros incorporated into them which further increases the complexity of migrating them to Smartview.

I wanted to know what are the steps to do this and what level of effort it will take.

I would really appreciate if anybody could help me with this.

Thanks,
Gopal
  • 1. Re: Excel add-in to Smartview migration
    MattMilella Journeyer
    Currently Being Moderated
    http://essbaselabs.blogspot.com/2010/07/converting-legacy-add-in-vba-to-smart.html

    Here is a link to a blog I did on this a while back. The macros will have to be converted but aside from that there is no other conversion needed.
  • 2. Re: Excel add-in to Smartview migration
    978855 Newbie
    Currently Being Moderated
    Matt,

    Thanks a lot for your reply. That really helps. If I have understood you correctly, what you are saying is the Excel Add-in reports will work fine with Smartview and need no conversion but the macros of Excel Add-in will have to be re-written in Smartview? If yes, can you tell me the level of effort required to do that? I'm very new to Hyperion and Smartview and apologize if my questions sound silly.

    Also, you mentioned in your blog that you will be posting a demo video of the conversion. Can you kindly provide the link to the video?

    Thanks once again.
  • 3. Re: Excel add-in to Smartview migration
    MattMilella Journeyer
    Currently Being Moderated
    Effort is really impossible to generalize. It depends on the type and amount of code. Not planning to post a video but we have posted the conversion utility I referenced in the blog.

    http://www.oracle.com/technetwork/middleware/smart-view-for-office/downloads/index-088403.html

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points