We facing performance issue, we want to change the sparse/dense configuration order,
I know there are two main approch, what is the best in terms of calcultions , aggrgations, from your
1. Put the in hour glass order - most dense to let, less sparse to most and then non agg dimension.
2. agg dims most to least non agg
Sometimes the hourglass also didn't give good performance. It depends on the system to system
what is best for your system performance.
Place your growing sparse dimensions later even having less no. of members currently
if you think that the dimension will grow in future.