Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Question on OBIEE 11g Agents delivery
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!
Answers
-
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.
0 -
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?
0 -
Apologies that was an oversight on my part. The "Invoke per row" option is actually not available for Agent chaining
(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"
0 -
0
