Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Behavior Changes to Analysis Services Features in SQL Server 2008

This topic describes behavior changes in Analysis Services. Behavior changes affect how features work or interact in SQL Server 2008 as compared to earlier versions of SQL Server.


SQL Server 2000 Behavior

SQL Server Behavior


Supports hidden or disabled levels in hierarchies.

Hidden or disabled levels are migrated as visible and enabled levels. Calculations that involve hierarchies that contain such levels might return unexpected results.


Supports the option to not include data members in parent-child dimensions.

Data members always exist in parent-child dimensions; data members can no longer be excluded from parent-child dimensions.

Multidimensional Expressions (MDX)

Function: CreateVirtualDimension

Expression will return Error.


Function: CreatePropertySet

Expression will return Error.


Statement: With Cache

Accepted syntax, but does nothing.


Statement: Create Cache

Accepted syntax, but does nothing.


Calculation precedence rules.

Calculation precedence rules have changed from previous versions of Analysis Services.

See Understanding Pass Order and Solve Order (MDX) and Performance Improvements for MDX in SQL Server 2008 Analysis Services.


Supports the option to specify dimension security so that a user can view a top level that is different from the top level of the hierarchy.

Top Level for dimension security is not supported. Members that are secured by using the Top Level setting will be visible after migration.


AutoCommit and AutoRollback in update.

Tries to commit a non-existing transaction fail. In SQL Server 2000 Analysis Services, the Update statement created its own transaction. In SQL Server Analysis Services, it does not.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft