Expand my Community achievements bar.

Check out the November edition of the Analytics Community Lens newsletter to see what's been trending in the last two months!
SOLVED

Report Builder Auto Refresh

Avatar

Level 3

Hello All,

Does latest Report builder has a capability to Auto Refresh at regular interval? Omniture ExcelClient used to have this feature but now Excel Client is no longer supported.

 

Please advise

Regards 

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi Sameer,

Report Builder does support auto-refresh via Excel macros. Full instructions are linked in the blog post below:

http://blogs.adobe.com/digitalmarketing/analytics/report-builder-power-user-series-create-auto-refre...

Report Builder and Macros

Earlier this year, report builder introduced support for performing simple commands such as refresh via Excel VBA macros. Now if you use macros to perform bulk tasks or basic automation, you can include report builder functions in that workflow with some simple commands. For security reasons, you cannot schedule macro-enabled workbooks for regular delivery from Adobe Analytics, but you can still save and use them locally. For the purposes of our objectives, we will leverage the “RefreshRequestsInCellsRange” along with the “Application.OnTime” function calls in VBA.

Best,

Brian

View solution in original post

2 Replies

Avatar

Correct answer by
Employee

Hi Sameer,

Report Builder does support auto-refresh via Excel macros. Full instructions are linked in the blog post below:

http://blogs.adobe.com/digitalmarketing/analytics/report-builder-power-user-series-create-auto-refre...

Report Builder and Macros

Earlier this year, report builder introduced support for performing simple commands such as refresh via Excel VBA macros. Now if you use macros to perform bulk tasks or basic automation, you can include report builder functions in that workflow with some simple commands. For security reasons, you cannot schedule macro-enabled workbooks for regular delivery from Adobe Analytics, but you can still save and use them locally. For the purposes of our objectives, we will leverage the “RefreshRequestsInCellsRange” along with the “Application.OnTime” function calls in VBA.

Best,

Brian

Avatar

Level 3

Thanks

I will give it try. Regards