Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HFM system 9.0 retrieves and Excel macro

649318Jul 9 2008 — edited Jun 16 2009
We run HFM system 9. I have several retrieves that I use as reports. I need to run these reports for several sites (change various points of view) and would like to use a macro in Excel to accomplish this.

I haven't been able to get it to work. The macro can change the points of view, but when I refresh the query (via visual basic code that accesses the menu in excel), the macro continues to the next line of code without waiting for the retrieve to refresh.

Could someone explain how to do this?

Also, is there a visual basic function available when I am running system 9 smartview to call a refresh directly from code without having to go through the excel menu?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2009
Added on Jul 9 2008
7 comments
3,100 views