We need details for AFO reports based on BEX queries to check runtime of queries.
I checked table 'RSDDSTAT_OLAP' it shows me everything regarding BEX query. But problem here is when I run the same query via AFO report in background , this table doesnt show any information.
Ask from business is to schedule 3 AFO reports based on BEX query , at different time intervals and track below information and update the same in different AFO report.
a) Username who has scheduled the report
b) Runtime of report
c) CPU usage
d) Memory Consumption
Any inputs please?
Thanks in advnace