Hello SAP BW Experts,
I have a requirement in my project to set up a query to monitor the BW system performance which satisfies the below points.
1. query should have a fixed, defined content which is not changing over the time (e.g. a fixed list of customers for a long closed month). This query should
be executed once every hour (and therefore should be reasonable small).
2. the run-time of this query should be recorded and the results written back to the technical content.
3. setup a query which is reading and reporting this technical content.
Please let me know if this is something to do with the reports on technical content cubes and which on which cube this requirement can be met.
Thanks in anticipation.
BR,
Mohan