Environment: AF 6.1b / Windows Server (AF) / Oracle 9.0.2.4
I would like to tie my metric refresh schedules to when our data warehouse gets refreshed and not based on specific time frames within the scheduler tool.
Upon reviewing the example in the AF user’s manual on page 210, there is a way to create a rule based on an external event or program. Unfortunately, the example is short on explanation/detail and doesn’t make ‘perfect’ sense to me…
I was wondering if anyone has already created either a shell script or PL/SQL script from which to trigger the metric refresh? If so, would you willing to share the specifics on how you accompished that and what pitfalls you ran across.
I am not sure whethere am giving a Proper solution…but I will like tell you … What work around we are doin for this…
We are using File Voucher to Trigger the refresh of reports.
As soon as we finish the batches in Oracle we creat one token file on Oracle server…after creation of that file… we NDM/FTP that file to SUN machine where we have WEBI installed … As soon as the file arrives in WEBI folder BCA triggers the report Refresh
Upon posting of this, the rule created in step one fires off and your metrics start refreshing.
Issues I still encountering is that the rule does not consisitently fire off upon the posting by Oracle. Is a particular problem if you are sending mulitple postings to the AF server based on different schema refreshes.
Currently have open case with tech sppt. They are researching :?
I’ve had similar problems with named events in AF6.5.1. What seemed to work quite well in 6.1.x now seems to be problematic. There is a hotfix for this issue - ask for file ‘AF651_Hotfix05’. However, in the best tradition of Business Objects, the hotfix doesn’t seem to fix anything
I’ve ended up rebuilding the dashboards so that they use universe queries rather than metrics to populate analytics. This means that when users access dashboards, the query runs and picks up the latest data. I realise that this is a massive overhead on the network and database, but it seems to be working okay so far.
The above URL for refreshing metrics working for me consistently when i refresh it through a browser after logging into apps. But without logging into the application foundationl, URL has no effects on the refresh. I am thinking of calling this URL from the Oracle trigger. But i am not sure how to bypass or simulate logging into the apps from external program. Does any one have insights?
Also Sank, can you pl. give us an update what have you been trying to do ffrom oracle to automate the refresh?
Hello Nemesis- did you get any further with troubleshooting this with BO tech support or was this the limit of your involvement with them. We appear to have run into the same issue and I was wondering if you had spent anymore time working with BO to fix it?
HI Alex. Unfortunately, I haven’t managed to get to the bottom of this one. We could never get any consistent failures. Sometimes the metric refreshed, and sometimes it didn’t. As I’m sure you know, without a reproducible workflow the helpdesk can’t really help.
I just started hitting this error, and I wondered if anyone had any more information - what used to work fine, now does not …
I try the HTTP… AAGatelet…named event method thru a VBScript, and that just hangs - same with running it interactively from a browser window. This is what we did under 3.03, but now we are stuck.
Is this a known issue? Do we have to give up on named events from an external program (mainly DW loads)?
I upgraded to the 651 international version, loaded the patch (5), and now I can trigger a named event via the brower. I can’t , however, get this to run as a scheduled event - the vbs routine just hangs, IE never comes up, the event is not raised.
I use this same routine to run Webi, running a heartbeat report with a log to verify the status of the cluster.
(BOB member since 2002-10-17)
(BOB member since 2002-10-16)
(BOB member since 2005-02-01)
(BOB member since 2004-06-09)
(BOB member since 2002-08-29)