Export (0) Print
Expand All

Model Designer Query Properties

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

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft