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, ..) Comment describing your root element Information related to sharing the data item. The name used to reference the data item in a sharing scenario. The shareName must be unique within the report. Represents a custom grouping calcuation stored as a high level grouping of relational names or dimenstional members or value ranges associated with a name. Custom group for relation dataitems defined by matching specified values. Custom group for dimensional or relational data items defined by ranages of values. Represents what to do with values in the refDataItem that do not fall into one of the defined custom groups. Other values that do not match the custom groping are returned as normal. Other values that do not match the custom groping are returned as null values. Other values that do not match the custom groping are returned as a single label. Represents a measure percentage calcuation. References a dataItemMeasure or a dataItemCalculatedMeasure from the current query that is the actual measure in the percentage calculation. 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. References a dataItemCalculatedMember or a dataItemCalculatedMeasure from the current query 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 Removes members from a set. If true, retains duplicate members after the union. Removes the members from the base set and then positions them at the top of the resultant set. Removes the members from the base set and then positions them at the bottom of the resultant set. Custom group for dimensional dataitems defined by lists of members. Represents what to do with any members from the base set that do not fall into one of the defined custom groups. Other members that do not match the custom groping are included in the set. Other members that do not match the custom groping are excluded from the set. Other members that do not match the custom groping are grouped under as a single label. Represents a simple or compound set filter condition Defines a condition against the member caption. Defines a condition against a string member property. The value attribute must be provided for all operators except isNull and isNotNull. Defines a numeric condition. The condition can be for either a tuple or a member property. The value attribute must be provided for all operators except isNull and isNotNull. Defines a numeric condition. The condition can be for either a tuple or a member property. The value attribute must be provided for all operators except isNull and isNotNull. A single escape character that can be used to escape wildcard characters in the value text. This is not ideally modelled. filterExpression should be moved into filterDefinition and filterDefinition should be required. This change would require a spec version change and upgrade. A filter must only contain one of filterExpression or filterDefinition. {required} When optional, this filter will be applied only if all the parameters referenced by the filter expression have been provided with values. If the filter expression does not refer to any parameters, then this filter will always be applied. When prohibited, this filter will never be applied, which is useful for testing and authoring purposes. Default: "required". {false} Specifies that when "false", this condition will be applied to detail database rows from the tabular result set prior to aggregation and summarization. Any reference to a fact (aggregate) item in this expression will be interpreted as the individual database value before it has been summarized. When "true", this condition will be applied to the summarized rows; that is, after one or more detail rows have been aggregated into one summary row. Any reference to a fact (aggregate) item in this expression will be interpreted as the aggregate value of the summarized row(s). This attribute has no effect upon references to non-aggregate items, nor is it effective when automatic summarization is disabled (see "autoSummary" attribute of the selection element). This attribute has no effect in all cases for OLAP data sources. This is not ideally modelled. filterExpression should be moved into filterDefinition and filterDefinition should be required. This change would require a spec version change and upgrade. A filter must only contain one of filterExpression or filterDefinition. {required} When optional, this filter will be applied only if all the parameters referenced by the filter expression have been provided with values. If the filter expression does not refer to any parameters, then this filter will always be applied. When prohibited, this filter will never be applied, which is useful for testing and authoring purposes. Default: "required". The set of values being filtered (in or not in) should also include any null values. Indicates that when the report is run in the viewer the user should be prompted for the value(s). The name the parameter will have in the report. If no name is specified one will be generated by the server. The name will be used by generated prompt pages.