понедельник, 18 декабря 2017 г.

HANA заметки


HANA based BW Transformation – SAP Notes
https://blogs.sap.com/2016/06/09/hana-based-bw-transformation-sap-notes/

Performance tuning for calculation views:
•Filter the data at the base models and try to reduce the data set to what is really needed.
•Avoid the isnull check before filtering the data
•Avoid aggregation nodes unless really needed.
•push the custom calculation to the top most nodes as possible
•Apply optimize join and cardinality in each join
•If you have joins on MANDT/CLIENT/RCLNT …. Fields - remove those joins everywhere and instead put directly filter on value ‘001’ for MANDT/CLIENT/RCLNT…. Fields where you call tables.
•Use the planViz to analyze the view

... to be continued