To ensure the filters are pushed down, it is advisable to avoid such calculations in Calc engine and let HANA filter the data as earlier in the execution as possible. In this blog, I would like to highlight the performance improvement with the approach. The performance from this option can...
Now notice that we don’t have to pass in any filter criteria for selecting the times slices, that logic is already done for us. All of the data as shown through data preview, notice how the three flags tell us the story. This query will show us the first three months that have ...