SSAS tabular model slow

Question

Hi i'm working on a large SSAS tabular model and it's so slow every time i change even the smallest thing it goes away and thinks about it for ages.

The model is massive and pretty sure that's the problem but I've inherited it like that so at the moment cant do anything about that.

Is there a way to stop SSAS loading all the data (or less data) while i'm developing the model in visual studio?

Answer 1

I encountered the same problem in my cube; apparently due to the hundreds of measures my model has. I tried the process clear method described by Vercelli but it did not help in my situation. To resolve this issue I did the following:

• Open the project in VS
• Go to Model in the Menu
• Go to Calculation Options
• Select Manual Calculation

This brought my time down from 7 - 10 minutes doing something as simple as hiding a measure to 3 to 5 seconds.