Ragged dimensions have at least one member whose logical parent is not in the level immediately above the member, such as is the case of countries that do not have a state or province level between the country and city levels. For more information, see Ragged Dimension Support.

Enhanced Virtual Dimensions

Virtual dimensions have better performance and greater flexibility than in earlier versions. They can be based directly on columns in another dimension's table and include multiple levels. Virtual dimensions are no longer limited to 760 members. For more information, see Virtual Dimensions and Virtual Dimensions Created in Version 7.0.

Custom Rollup Formulas and Custom Member Formulas

Cube cell values associated with members can be calculated according to custom expressions rather than the aggregate functions of measures. The expressions can be applied to all the members in a level or individual members. For more information, see Custom Rollup Formulas and Custom Member Formulas.

Member Groups

System-generated member groups can be used to provide an intermediate level for drilldown between a level with few members and one with numerous members or to accommodate members that have more than 64,000 children. For more information, see Member Groups.

Default Members

Default members can be specified for each dimension and varied by role. They control end users' default views of cubes that include the dimension. For more information, see Set Default Member Dialog Box and Custom Rules in Dimension Security.

Dimension Filters

A filter (WHERE clause expressions) can be used to limit the dimension table rows that are included in the dimension. The filter is specified in the Source Table Filter property of the dimension. For more information, see Properties Pane.

Dimension Security

You can use roles to control end user access to dimensions. For each role, you can limit access to individual dimensions, levels, and members, and you can set various read and read/write permissions. For more information, see Dimension Security.

Enhanced Cell Security

OLAP Manager now includes dialog boxes for defining cell security by setting role options to control end user access to cube cells. You can limit a role's access to any combination of a cube's cells and can vary the read and read/write permission of the role. For more information, see Cell Security.

Additional Authentication Methods

You can use Kerberos, NT LM Security Support Provider, or other providers that use the Security Support Provider Interface (SSPI) to perform authentication For more information, see Server Security.

SQL Server 2000 Preview 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19