Manually Prioritize Requests in Report Builder? | Community
Skip to main content
Level 3
August 16, 2017
Solved

Manually Prioritize Requests in Report Builder?

  • August 16, 2017
  • 1 reply
  • 1269 views

I'm building a Report Builder dashboard, and want the following to be executed in order:

  1. pull some data in a request
  2. manipulate the data using Excel functionality
  3. pull a second request based on manipulated data

Example:

In initial request, Report Builder returns:

/path-goes-here

Then, Excel functionality conditionally pre-pends this info:

sitename.com/path-goes-here

or

mobile.sitename.com/path-goes-here

Then, second request fires pulling additional information based on manipulated value (sitename.com/path-goes-here / mobile.sitename.com/path-goes-here)

It's not as easy as doing a simple dependent request, since the cells being pointed to in second request aren't output cells of first request. I know Adobe allows you to pre-pend hard-coded text when outputting a request, but this doesn't meet my needs as pre-pended text in my case is conditional.

If I were able to tell Report Builder - execute request 1 first, then execute request 2 after request 1 is completed and a small amount of time has elapsed to execute Excel logic, I'd be able to accomplish what I'm looking for. Don't see a way of doing this.

Anyone have insight?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Hyder_Ziaee

Have you tried controlling the requests via VB Macros.

Check this out: Invoke Report Builder Functionality from Microsoft Excel Functions

1 reply

Hyder_Ziaee
Adobe Employee
Hyder_ZiaeeAdobe EmployeeAccepted solution
Adobe Employee
August 25, 2017

Have you tried controlling the requests via VB Macros.

Check this out: Invoke Report Builder Functionality from Microsoft Excel Functions