|
View Blog
Oct
22
Written by:
Bernhard Zehetgruber
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.
Tags:
4 comments so far...
Re: SSAS: No data visible in SQL Server Analysis Services cube even if the cube was processed without failure
cool hint ... I have another one for you ... you should also not delete your whole project ... afterwards it will not work either ...
By Samuel E. on
8/18/2009 10:15 PM
|
Re: SSAS: No data visible in SQL Server Analysis Services cube even if the cube was processed without failure
hihihi! that's great! thank you man!
By Bruno Ovista on
8/18/2009 10:15 PM
|
Re: SSAS: No data visible in SQL Server Analysis Services cube even if the cube was processed without failure
thanks - there should be a warning on deleting that!
By sean on
11/19/2009 12:14 AM
|
Re: SSAS: No data visible in SQL Server Analysis Services cube even if the cube was processed without failure
I support the previous idea that there should be a warning on deleting that. On the one hand I've already heard a lot of complaints concerning that, but on the other hand it seems to be quite clear that such programmes as the CALCULATE Statement should never be deleted. In this regard I understand that humorous and ironic tone of the first commentator. But still, if such a thing has happened to you, I know that the CALCULATE Statement can be easily downloaded on search on torrents http://www.picktorrent.com . Have a try)))
By Judy on
12/23/2009 1:11 AM
|
|
Newsletter
Sie möchten im Newsletter über aktuelle technische Entwicklungen und Neuigkeiten rund um cubido informiert werden?
Newsletter abonnieren ...
|