Hierarchy Object (Model Designer)

Defines a hierarchy used to group within a query.

Properties

Name Cardinality Type Description

BaseEntity

1

Object

The base entity for the hierarchy. Each instance of the entity generates one row of details which is grouped in the hierarchy, except when those instances are filtered out.

Filter

0-1

Object

A filter to apply to the base entity for filtering of the row details.

Groupings

0-1

Object

An ordered list of groupings for the hierarchy.

See Also

Concepts

Model Designer Query Properties
Model Designer Object Properties
Model Designer
Model Designer Object Properties
Ad Hoc Reporting with Report Models
Working with Model Designer

Help and Information

Getting SQL Server 2005 Assistance