Analsysis for office statistics table BW HANA 7.5

[former_member754216]

Hello Everyone,

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

[henrikbaumann]

Hi Nagaamulya

By default AFO is not writing to RSSDSTAT_OLAP, until you enable Workbook Profiling. To do this in Excel, go to File->Analysis->Troubleshoot->Advanced Mode->Analysis tab->Enable Workbook Profiling (BW Statistics).

You can read more about in the admin guide (Query runtime statistics)

BR

Henrik