on 02-05-2017 3:19 PM
Hi All,
I have a "Parent" star join calc view that union 13 different "Child" calc views, each one of the child cala view is calculate different values of the same dimension, the final result is one view that combinstar-join-view.jpge all calculations.
Instead, I use filter to prevent a child view from execute when not selected, the problem is that when filtering on more then one value, it does not filter.
This works and executeonlywhen the user choose 1: if (in("MEASURE_CODE" ,1),1,0) , MEASURE_CODE is the dimension the user select in the report.
This works is executingall the time, regardless user selection: if (in("MEASURE_CODE" ,1,2),1,0)
I also tried to use union pruning for that but I face a long compilation time and also the pruning does not work, the view execute all the time regardless user selection.
HANA version 1.00.122.00
Thanks,
Guy
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.