Question on OBIEE 11g Agents delivery

Question

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!

asim cholas · Answer

Dear,

Why dont you try BI Publisher bursting?

Adding Bursting Definitions

[Deleted User] · Answer

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"

Turbokat · Answer

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?