Evaluating Query Performance with BW on HANA
We have build planning queries (using SAP's new Unified Model), which are based on Composite providers.
Composite Providers are fed by both Planned and Actual data. Planned data is stored in cubes, while the actual data is fed by analytical view, build in HANA Studio.
We are struggling with Query performance and want to analyse the root cause here. For instance, I would start by finding out how much time is consumed for the system to read data form the planning cube and by analytical view seperately.
I tried executing the query in RSRT and activating an SQL trace in ST05.
When I analysed the trace I found that the following statement took more of the time.
Statement : CALL SYS.TREXviaDBSL.
But I do not know what to do further ! Could someone guide me on how I could start my performance analysis.
We are on BW 740 SP 10