7.0 Analysis Services Client and Local Cube Support

SQL Server Setup Help

7.0 Analysis Services Client and Local Cube Support

This table shows support for new server features by the Microsoft® SQL Server™ 7.0 OLAP Services client components and in a SQL Server 2000 Analysis Services local cube. When a feature may cause data to be translated incorrectly by a 7.0 client application, the server prevents the cube from being visible and prevents the client connection to the cube. If the absence of a feature in a local cube might change data values presented to the user, then a local cube using the feature cannot be created.

For each feature listed here, the table shows whether a cube containing a feature is visible on a 7.0 client application and if the cube is visible whether the feature itself is available on the 7.0 client application. For each feature, the table also shows whether a local cube can be created using the feature and whether the feature itself is supported in a local cube.

Feature	Cube is visible on 7.0 client	Feature available on 7.0 client	Can create local cube using feature	Supported in a local cube
Actions	Yes	No	Yes	No
Additional authentication methods	Yes	Yes	Yes	⁽²⁾
Calculated cells	No	No	No	No
Changing dimensions	Yes	No	Yes	No
Custom member formulas	No	No	No	No
Custom rollup formulas	No	No	No	No
Default members	No	No	Yes	Yes
Dimension security	No	No	No	No
DistinctCount	No	No	No	No
Drillthrough	Yes	No	Yes	No
Enhanced cell Security	Yes	Yes	Yes	No
Enhanced virtual dimensions⁽¹⁾	Yes	Yes	Yes	Not applicable
Exceeding 7.0 Limits⁽³⁾	No	No	Yes	Yes
Linked cubes	Yes	Not applicable	Yes	No
Member groups	Yes	Yes	Yes	Yes
Members with data	Yes	Yes	Yes	Yes
New MDX functions	Yes	No	Yes	⁽⁴⁾
Parent-child dimensions	No	No	Yes	Yes
Ragged dimensions	Yes	Yes	Yes	Yes
ROLAP dimensions	Yes	Not applicable	Yes	No
Siblings with same names	No	No	Yes	Yes
Write-enabled dimensions	Yes	No	Yes	No

1    The earlier limit of 760 members in a virtual dimension does not apply.
2    Cell security is not supported on local cubes.
3    Exceeding 127 measures in a cube, 63 dimensions in a cube, or 128 levels in a cube. For information about SQL Server 2000 Analysis Services limits, see Specifications and Limits.
4    For the SQL Server 7.0 OLAP Services client, new Multidimensional Expressions (MDX) functions are not supported. For local cubes, new MDX functions are available, except for LookUpCube. Calculated members using LookUpCube in local cubes are not created.

previous page start next page