Skip to Content

How to Analyse HANA Queries generated by the SAP BW Engine

Experts, I have been working in the SAP world and specifically SAP BW for many years. I was working on other databases but now I have got an opportunity to work on BW on HANA. With SAP BW on any other database it is quite easy to figure out, what exactly is causing a performance issue. You could get a clue from SM50/SM66 or the Traces in ST05, of course.

I am however perplexed how to get the same level of detailed information for BW on HANA. Whenever I try to generate a PlanViz for a complex BW Query from RSRT or ST05, I see we have long running DB Procedure, for which a PlanViz cannot be generated. Even if I give Blank Parameter Values I get an error

[129]: transaction rolled back by an internal error: Invalid Bxml format detected

Can you help me to analyse further what is it that the DB Engine is doing inside this DB Procedure TREXviaDBSLWithParameter ?

CALL SYS.TREXviaDBSLWithParameter( ? , ? , ? , 'ROUTE_BY_TABLES( "SAPPFW"."0BW:BIA:V1S66CO39" )' );

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers