Performance Impact : Reporting on BW Query Vs Reporting Generated HANA View

[sowdip]

Hi ,

In an eclipsed based model , I wanted to understand in performance point of view what is the major difference between

- Build a Bex query and import into any front end

- Generate the HANA view and consume this view into any from end.

Please help in understand this.

Thanks,

Prashanth

[chandan_praharaj]

BEx performance check  can be done by RSRT tcode, in debug mode. just click the check box as shown in pic. and execute it. then Go back to see the Stats for each DSOs or BW tables and data fetched etc...

HANA View performance can be checked best by Visualise Plan in SQL Console, just write the SQL to select from that Calc View and right click Visualise plan, then it will open your PlanViz and execute the node.

Hope this helps.

Regards,

Chandan