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