• Happy to help. Although if you are hitting these problems now (with the increase in data) perhaps it's time you considered whether SSAS Tabular is appropriate? Or can you reduce the data size in another way (do users have to see full history, for example)? Could you break up the tabular model into smaller individual cubes?

    I would say if the answer is positive to the last question then it may be time to think about a multidimensional cube instead. Just my opinion, but I'd much rather be administering one large cube rather than 10 small ones 😀


    I'm on LinkedIn