Model Designer Query Properties

This section discusses the collections and objects used in a semantic query for information purposes.

In This Section

Collection/Object	Properties	Description
SemanticQuery Object	Name, Hierarchies, MeasureGroups, CalculatedAttributes, CalculatedEntities, Parameters, CustomProperties, EnableDrillthrough	Defines a semantic query.
Arguments Collection	Expression	Defines a set of arguments for a function.
AttributeRef Object	AttributeID, AttributeName	Defines an attribute reference node in a query expression tree.
BaseEntity Object	EntityID, EntityName	Defines the primary entity for a Hierarchy or Measuregroup.
CalculatedAttributes Collection	Expression	Contains a set of expressions that can be used throughout the query.
Details Object	Expression	Contains a set of detailed expressions to include in the results of the query.
EntityRef Object	EntityID, EntityName	Defines an entity reference node in a query expression tree.
Expression Object	Name, Path, ExpressionNode, CustomProperties	Contains an expression, along with an optional path that can be used to reach the entity, over which to evaluate the expression.
ExpressionNode Object		Defines a node in a query expression tree.
Filter Object	Expression	Contains the definition of a filter used in the query.
Function Object	FunctionName, Arguments	Defines a function node in a query expression tree.
Grouping Object	Name, Expression, Sorting, Filter, Details	Contains an expression by which to group data.
Groupings Collection	Grouping	Contains a set of groupings for a hierarchy.
Hierarchies Collection	Hierarchy	Defines the set of grouping hierarchies for a query.
Hierarchy Object	Name, BaseEntity, Filter, Groupings	Defines a grouping hierarchy for a query.
Literal Object	Value, Values, DataType	Defines the literal node in a query expression tree.
MeasureGroup Object	BaseEntity, HierarchyPaths, AutoHierarchyPaths, Measures, SubtotalSets	Defines a set of related detail expressions to include in the results of the query.
MeasureGroups Collection	MeasureGroup	Contains sets of detail expressions to include in the results of the query.
Measures Object	Expression	Contains the set of measure expressions in a measure group.
Null Object		Defines a null value node in a query expression tree.
Parameter Object	Name, DataType, Nullable, Cardinality, Expression	Defines a parameter to the query.
ParameterRef Object	ParameterName	Defines a parameter reference node in a query expression tree.
Parameters Collection	Parameter	Contains a set of parameters whose values can be used throughout the query.
Path Object	PathItem	Defines the steps (typically roles) needed to be followed in order to reach an entity.
RolePathItem Object	RoleID, RoleName, Recursion	Defines a role in a path.
SubtotalGroupings Collection	GroupingName	Defines a set of groupings by which to calculate subtotals.
SubtotalMeasures Collection	MeasureName	Defines a set of measures by which to calculate subtotals.
SubtotalSet Object	SubtotalGroupings, SubtotalMeasures	Defines a set of subtotals to calculate for measures in a measure group.
SubtotalSets Collection	SubtotalSet	Defines sets of subtotals to calculate for measures in a measure group.
Values Collection	Value	Defines a set of literal values.

See Also

Concepts

Model Designer Object Properties
Ad Hoc Reporting with Report Models
Working with Report Builder (Ad Hoc Reports)
Working with Model Designer

Help and Information

Getting SQL Server 2005 Assistance