Question Re: Refreshing query using macro in Technology Q&A

Refreshing query using macro

Former Member — Mon, 22 Jan 2018 17:04:19 GMT

Dear all,

I would like to use a macro to refresh my queries on AFO.

Every day I have to update multiple queries (different sheets, same workbook) with date of day before. I would like to know if there exists a macro who can do this job for me.

Thank you in advance

Re: Refreshing query using macro

TammyPowlas — Mon, 22 Jan 2018 17:04:36 GMT

Hello Simon - please see the steps in this wiki: https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=261522552

Re: Refreshing query using macro

reganmacdonald — Tue, 23 Jan 2018 10:24:26 GMT

Hi Simon,

I've done a few blog posts that cover this sort of thing, including using dynamic dates to do your updates.

It gives a bit more guidance on top of that Wiki and a bit more functionality.

Part 3 might be of particular use for you in this situation.

Cheers,

Regan

Re: Refreshing query using macro

Former Member — Tue, 06 Feb 2018 10:52:45 GMT

Hello All,

thank you so much for your quick answer.

It seems like a little bit too difficult for me, because I can use it.

Thank you for your help anyway 😉

Re: Refreshing query using macro

former_member760987 — Mon, 02 Aug 2021 16:00:40 GMT

Hello,

I created a macro to refresh a BW query after enter the variables in the parameter area. Is not working only for the CC-Hierarchy top node. For individualy cost center is working fine.

my code is

Do you know how I can solve it?

Thank you in advance