Dimension Enhancements

Dimension Enhancements

SQL Server 2000

This release of Microsoft® SQL Server™ 2000 Analysis Services adds significant functionality to OLAP analysis with a number of new dimension types, features, and improvements.

Parent-Child Dimensions

A new parent-child dimension type supports hierarchies based on parent-child links between members in columns in a source table. Such hierarchies represent structures that include organization charts and part assemblies. Data members can be used to provide data for nonleaf members, such as the direct commission amount for a sales department manager or the individual salaries for all members in an organizational chart. For more information, see Parent-Child Dimensions.

© 2016 Microsoft