Question on OBIEE 11g Agents delivery

Turbokat

Hello,

I've a question on OBIEE 11.1.1.7 agents delivery. Following is the scenario, please let me know if you need more information.

I've database table called 'Orders', let's say it has 50 orders for today (Order-ID is unique) in that table. Is there a way in OBIEE 11.1.1.7 agents to generate PDF exports for each Order-ID passed as parameter to report along with today's date and create PDF export for each i.e 50 PDF exports as delivery content?

Thanks in advance!

[Deleted User]

You can chain Agents - i.e. use one Agent to launch another - an pass your Order IDs as input values to the chained Agents and hence have it loop through your list of 50 IDs, thus running on ist own 50 child Agents.

Turbokat

Thank you for the reply. I was also wondered on how to pass individual order-id's to each agent, not sure if row-wise initialization can be used here?

[Deleted User]

Apologies that was an oversight on my part. The "Invoke per row" option is actually not available for Agent chaining

Working with Actions

(not available for Invoke Server Script actions, Invoke Agent actions, or actions for which one of the parameters is a result set mapping) Select the Invoke per Row option if you have specified a condition for the agent and want to execute the action for each row returned by the condition.

You would actually have to call the OBIEE Agent Web Service - that one can cycle through your IDs via "Invoke per row"

asim cholas

Dear,

Why dont you try BI Publisher bursting?

Adding Bursting Definitions