I have requirement to display straight table. Which is having 15 dimensions and 18 metrics. We have totally 100 million records/3 Years data. I have implemented the above. But the problem with the filter on metrics. They want 4 filters either by input box or sliders. Straight able has to display rows which are greater than selected value in slider.
Here i am getting issue with implementing filters. I have to keep 4 "If else" conditions (for each slider value) on all the metrics (18 metrics). Which affects the straight table performance.
The table is having metrics like previous 3/6 months qty,3/6months sales, 3/6 motnths savings.. like that. And among those 6 metrics are calculating based on input box. So i cant move all the metrics to script. I can move only few metrics to script and make as dimension, after that i have to create calculated dimension to apply filter, which is again having performance issue. Please suggest me to solve this problem.