Skip to Content

RSRT Query Properties in BW on HANA - Option 0 (not to use HANA processing is selected)

Hi experts,

we have recently migrated our infocubes to hana optimized infocubes and when wanting to measure the query runtime, when selecting different Operations in BWA/HANA modes in the query settings at the RSRT, it gives almost the same query runtime with any other option, even when the option 0 is selected, which is supposed not to push down the operations in HANA.


Sure now in BW on HANA the queries runs faster, but I just would like to know why the query runtime doesnt change even when selected the option 0 at the Operations in HANA, so that I can choose the best processing modes for queries in HANA.

Thanks in advance!

Best Regards,

Regys

test.png (62.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 13, 2017 at 10:42 AM

    Hi;

    Usually in the option you highlight I select "3 - Standard".

    But you can test the different combinations of the query properties.

    See

    https://blogs.sap.com/2015/06/18/how-to-check-the-sap-bw-query-push-down-to-sap-hana/

    Hope it helps;

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2017 at 11:55 AM

    Hi Ricardo,

    thank you for the reply. I guess in my gui, it doesn't show the tabs that it usually should show when the query is processed in HANA. I have chosen the exact same options like in the link you sent to me, but still it doesnt show the HANA Calculation Engine layer and the Aggregation Layer Cluster Info. Does this mean, that the queries would not be processed at all in HANA? If yes, then how is it possible that with the same amount of data, the InfoCube in BW on HANA is at least 3-4 times faster than in BW on any DB...

    Thank you very much.

    Regards,

    Regys

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 21, 2017 at 03:32 PM

    Hi Regys,

    Could you please tell how you measure performance? have you disabled cache?

    Please add screenshots with the execution statistics (Execute+debug, disable cache, display statistic data)

    Kind regards,

    Andrey

    Add comment
    10|10000 characters needed characters exceeded

    • What is showing on the Aggregation Layer tab of the screenshot you provided? That should show you which indices or databases are your bottleneck. If you see those pre-pended with a "$" then the index is being used and should be helping performance. If not then the complexity of your report may prevent that from being used as there are some formulas that prevent option 6 from really making any difference (I think things like %CT, %GT do that off of the top of my head)