Long query runtime on BW on HANA

[philipp_peters]

Hello,

we have a performance issue with a query in our system. We use BWonHANA (HANA 1.0, BW 7.5).

The query is based on a composite provider which is based on three ADSOs. I made a performance trace and discovered a long runtime for datamanager (ID 9000) with about 120 seconds. When running the generated statement directly on HANA and analyze with PlanViz I get a runtime of just four seconds.

This is the result of query statistics:

Aggregation Layer:

Can somebody explain what happens there? Is it possible to analyze what is happening in the datamanager?

Thanks

Philipp

[former_member186399]

Hello Philipp,

I see the data is 4 million that is getting transferred. Also the number of columns in the report can consume time. 9000 essentially means the data is running in Hana.

Try couple of things.

1) Try Display data on Composite provider and pass the same restriction that you are passing through the query. Check the time that it is taking.

2) Try changing the Query Properties in RSRT and check the timing for each one.

3) Also put a trace on your ID using RSTT and run the query. Check whether it is giving any clue on were the time is spent.

Regards

Gajesh

[philipp_peters]

Hi Gajesh,

here is the screenshot of the query statistics:

And here the picture of the aggragation level:

The query is restricted via 0CALDAY. In PlanViz I can see that the result is around 4,1 mio records. The result of the query should just be a aggregation on 0CALDAY. Is it possible that all the calculations are made in Netweaver-Stack? Can I see the reason why the result is not totally calculated in HANA?

Thanks
Philipp

[former_member186399]

Hello Philipp,

The pictures are not visible.

If the time is spent on Data manager 9000 means, system is trying to bring the data from the database. How big are the ADSOs and what are the restrictions that you are giving in the query.

Regards

Gajesh