Union Pruning In Sap Hana, Union node pruning allows the data sources in union nodes to be pruned. HANA queries each Analytic view and returns Explore various pruning techniques in SAP HANA Cloud to optimize query performance by excluding unnecessary data sources during processing. A matching filter is then applied in the WHERE clause of the query so that only one of the data Fig 6. Create Pruning data in union view nodes help optimize the query execution on the union view node. We have 3 ECC source systems Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube. This helps reduce 24 Union Node Pruning with Pruning Configuration Table in Calculation Views Srinivas M SAP Analytics Tutorial 12. Using a pruning configuration table offers greater flexibility, but can slightly impact performance compared to union node pruning based on One of the new features of HANA SPS11 called 'Union Node Pruning in calculation view 'supports us to achieve this by reducing the cost of execution of calculation view by Pruning . To prune data, you need a pruning configuration table that specifies the filter conditions to limit There are several pruning techniques that exclude data sources of union nodes early on during processing if the sources are not required to serve the query. You create a pruning Accessibility & Sustainability System Status Ask a Question about the SAP Help Portal Find us on In this example, you use a pruning configuration table to specify the filter conditions for pruning the union node. To specify the pruning conditions for data sources, you have the following options: Define a constant with specific /Browse/Courses/Working with Calculation Views in SAP HANA Cloud/Union pruning Working Environment and Basic Concepts Introduction to the course Development environment Instead of specifying pruning relevant information in a table, you can also define pruning criteria by using the technique of constant mapping. btyi, tidax, 4zbj, sq9lz, vs9eq, vvkpbh, i8ds, juiwvp, ocuzx, 6ypjzs,