Skip to Content
0

SAP BW query performance on calculation view in HANA

Feb 12 at 08:29 AM

314

avatar image
Former Member

I have created BW query on top of a virtual provider and the virtual provider is based on calculation view in HANA which is again built on ADSO tables.

I have read about performance blogs, where we can push down the filters at the base table of the calculation view by using input parameters.

In my scenario, I have not used any input parameters instead I have used filter variables in BW query.

My question is how to visualize if the filters from BW query in RSRT are pushed down to the base table of calculation view or do I need to define input parameters and then map it to the BW query filters.

Please suggest

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Gajesh Nagesh Feb 12 at 09:38 AM
0

Hello Sameer,

There are different methods by which you can improve the performance.

1) In case if your going to use only 2 years data at any point of time , you can use the input parameter as a filter. You can make the input parameter(IP) dynamic to pick 2 years. This holds good for any characteristics filters that is getting used in the Bex query. If there is any chance of pushing a bex global restriction to Input parameter it will improve performance.

2) You can make the IP as Target field in the composite provider and pass the value from Bex.

Also check whether how much time does the existing query takes. if its coming out in fractions of seconds then there is no need of using IP.

Regards

Gajesh

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Gajesh for the answers.

As of now, I have BW query filter on date range which by default fetch 3 months of data and the query is taking few seconds to execute.

My concern is if the data volume grows in future then will it impact the performance or date restriction in BW query is sufficient to handle the performance issues.

0

Hello Sameer,

With Hana i dont think you need not be that concerned. If your view is supposed to bring in 3 months data , giving Input parameter will anyway benefit.

Regards

Gajesh

0
Andrey Uryukin Feb 12 at 10:38 AM
0

Hi,

You can do the following steps:

1. open RSRT, put your bex and press "Execute+Debug"

2. In popup window under "SAP HANA/BWA"->"SAP HANA/BWA Default trace" tick "Generate PlanViz File"

3. Copy generated code and open SQL console in HANA Studio

4. Run the generated statement and see if the filters are pushed down

BR,

Share
10 |10000 characters needed characters left characters exceeded