We have got a huge query with almost 250 measures and 30 dimensions.
Our understanding is that if we bring this query in design studio and create multiple small initial views of the same query and use them to map with our layout then it would improve the performance.
But the loading time of the dashboard is still the same as using the original (huge) structure of the query and there is no improvement in our performance.
Should we split the original query and have small subset of the queries or should we still continue with the initial views?
Also, can we use initial views of the query for parallel processing if it is the same query?