SAP HANA Calculation Views - Graphical vs Directly from Views

[ThanhHieuNguyen]

Hi experts,

   I have created a Graphical Calculation View in SAP HANA based on my Views that were created with "CREATE VIEW" (1). I also created a Calculation View with only one Aggregation Node to read data directly from my Views (2). Then I created 2 Live Connections in SAC to test the performance, I found that the model created from (2) ran much faster than the model created from (1). I thought the Graphical is query data much faster but I received the contrast result.
Can anyone explain to me why? Thank you very much and wish you all a nice day.

[Vitaliy-R]

There were live sessions with SAP experts about modeling calc views recently. You can find recordings here: https://learning.sap.com/live-sessions?page=1&lsc_product=SAP+HANA+Cloud

[ThanhHieuNguyen]

Hi Vitaliy-R, the live sessions you share need a subscription to watch

[Vitaliy-R]

@ThanhHieuNguyen  But they are not behind the pay wall, you just need to log in to SAP Learning with your user.

[jan_zwickel]

Please explain in a bit more detail what the difference between (1) and (2) is. Is it that (2) puts the join/filter/aggregation logic into SQL views and (1) puts most of the logic in Calculation views? What is your test query? Is it SELECT * from? Please also show Explain Plans for both executions.