SAP BW query performance on calculation view in HANA

[sameer_mehta]

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

[former_member302041]

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,

[former_member186399]

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

[sameer_mehta]

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.

[former_member186399]

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