Represents a query. Defines references to query subject or table that can be in the same or different module. used to resolve one part name in query item. Defines whether the object is a copy or a reference. Causes a query to generate the SQL commands used. If set to minimized, only the required query items appear in the generated SQL. If set to asView, all query items appear. Specifies that all query items appear in the generated SQL. Specifies that only the required query items appear in the generated SQL. Related with the contextSensitiveJoinSelection governor, when the setting is explicit If set to true, the querySubject will be used in the joinPath number of rows of the query subject in text format, e.g. 1K, 2M. Defines the intended usage of the query subject. Specifies that the querySubject usage is automatic and therefore it will be computed by the planning code. Specifies that the querySubject refers to a bridge table. Specifies that the querySubject will be treated as a summaryQuery. Property that is processed in relational query planning when the query subject usage is specified as summaryQuery. Defines a query against the specified database. reference to database. A query that represents the union, intersection or except of query subjects or tables. union can have more than two query subjects or tables. reference to other query subjects or tables. A query that represents the join of two query subjects or tables. SQL definition. Specifies the level of flexibility the system is allowed in optimizing the SQL from this element, before presenting it to the data source. Cognos SQL can be optimized by the system and combined with other SQL before being sent to the data source. Native SQL cannot be modified except by macro substitution, but can be combined with other SQL into a single SQL query to send to the data source. Pass-through SQL cannot be modified except by macro substitution, and cannot be combined with other SQL. It must be sent to the data source as a stand-alone query. However, results can be combined with results of other queries. automatic is resolved to true or false. Rule: true if the usage of the query item/calculation is attribute, and the data type supports precise value comparison (e.g. false for float/double because they are approximate number) if sortList is absent, sort on the query item/calculation ASC NULLS LAST. reference to query item/calculation. the facet value combined with context will be unique if context is unique. e.g. Week has Year as context. Year + Week is unique. WeekDay has Week as context. Year + Week + WeekDay is unique. If context is absent, the facet is unique. reference to context query item/calculation. define the behavior if context is missing in the query. issue a warning. context is required in query (project or in filter). provide detail information if context is missing in the query. A query item from a query subject Defines the intended usage of the query item. Specifies that the usage is not known. Specifies that the object is to be treated as an identifier. Specifies that the object is to be treated as a fact. Specifies that the object is to be treated as an attribute. Specifies the format for the parent object. Specifies the aggregation rule. High level datatype. If facetDefinition is absent, treat it as automatic (see enabled in facetType). Concepts from SMD. Specifies the query item data classification and whether it represents a geographic or time related concept. minimum value retrieved during SMD. The text format is: sign + decimal + abbreviation for thousand, million, billion. Example: -100, -1.3K, -2.1M, -0.4G maximum value retrieved during SMD. The text format is: sign + decimal + abbreviation for thousand, million, billion. Example: 50, 3K, 5M number of distinct values retrieved during SMD. The text format is: decimal + abbreviation for thousand, million, billion. Example: 5, 4.5K, 1G The aggregation rule. same as V5 aggregate name. Aggregation is not supported for this object. Aggregation is computed as an average of the values in the result set for this object. The aggregation rule is determined automatically at run time. Aggregated values are computed by aggregating the elements of the expression rather than the result. For example, if the aggregate rule for Q1_a is set to total, and the rule for q1_b is set to average, then if this query item is based on the expression (QI_a / QI_b) * 100, the aggregate is computed as: ( total(QI_a) / average( QI_b ) ) * 100. Aggregation is computed as a count of the items in the result set for this object. Aggregation is computed as a count of unique items in the result set for this object. Excludes zero and NULL values. Aggregation determines the maximum value in the result set for this object. Aggregation determines the median value in the result set for this object. Aggregation determines the minimum value in the result set for this object. Aggregation determines the standard deviation in the result set for this object. Aggregation determines the total of the values in the result set for this object. Aggregation determines the variance in the result set for this object. Specifies that this object has no rows. Specifies that this object has one row only. Specifies that this object can have many rows. References a query subject or table. The minimum number (cardinality) of rows that will match this end of the relationship. Normally zero or one. The maximum number (cardinality) of rows that will match this end of the relationship. The value is normally one or many. join two query subjects / tables. Defines a reference to a relationship in a referenced module. Defines whether the object is a copy or a reference. References the left query subject or table in a relationship. References the right query subject or table in a relationship. Presence of this element triggers filter join optimization in which is generated in order to optimize local join processing. The filter will be applied to the many side of the relationship. If there is no many side or if both are many, then the filter will be applied to the right side. No predicate is generated. Generates an IN predicate of constant values. Generates a BETWEEN predicate comprised of MIN and MAX values of the join keys. Generates a table row constructor form of the IN predicate. A lookup table for controlling query generation. As a minimum, the _env and _governor maps are required. Specifies the value to use if no key match is found. If not set, external sources for parameterMaps of this name may be searched. During macro evaluation, the parameter map will be reloaded if it was loaded more than the specified number of seconds ago. The default is -1, which means that the data will be loaded only once. When set to true, then the map will be loaded one key-value at a time, when a key-ed accesses is made. When a getAllEntries access is made, then this flag is ignored. Specifies that the object is an entry in a parameter map. Defines the unique identifier for the object. The value that gets returned when the parameter map locates the key value. Specifies that the set of entries in the parameterMap is based on two queryItem references: one represents the set of keys, and the second represents the set of values. The queryItems being referenced must belong to the same querySubject. When a parameterMap has been defined, the query looks for this unique identifier when it executes and returns the value in the valueRef element. When a parameterMap has been defined, and the unique identifier (keyRef) has been found by the query, this value gets returned when the query executes. Defines an expression aggregate that returns a value. High level datatype. Defines the intended usage of the query item. Specifies that the usage is not known. Specifies that the object is to be treated as an identifier. Specifies that the object is to be treated as a fact. Specifies that the object is to be treated as an attribute. If facetDefinition is absent, treat it as automatic (see enabled in facetType). Specifies the aggregation rule. Specifies an expression used to query the data in the specified database. represents a set of items related to each other as “coarse to finer”. represents an item in drillGroup. reference to a query item in the same module. Reference to table that defines the columns to be split into