Anybody using triggers on Essbase (BSO or ASO) in production? I'd love to share some experience ...
we are using Oracle EPM 11.1.2.1.102 on Windows 2008 R2 x64
I'm facing some stability issues when using triggers to generate spool files (using after update triggers).
1) Triggers seem to disappear after stop/restart of an application (sometimes, not always ...)
2) Triggers do not fire even when condition is met (sometimes, not always ...)
3) Some Spool files can't be deleted until application is stopped.
Anybody out there facing similar challenges?
Kind regards,
Arno