A query defines the data to be retrieved from the database. It consists of a source, a selection, detailed and summary filters, and a dimension Information. Query hints can be supplied. A query does not define the structure or presentation of the retrieved data.
Repreesents a single member.
A V5 expressin that results in a single calculated member.
Represents a member property from either a level or hierarchy.
Represents a single measure. For the most part, measures are the same as members.
A V5 expressin that results in a single calculated member.
Describes an explicit set of members. Generates a V5 expressions of the form set(MUN1, MUN2, ...).
Describes the set of children of a member. Generates a V5 expression of the form children(MUN).
A V5 expression that results in a set of members.
The members of a level.
The member of a hierarchy
References a named set from the model.
The tuple is represented by the set of members. Each member must be from a different dimension. The tuple itself must be placed into a hierarchy indicated by dataItemHierarchy. Generates a V5 expression of the form tuple(MUN1, MUN2, ..)
The selection identifies the metadata elements upon which the query is based. This is analogous to a projection from the source.
a list of member expressions. the list is interpreted as a tuple of members.
There can only be one contextSlicer per dimension or hierarchy depending on the data source.
Defines the context for this dimension. Currently, only a list of members is supported, but in the future it could also support a contextCalculatedMember element.
This element indicates that the slicer will be converted into a parameter against either the hierarchy or level when the report is run.
If true, then slicer will appear as a single member parameter. If false, the slicer will appear as a multiple value parameter.
Level Unique Name
Reference to a member
A list of member references
A tuple definition. A tuple can only reference one member per dimension.
Refers to a member or measure in the tuple.
Member Property Unique Name
Sort the set by the given tuple. Default is to sort by caption, but can be overridden to sort by a tuple or member property.
If the set contains members from different levels in the hierarchy, then if this property is true it will sort them without taking the hierarchy into consideration, if false, then the items will be sorted within each level of the hierarchy.
Reference to a hierarchy
Reference to a dimension
Hierarchy Unique Name
Member Unique Name
Dimension Unique Name