Skip to Content
0

Filter does not work with more than one value

Feb 05, 2017 at 03:19 PM

63

avatar image

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

star-join-view.jpg (180.5 kB)
10 |10000 characters needed characters left characters exceeded

Please provide some insight into your source data structure. At first sight it looks like you're trying to use the STAR JOIN to operate on a EAV data model or something similar.

0

Hi Lars,

What you mean by EVA?

the model contain 13 Calac views with different calclations and business rules, combile in to one star join.

Regards,

Guy

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers