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!
5 replies on “SSAS Cube Rule #1 – YOU NEED CALCULATE”
Good to know.
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
I accidentally removed the Calculate command from the Calculations tab, how do I reset it?
You have to go into the MDX script area
Thanks for the quick response.
I had already solved the situation by creating a script with Calculate.
Once more thank you.