Skip to Content
0
Jun 22, 2020 at 10:14 AM

HANA Performance - Union Pruning

438 Views

Hello Team,

I read that with union pruning configurations , we can control the data sources with in the union node which needs to be executed/skipped as per the reporting SELECT statements where clauses.

But, I have different kind of pruning/performance requirement , Just wanted to know whether it can be possible or not with UNION in calculation view.

Use case:

1. We have different customers in our business (They are grouped under 3 types of customers).

2. Each customer type has their own business logic & accordingly 3 HANA views are developed

So, I want to create a Final View by performing a Union with all 3 HANA views which are created for each customer type.

Based on the customer who triggers this Final HANA view, It has to Skip the other two HANA views inside the Union. Is that possible with Union Pruning Configuration??