Help! My cube is getting to big!

The title pretty much says it all. The data model in my cube, which lives in Azure Analysis Services (AAS). Which means that at some point the performance of the cube will suffer which means anything you build on top of it will also experience loss of performance. Facing a similar problem? Here’s my way of solving our woes.

Problem

You already have, or this is the case very soon, too much data in your cube. This impacts the performance of not only the cube, but everything you’ve build on top of it.

Of course you can just scale-up to a more expensive AAS tier. But even that has it’s limits. Plus: not everyone has the budget to do so.

Solution part 1: indexing, indexing, indexing.

Solution part 2: do I really need all this data?

Solution part 3: do I really need this level granularity?

Solution part 4: does everything really need to be in 1 model?

In conclusion

The featured image of this post was found on Google. I don’t own it.

One Reply to “Help! My cube is getting to big!”

Leave a Reply

Your email address will not be published. Required fields are marked *