OTBI Agent Report Delivery needs to have import to excel or csv option
Organization Name
SITA
Description
We have a requirement to run an OTBI Analysis and to be run as a different user(User who has access to all data) and the output needs to be available to specific roles defined in the system. I manged to do this by creating agents, delivery, alerts etc in OTBI.
But the issue is when the output is delivered as an alert, we are able to see only the report output included in the alert, but we don't have any provision to import the data into excel, csv format.
Use Case and Business Need
There are certain roles in system who needs to run an OTBI report by passing the configured job/data roles so that they can see all data. Current implementation has been done in such a way that due to security reasons, employees can't edit their own record. Due to this, reports run on OTBI, excludes their own record in the reports.
Original Idea Number: b1d7594503