Business Intelligence Geeky/Programming SQLServerPedia Syndication


Ok, I just spent a few hours debugging a cube that wasn’t bringing back any data. Checking all the relationships, the source data, the marts, etc, etc. And lo and behold, find out that a colleague commented out all the calculations, including the CALCULATE statement which says:

The CALCULATE command controls the aggregation of leaf cells in the cube.
If deleted or modified, the data within the cube will be affected.
This command should only be edited if you intend on manually specifying how the cube will be aggregated.

Remember, you NEED the “CALCULATE” command!

By Steve Novoselac

Director of Digital Technology @TrekBikes, Father, Musician, Cyclist, Homebrewer

5 replies on “SSAS Cube Rule #1 – YOU NEED CALCULATE”

Hello Steve,this was my problem, too. It was so horrible – no aggregation in my cube. I have solved my problem self and now i found your post. I'm glad I'm not the only one it happened to.BR Chris


Thanks for the quick response.

I had already solved the situation by creating a script with Calculate.
Once more thank you.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.