Skip to Content

SAP BW query performance on calculation view in HANA

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Feb 12, 2018 at 09:38 AM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 12, 2018 at 10:38 AM


    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


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.