How can I tell whether the Analysis Services installed on a SQL Server 2000
computer is the Enterprise or Standard edition?

The SQL Server is Standard Edition 2000, yet the Analysis services seems to
support some features that are only supposed to be in the Enterprise version
of Analysis Services, eg. calculated cells.

Glen

There is a DSO property called Edition on the server which returns whether
or not this is EE or not. See Appendix J of the AS Operations Guide to do
this.
http://www.microsoft.com/technet/pro.../anservog.mspx

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Glen" <glittle (AT) sunwaptasolutions (DOT) RemoveThis.com> wrote

Thanks.

That script reports a development server as "Enterprise Edition" (which is
correct), and reports the production server as "Standard Edition" (which is
correct).

So that raises the question, why are "with cell calculation" clauses in MDX
statements working fine in Standard Edition?

The documentation at
(http://msdn.microsoft.com/library/de...entid=28000409)
clearly says that "Calculated Cells" are "N/A" in the Standard Edtion".

Thanks,
Glen


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Sometimes we support a limited use of a function even though we don't
support full unlimited use in-general. As an example, let's choose
partitioning. Partitioning is technically an EE-only feature. But you will
notice that the API level you can still create upto 3 partitions (the UI
wont' let you, but you can using DSO). The reason for that is that
incremental processing actually uses partitioning to do its work. Behind
your back, when you do an incremental process the system creates a temporary
partition with the delta fact rows you give it and then it merges that
partition back into the originnal one. Likewise when you do writeback, you
are actually using a separate partition under the covers. So we use
partitioning to implement Standard Edition features; although in-general we
disable the UI for partitioning and limit the number to three. I wouldn't be
surprised at all if a similar thing applied to cell calculations.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Glen" <glittle (AT) sunwaptasolutions (DOT) RemoveThis.com> wrote