Evaluating Query Performance with BW on HANA

[dheeraj_gupta]

Hi,

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.

Regards,

Dheeraj

We are on BW 740 SP 10

[lbreddemann]

This procedure call is a way for BWoH to specify a query without using SQL.

You can review the query conditions via RSRT trace options to understand what is requested from the DB.

Also, checking runtime stats for your query will deliver important information (e.g. records returned).

Finally, you could create a PlanViz trace for the procedure call.

However, there is typically not much you can do about the query in the first place, so it's questionable whether this will get you far.

Cheers,

Lars