This content has been marked as final. Show 3 replies
As you select the name of the report or dashboard page in the delivery module, you must create 200+ agent (I don't think you could configure only one agent) and you schedule it at your convenience - so you don't create an agent (parent).
With OBIEE, maybe you can use the OBIEE API but I think that Deliver is the best tool on OBIEE for your requirements.
Thanks for reply and input.
I have to run these reports on frequent interval (or say as on need basis) and using a specific timing won't be a good idea. So that’s why i was thinking of to create 200 + agents and on top of that 1 parent agent which will call the rest of the 200+ agents.
Is there any issue with this approach?
Kindly help as i am not very familiar with OBIEE tool......
All help and input are welcome and i am thankful to you all in advance.
you can see this site to have an overview on how to save the result of an agent on the file system : http://total-bi.com/2011/08/obiee-export-reports/
So in your case you could :
- create an agent per report. When you want to save the file on the file system, you use the tab Action (invoke Server script)
- create an agent (parent) which will invoke another agent (previously created). I don't know if you can invoke multiple Agent in a parent Agent - I never test it. Another way is described in the OBIEE User's guide :
+"Invoke Agent — Invokes another agent. This action type lets you chain agents. For example, you can have Agent A invoke Agent B, which invokes Agent C and so on."+
Hope it helps you.