MS SQL Server OLAP - CALCULATED CELL/NOT AVAILABLE ON SQL 2000 AS

Author

CALCULATED CELL/NOT AVAILABLE ON SQL 2000 AS

fsanchez

2005-12-16, 11:23 am

Hi,
I was recently told about a feature called Calculated Cell and
unfortunately, I am unable to see this feature on my version of SQL Server
2000. Is there way I can verify which version I have or do I need to set a
parameter for this feature to be available.

Regards,
Fernando Sanchez

Deepak Puri

2005-12-16, 1:23 pm

Hi Fernando,

Calculated cells were not available in AS 2000 Standard Edition, but are
added in AS 2005 Standard Edition:

http://groups.google.com/group/micr....olap/msg/1f3d6
4b3b1b59955[color=da
rkred]
Newsgroups: microsoft.public.sqlserver.olap
From: Deepak Puri
Date: Thu, 06 Oct 2005 08:36:51 -0700

Subject: Re: Conditional formatting without calculated cells?

The 2 options that come to mind are:

- For AS 2000, you can wrap it in a calculated measure, but then
drillthrough on the measure won't be possible.

- Upgrade to AS 2005 Standard Edition (release date Nov.7), which
supposedly supports calculated cells:

http://sqljunkies.com/WebLog/mosha/...03/19/9223.aspx

Analysis Services 2005 Editions differentiation
..
In case of Analysis Services, you will immediattely see, that cell
calculations, that were only part of Enterprise Edition in AS2K, now are
available in all editions.
..[color=darkred]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.droptable.com ***

fsanchez

2005-12-20, 8:25 pm

Hi Deepak,
Thanks for the info...I am in the process of getting the upgrade version
(evaluation) until it is actually purchased.

I do appreciate the info and the guidance.

Regards,
Fernando Sanchez

"Deepak Puri" wrote:

> Hi Fernando,
>
> Calculated cells were not available in AS 2000 Standard Edition, but are
> added in AS 2005 Standard Edition:
>
> http://groups.google.com/group/micr....olap/msg/1f3d6
> 4b3b1b59955
> Newsgroups: microsoft.public.sqlserver.olap
> From: Deepak Puri
> Date: Thu, 06 Oct 2005 08:36:51 -0700
>
> Subject: Re: Conditional formatting without calculated cells?
>
> The 2 options that come to mind are:
>
> - For AS 2000, you can wrap it in a calculated measure, but then
> drillthrough on the measure won't be possible.
>
> - Upgrade to AS 2005 Standard Edition (release date Nov.7), which
> supposedly supports calculated cells:
>
> http://sqljunkies.com/WebLog/mosha/...03/19/9223.aspx
>
> Analysis Services 2005 Editions differentiation
> ..
> In case of Analysis Services, you will immediattely see, that cell
> calculations, that were only part of Enterprise Edition in AS2K, now are
> available in all editions.
> ..
>
>
> - Deepak
>
> Deepak Puri
> Microsoft MVP - SQL Server
>
> *** Sent via Developersdex http://www.droptable.com ***
>

Sponsored Links