SQL Server Performance Forum – Threads Archive
The option for Calculated CellsHi, I came across the following article which talks about creating and using Calculated Cells:
http://www.databasejournal.com/features/mssql/article.php/10894_3106671_2 However in Analysis services, I could not find any option for Caculated cells [:0] Any clues?
Maybe you’ve got the Analysis Services 2000 Developer Edition instead of the Analysis Services 2000 Enterprise Edition? In fact the Wizard for realizing calculated cells is present only in the Enterprise Edition.
Thanks for the reply Vania. Maybe that is the reason. Is there any way to find out if one has the Developer Edition or the Enterprise Edition?
Frankly speaking, I don’t know a sharp method. However, I have an 8.0.760.0 version of AS2000, and this is a Developer Edition, whilst on another server have an 184.108.40.206 version, and this is an Enterprise Edition…
Hope it helps.