Showing posts with label calculation-view;. Show all posts
Showing posts with label calculation-view;. Show all posts

Saturday, 25 June 2016

Effective Query pruning using Constant Column in UNION node

So far we have known different modeling techniques for implementing business scenarios which include data from different sources, but need to be reported together in the output. The classic example for HANA modeling workshop is to display the “Actual” and “Planned” data, which can be combined together in a Calc view using UNION operator.

Effective Query pruning using Constant Column in UNION node

Fig 1. Actual vs Planned implementation using Projection nodes in UNION