I am new to bi and have couple of queries -
Have specific requirement where we have 200+ reports and want to export the reports to certain location as on need basis so to have a solution for the same -
1- Do we need to create 200+ agents (one for every single report) and then another agent (parent) on top of 200+ agents so that we run the parent agent and it will deliver the reports?
Or within a single agent can we mention the set of reports which need to be delivered?
2- Can we export the analysis output in particular format (say pdf/excel) to certain network drive location? Or is it possible to deliver the output in the form of mail only?
3- Is there any other way provided within BI to accomplish this?
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."+