Hello BI Guru's/Expert,
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?
Thanks in advance for your time and effort.......
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.