Hi,
We have a number of thick clent reports in BusinessObjects 6.5 which need to be ultimately migrated to Web Intelligence in the new Business Objects XI 3.1 system.
Primarily, the macros function to trigger refresh on other reports in the application or also, to pick values from an Excel sheet to reply prompts of a set of reports which are refreshed by the running of the macro in one report.
What may be the best way to implement this?
Can we have event based scheduling as a solution to the first case?
Is is possible to make Web Intelligence read a value from an Excel sheet or text file as an answer to a prompt when its schedule runs?
Any opinions and suggestions are welcome.
Many thanks!
Rahul