Skip to Content
avatar image
Former Member

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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 12 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.

    Regards

    Gajesh

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Feb 12 at 10:38 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded