Does anyone know if there is a difference in anaysis server shipped with the
enterprize version and the standard version?

yes, there is some differences
look at the SQL Server web site for a complete list.
But there is the most importants point not supported in the standard
edition:
* Dimension write back
* Cube Partitioning
* Real time OLAP


"pat" <pat (AT) discussions (DOT) microsoft.com> a écrit dans le message de news:
4B3D5940-9A56-4FFF-9B69-117207660828...soft (DOT) com...

From BOL, Analysis Services Features Supported by the Editions of SQL Server
2000
This table shows the Analysis Services features and the editions of SQL
Server 2000 that support them.



Analysis Services Feature


Enterprise Edition

Standard Edition

Personal Edition

Developer Edition

Desktop Engine

SQL Server CE Enterprise Evaluation Edition
Analysis Services Supported Supported Supported Supported N/A N/A
Supported
User-defined OLAP Partitions Supported N/A N/A Supported N/A N/A
Supported
Partition Wizard Supported N/A N/A Supported N/A N/A Supported
Linked OLAP Cubes Supported N/A N/A Supported N/A N/A Supported
ROLAP Dimension Support Supported N/A N/A Supported N/A N/A Supported
HTTP Internet Support Supported N/A N/A Supported N/A N/A Supported
Custom Rollups Supported Supported Supported Supported N/A N/A
Supported
Calculated Cells Supported N/A N/A Supported N/A N/A Supported
Writeback to Dimensions Supported N/A N/A Supported N/A N/A Supported
Very Large Dimension Support Supported N/A N/A Supported N/A N/A
Supported
Actions Supported Supported Supported Supported N/A N/A Supported
Real-time OLAP Supported N/A N/A Supported N/A N/A Supported
Distributed Partitioned Cubes Supported N/A N/A Supported N/A N/A
Supported
Data Mining Supported Supported Supported Supported N/A N/A Supported



--
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.

"pat" <pat (AT) discussions (DOT) microsoft.com> wrote

Sorry. This didn't format well at all. Just go to SQL Server books online,
look under the topic:

"Features Supported by the Editions of SQL Server 2000"

This lists all of the various features; including Analysis Services.

Also, this is discussed in:
http://www.microsoft.com/sql/techinf...skChooseEd.asp

--
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.

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