By Bernhard Zehetgruber on
10/22/2008 6:30 AM
I built a lot of new Calculations in a SSAS cube. After finishing my work I was deleting all unused calculations even the CALCULATE statement.
DON'T DO THIS:
The CALCULATE statement is essential for building the cube. This statement aggregates the leaf data and if it is not given no data will be writen in the leaf of the Cube. Therefore the Cube will be processed without any failure but no data is visible when you are browsing the data, because no leaf has got a aggregated value and is empty.
--> never Delete the CALCULATE Statement.