Analysis Services Programming
Organization of Multidimensional Data
PivotTable® Service supports three different hierarchy types. The following table contains links to the topics that discuss each type, and how to address compatibility with existing client applications developed for Microsoft® SQL Server™ 7.0 OLAP Services.
| Topic | Description |
|---|---|
| Balanced Hierarchies | Describes how SQL Server 2000 Analysis Services implements dimension hierarchies in which all leaf nodes of a level are the same distance from the root node |
| Ragged Hierarchies | Describes how Analysis Services implements dimension hierarchies in which one or more levels do not contain members in one or more branches of the hierarchy |
| Unbalanced Hierarchies | Describes how Analysis Services implements dimension hierarchies in which leaf nodes differ in their distances from the root node |
| Using the MDX Compatibility Property | Describes the use of this property to address compatibility with existing client applications |