SemanticQuery Object (Model Designer)

Defines a semantic query.

Properties

Name Cardinality Type Description

Hierarchies

0-1

Object

A hierarchy of groups used in the query.

MeasureGroups

0-1

Object

A set of measures to display. If Hierarchies is not specified or there is no Hierarchy that contains Groupings, this object is required.

CalculatedAttributes

0-1

Object

A set of expressions that can be used throughout the query.

Parameters

0-1

Object

A set of parameters to the query.

CustomProperties

0-1

Object

Custom properties for the query.

EnableDrillthrough

0-1

Boolean

Indicates whether the query should have an optional DrillthroughContext parameter that identifies additional filter information for the query. DrillthroughContext is a reserved parameter name and cannot be used as the value of a ParameterName property.

Remarks

This object can be used as the root node of an XML tree in the SMDL namespace. In this case, the XML represents a Semantic Model Query Language (SMQL) query.

For more information, see Drillthrough Context Parameter Values.

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