Skip to Content

Evaluating Query Performance with BW on HANA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 21, 2015 at 12:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded