analytics/schemas/moser/2.0/business.xsd

<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSpy v2016 sp1 (x64) (http://www.altova.com) by IBM SWG CANADA (IBM SWG Canada) -->
<!--
 Licensed Materials - Property of IBM

 IBM Cognos Products: moser

 (C) Copyright IBM Corp. 2015, 2016

 US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
-->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified" version="2.0">
	<xsd:include schemaLocation="metadata.xsd"/>
	<xsd:element name="querySubject">
		<xsd:annotation>
			<xsd:documentation>Represents a query.</xsd:documentation>
		</xsd:annotation>
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="objectType">
					<xsd:sequence>
						<xsd:element name="ref" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
							<xsd:annotation>
								<xsd:documentation>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.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="instanceType" type="instanceType" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>Defines whether the object is a copy or a reference.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="generateSQL" default="asView">
							<xsd:annotation>
								<xsd:documentation>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.</xsd:documentation>
							</xsd:annotation>
							<xsd:simpleType>
								<xsd:restriction base="xsd:NMTOKEN">
									<xsd:enumeration value="asView">
										<xsd:annotation>
											<xsd:documentation>Specifies that all query items appear in the generated SQL.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="minimized">
										<xsd:annotation>
											<xsd:documentation>Specifies that only the required query items appear in the generated SQL.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
								</xsd:restriction>
							</xsd:simpleType>
						</xsd:element>
						<xsd:element name="useInJoinPath" type="xsd:boolean" default="false" minOccurs="0">
							<xsd:annotation>
								<xsd:documentation>
									<para>Related with the contextSensitiveJoinSelection governor, when the setting is explicit</para>
									<para>If set to true, the querySubject will be used in the joinPath</para>
								</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="numberOfRows" type="xsd:string" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>
									<para>number of rows of the query subject in text format, e.g. 1K, 2M.</para>
								</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="querySubjectUsage" default="automatic" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>Defines the intended usage of the query subject. </xsd:documentation>
							</xsd:annotation>
							<xsd:simpleType>
								<xsd:restriction base="xsd:NMTOKEN">
									<xsd:enumeration value="automatic">
										<xsd:annotation>
											<xsd:documentation>Specifies that the querySubject usage is automatic and therefore it will be computed by the planning code.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="bridge">
										<xsd:annotation>
											<xsd:documentation>Specifies that the querySubject refers to a bridge table.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="summaryQuery">
										<xsd:annotation>
											<xsd:documentation>Specifies that the querySubject will be treated as a summaryQuery.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
								</xsd:restriction>
							</xsd:simpleType>
						</xsd:element>
						<xsd:element name="useLocalCache" type="xsd:boolean" default="false" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>
									<para>Property that is processed in relational query planning when the query subject usage is specified as summaryQuery.</para>
								</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="columnDependency" minOccurs="0" maxOccurs="unbounded">
							<xsd:complexType>
								<xsd:sequence>
									<xsd:element name="ref" type="xsd:string" minOccurs="1" maxOccurs="1"/>
									<xsd:element name="keyRef" type="xsd:string" minOccurs="1" maxOccurs="unbounded"/>
								</xsd:sequence>
							</xsd:complexType>
						</xsd:element>
						<xsd:element ref="queryItem" minOccurs="0" maxOccurs="unbounded"/>
						<xsd:element ref="filter" minOccurs="0" maxOccurs="unbounded"/>
						<xsd:choice>
							<xsd:element name="dbQuery" minOccurs="0" maxOccurs="1">
								<xsd:annotation>
									<xsd:documentation>Defines a query against the specified database.</xsd:documentation>
								</xsd:annotation>
								<xsd:complexType>
									<xsd:sequence>
										<xsd:element name="ref" type="xsd:string" minOccurs="1" maxOccurs="unbounded">
											<xsd:annotation>
												<xsd:documentation>reference to database.</xsd:documentation>
											</xsd:annotation>
										</xsd:element>
										<xsd:element ref="sql" minOccurs="0" maxOccurs="1"/>
									</xsd:sequence>
								</xsd:complexType>
							</xsd:element>
							<xsd:element name="queryOperation" minOccurs="0" maxOccurs="1">
								<xsd:annotation>
									<xsd:documentation>A query that represents the union, intersection or except of query subjects or tables. union can have more than two query subjects or tables.</xsd:documentation>
								</xsd:annotation>
								<xsd:complexType>
									<xsd:sequence>
										<xsd:element name="ref" type="xsd:string" minOccurs="2" maxOccurs="unbounded">
											<xsd:annotation>
												<xsd:documentation>reference to other query subjects or tables.</xsd:documentation>
											</xsd:annotation>
										</xsd:element>
										<xsd:element name="setOperation" default="UNION">
											<xsd:simpleType>
												<xsd:restriction base="xsd:NMTOKEN">
													<xsd:enumeration value="UNION"/>
													<xsd:enumeration value="INTERSECT"/>
													<xsd:enumeration value="EXCEPT"/>
												</xsd:restriction>
											</xsd:simpleType>
										</xsd:element>
										<xsd:element name="duplicates" default="remove">
											<xsd:simpleType>
												<xsd:restriction base="xsd:NMTOKEN">
													<xsd:enumeration value="remove"/>
													<xsd:enumeration value="preserve"/>
												</xsd:restriction>
											</xsd:simpleType>
										</xsd:element>
									</xsd:sequence>
								</xsd:complexType>
							</xsd:element>
							<xsd:element ref="relationship" minOccurs="0" maxOccurs="1">
								<xsd:annotation>
									<xsd:documentation>A query that represents the join of two query subjects or tables.</xsd:documentation>
								</xsd:annotation>
							</xsd:element>
						</xsd:choice>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	<xsd:element name="sql">
		<xsd:annotation>
			<xsd:documentation>SQL definition.</xsd:documentation>
		</xsd:annotation>
		<xsd:complexType mixed="true">
			<xsd:sequence>
				<xsd:element name="type" default="cognos" minOccurs="0" maxOccurs="1">
					<xsd:annotation>
						<xsd:documentation>Specifies the level of flexibility the system is allowed in optimizing the SQL from this element, before presenting it to the data source.</xsd:documentation>
					</xsd:annotation>
					<xsd:simpleType>
						<xsd:restriction base="xsd:NMTOKEN">
							<xsd:enumeration value="cognos">
								<xsd:annotation>
									<xsd:documentation>Cognos SQL can be optimized by the system and combined with other SQL before being sent to the data source.</xsd:documentation>
								</xsd:annotation>
							</xsd:enumeration>
							<xsd:enumeration value="native">
								<xsd:annotation>
									<xsd:documentation>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.</xsd:documentation>
								</xsd:annotation>
							</xsd:enumeration>
							<xsd:enumeration value="passThrough">
								<xsd:annotation>
									<xsd:documentation>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.</xsd:documentation>
								</xsd:annotation>
							</xsd:enumeration>
						</xsd:restriction>
					</xsd:simpleType>
				</xsd:element>
				<xsd:element name="sqlText" type="xsd:string" minOccurs="0" maxOccurs="1"/>
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	<xsd:complexType name="facetType">
		<xsd:sequence>
			<xsd:element name="enabled" default="automatic">
				<xsd:simpleType>
					<xsd:restriction base="xsd:NMTOKEN">
						<xsd:enumeration value="automatic">
							<xsd:annotation>
								<xsd:documentation>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) 								
								</xsd:documentation>
							</xsd:annotation>
						</xsd:enumeration>
						<xsd:enumeration value="true"/>
						<xsd:enumeration value="false"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="sortList" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>if sortList is absent, sort on the query item/calculation ASC NULLS LAST.</xsd:documentation>
				</xsd:annotation>
				<xsd:complexType>
					<xsd:sequence>
						<xsd:element name="sortItem" maxOccurs="unbounded">
							<xsd:complexType>
								<xsd:sequence>
									<xsd:element name="ref" type="xsd:string">
										<xsd:annotation>
											<xsd:documentation>reference to query item/calculation.</xsd:documentation>
										</xsd:annotation>
									</xsd:element>
									<xsd:element name="order" default="ascending">
										<xsd:simpleType>
											<xsd:restriction base="xsd:NMTOKEN">
												<xsd:enumeration value="ascending"/>
												<xsd:enumeration value="descending"/>
											</xsd:restriction>
										</xsd:simpleType>
									</xsd:element>
									<xsd:element name="nullPlacement" default="last">
										<xsd:simpleType>
											<xsd:restriction base="xsd:NMTOKEN">
												<xsd:enumeration value="first"/>
												<xsd:enumeration value="last"/>
											</xsd:restriction>
										</xsd:simpleType>
									</xsd:element>
								</xsd:sequence>
							</xsd:complexType>
						</xsd:element>
					</xsd:sequence>
				</xsd:complexType>
			</xsd:element>
			<xsd:element name="context" minOccurs="0" maxOccurs="1">
				<xsd:annotation>
					<xsd:documentation>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.</xsd:documentation>
				</xsd:annotation>
				<xsd:complexType>
					<xsd:sequence>
						<xsd:element name="ref" type="xsd:string" minOccurs="1" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>reference to context query item/calculation.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="mode" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>define the behavior if context is missing in the query.</xsd:documentation>
							</xsd:annotation>
							<xsd:simpleType>
								<xsd:restriction base="xsd:NMTOKEN">
									<xsd:enumeration value="warnWhenMissing">
										<xsd:annotation>
											<xsd:documentation>issue a warning.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="includeInQuery">
										<xsd:annotation>
											<xsd:documentation>context is required in query (project or in filter).</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="infoWhenMissing">
										<xsd:annotation>
											<xsd:documentation>provide detail information if context is missing in the query.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
								</xsd:restriction>
							</xsd:simpleType>
						</xsd:element>
					</xsd:sequence>
				</xsd:complexType>
			</xsd:element>
		</xsd:sequence>
	</xsd:complexType>
	<xsd:element name="queryItem">
		<xsd:annotation>
			<xsd:documentation>A query item from a query subject</xsd:documentation>
		</xsd:annotation>
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="objectType">
					<xsd:sequence>
						<xsd:element name="expression" type="xsd:string" minOccurs="0" maxOccurs="1"/>
						<xsd:element name="usage" default="automatic" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>Defines the intended usage of the query item. </xsd:documentation>
							</xsd:annotation>
							<xsd:simpleType>
								<xsd:restriction base="xsd:NMTOKEN">
									<xsd:enumeration value="automatic">
										<xsd:annotation>
											<xsd:documentation>Specifies that the usage is not known.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="identifier">
										<xsd:annotation>
											<xsd:documentation>Specifies that the object is to be treated as an identifier.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="fact">
										<xsd:annotation>
											<xsd:documentation>Specifies that the object is to be treated as a fact.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="attribute">
										<xsd:annotation>
											<xsd:documentation>Specifies that the object is to be treated as an attribute.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
								</xsd:restriction>
							</xsd:simpleType>
						</xsd:element>
						<xsd:element name="format" type="xsd:string" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>Specifies the format for the parent object.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="datatype" type="xsd:string" minOccurs="0" maxOccurs="1"/>
						<xsd:element name="nullable" type="xsd:boolean" default="false" minOccurs="0" maxOccurs="1"/>
						<xsd:element name="regularAggregate" type="regularAggregateType" default="automatic" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>
									<para>Specifies the aggregation rule.</para>
								</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="datatypeCategory" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>High level datatype. </xsd:documentation>
							</xsd:annotation>
							<xsd:simpleType>
								<xsd:restriction base="xsd:NMTOKEN">
									<xsd:enumeration value="boolean"/>
									<xsd:enumeration value="string"/>
									<xsd:enumeration value="number"/>
									<xsd:enumeration value="datetime"/>
									<xsd:enumeration value="interval"/>
									<xsd:enumeration value="array"/>
									<xsd:enumeration value="object"/>
									<xsd:enumeration value="period"/>
								</xsd:restriction>
							</xsd:simpleType>
						</xsd:element>
						<xsd:element name="facetDefinition" type="facetType" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>If facetDefinition is absent, treat it as automatic (see enabled in facetType).</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="concepts" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
							<xsd:annotation>
								<xsd:documentation>Concepts from SMD.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="taxonomy" type="taxonomyType" minOccurs="0" maxOccurs="unbounded">
							<xsd:annotation>
								<xsd:documentation>
									<para>Specifies the query item data classification and whether it represents a geographic or time related concept.</para>
								</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="minimumValue" type="xsd:string" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>minimum value retrieved during SMD. The text format is: sign + decimal + abbreviation for thousand, million, billion. 
								Example: -100, -1.3K, -2.1M, -0.4G</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="maximumValue" type="xsd:string" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>maximum value retrieved during SMD. The text format is: sign + decimal + abbreviation for thousand, million, billion. 
								Example: 50, 3K, 5M</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="numberOfDistinctValues" type="xsd:string" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>number of distinct values retrieved during SMD. The text format is: decimal + abbreviation for thousand, million, billion.
								Example: 5, 4.5K, 1G</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="splitDefinition"
							type="splitType" minOccurs="0" maxOccurs="1">
						</xsd:element>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	<xsd:simpleType name="regularAggregateType">
		<xsd:annotation>
			<xsd:documentation>The aggregation rule. same as V5 aggregate name. </xsd:documentation>
		</xsd:annotation>
		<xsd:restriction base="xsd:NMTOKEN">
			<xsd:enumeration value="none">
				<xsd:annotation>
					<xsd:documentation>Aggregation is not supported for this object.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="average">
				<xsd:annotation>
					<xsd:documentation>Aggregation is computed as an average of the values in the result set for this object.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="automatic">
				<xsd:annotation>
					<xsd:documentation>The aggregation rule is determined automatically at run time.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="calculated">
				<xsd:annotation>
					<xsd:documentation>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.
					</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="count">
				<xsd:annotation>
					<xsd:documentation>Aggregation is computed as a count of the items in the result set for this object.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="countDistinct">
				<xsd:annotation>
					<xsd:documentation>Aggregation is computed as a count of unique items in the result set for this object.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="countNonZero">
				<xsd:annotation>
					<xsd:documentation>Excludes zero and NULL values.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="maximum">
				<xsd:annotation>
					<xsd:documentation>Aggregation determines the maximum value in the result set for this object.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="median">
				<xsd:annotation>
					<xsd:documentation>Aggregation determines the median value in the result set for this object.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="minimum">
				<xsd:annotation>
					<xsd:documentation>Aggregation determines the minimum value in the result set for this object.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="standardDeviation">
				<xsd:annotation>
					<xsd:documentation>Aggregation determines the standard deviation in the result set for this object.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="total">
				<xsd:annotation>
					<xsd:documentation>Aggregation determines the total of the values in the result set for this object.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="variance">
				<xsd:annotation>
					<xsd:documentation>Aggregation determines the variance in the result set for this object.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
		</xsd:restriction>
	</xsd:simpleType>
	<xsd:simpleType name="cardinalityEnum">
		<xsd:restriction base="xsd:NMTOKEN">
			<xsd:enumeration value="zero">
				<xsd:annotation>
					<xsd:documentation>Specifies that this object has no rows.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="one">
				<xsd:annotation>
					<xsd:documentation>Specifies that this object has one row only.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
			<xsd:enumeration value="many">
				<xsd:annotation>
					<xsd:documentation>Specifies that this object can have many rows.</xsd:documentation>
				</xsd:annotation>
			</xsd:enumeration>
		</xsd:restriction>
	</xsd:simpleType>
	<xsd:complexType name="cardinalityType">
		<xsd:sequence>
			<xsd:element name="ref" type="xsd:string" minOccurs="0" maxOccurs="1">
				<xsd:annotation>
					<xsd:documentation>References a query subject or table.</xsd:documentation>
				</xsd:annotation>
			</xsd:element>
			<xsd:element name="mincard" type="cardinalityEnum" minOccurs="0" maxOccurs="1">
				<xsd:annotation>
					<xsd:documentation>
						<para>The minimum number (cardinality) of rows that will match this end of the relationship. Normally zero or one.</para>
					</xsd:documentation>
				</xsd:annotation>
			</xsd:element>
			<xsd:element name="maxcard" type="cardinalityEnum" minOccurs="0" maxOccurs="1">
				<xsd:annotation>
					<xsd:documentation>
						<para>The maximum number (cardinality) of rows that will match this end of the relationship. The value is normally one or many.</para>
					</xsd:documentation>
				</xsd:annotation>
			</xsd:element>
		</xsd:sequence>
	</xsd:complexType>
	<xsd:element name="relationship">
		<xsd:annotation>
			<xsd:documentation>
				join two query subjects / tables.				
			</xsd:documentation>
		</xsd:annotation>
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="objectType">
					<xsd:sequence>
						<xsd:element name="ref" type="xsd:string" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>Defines a reference to a relationship in a referenced module.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="instanceType" type="instanceType" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>Defines whether the object is a copy or a reference.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="left" type="cardinalityType" minOccurs="1" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>References the left query subject or table in a relationship.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="right" type="cardinalityType" minOccurs="1" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>References the right query subject or table in a relationship.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:choice>
							<xsd:element name="expression" type="xsd:string" minOccurs="0" maxOccurs="1"/>
							<xsd:element name="link" minOccurs="0" maxOccurs="unbounded">
								<xsd:complexType>
									<xsd:sequence>
										<xsd:element name="leftRef" type="xsd:string" minOccurs="1" maxOccurs="1"/>
										<xsd:element name="rightRef" type="xsd:string" minOccurs="1" maxOccurs="1"/>
									</xsd:sequence>
								</xsd:complexType>
							</xsd:element>
						</xsd:choice>
						<xsd:element name="joinFilterType" default="none" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>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.</xsd:documentation>
							</xsd:annotation>
							<xsd:simpleType>
								<xsd:restriction base="xsd:NMTOKEN">
									<xsd:enumeration value="none">
										<xsd:annotation>
											<xsd:documentation>No predicate is generated.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="in">
										<xsd:annotation>
											<xsd:documentation>Generates an IN predicate of constant values.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="between">
										<xsd:annotation>
											<xsd:documentation>Generates a BETWEEN predicate comprised of MIN and MAX values of the join keys.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="table">
										<xsd:annotation>
											<xsd:documentation>Generates a table row constructor form of the IN predicate.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
								</xsd:restriction>
							</xsd:simpleType>
						</xsd:element>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	<xsd:element name="parameterMap">
		<xsd:annotation>
			<xsd:documentation>A lookup table for controlling query generation. As a minimum, the _env and _governor maps are required.</xsd:documentation>
		</xsd:annotation>
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="objectType">
					<xsd:sequence>
						<xsd:element name="defaultValue" type="xsd:string" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>Specifies the value to use if no key match is found. If not set, external sources for parameterMaps of this name may be searched.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="freshness" type="xsd:string" default="-1" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>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.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="loadAsNeeded" type="xsd:boolean" default="false" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>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.</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:choice minOccurs="0">
							<xsd:element name="parameterMapEntry" minOccurs="0" maxOccurs="unbounded">
								<xsd:annotation>
									<xsd:documentation>Specifies that the object is an entry in a parameter map.</xsd:documentation>
								</xsd:annotation>
								<xsd:complexType>
									<xsd:sequence>
										<xsd:element name="key" type="xsd:string" minOccurs="1" maxOccurs="1">
											<xsd:annotation>
												<xsd:documentation>Defines the unique identifier for the object.</xsd:documentation>
											</xsd:annotation>
										</xsd:element>
										<xsd:element name="value" type="xsd:string" minOccurs="1" maxOccurs="1">
											<xsd:annotation>
												<xsd:documentation>The value that gets returned when the parameter map locates the key value.</xsd:documentation>
											</xsd:annotation>
										</xsd:element>
									</xsd:sequence>
								</xsd:complexType>
							</xsd:element>
							<xsd:element name="queryItemMap" minOccurs="0" maxOccurs="1">
								<xsd:annotation>
									<xsd:documentation>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.</xsd:documentation>
								</xsd:annotation>
								<xsd:complexType>
									<xsd:sequence>
										<xsd:annotation>
											<xsd:documentation>The queryItems being referenced must belong to the same querySubject.</xsd:documentation>
										</xsd:annotation>
										<xsd:element name="keyRef" type="xsd:string" minOccurs="1" maxOccurs="1">
											<xsd:annotation>
												<xsd:documentation>When a parameterMap has been defined, the query looks for this unique identifier when it executes and returns the value in the valueRef element.</xsd:documentation>
											</xsd:annotation>
										</xsd:element>
										<xsd:element name="valueRef" type="xsd:string" minOccurs="1" maxOccurs="1">
											<xsd:annotation>
												<xsd:documentation>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.</xsd:documentation>
											</xsd:annotation>
										</xsd:element>
									</xsd:sequence>
								</xsd:complexType>
							</xsd:element>
						</xsd:choice>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	<xsd:element name="calculation">
		<xsd:annotation>
			<xsd:documentation>Defines an expression aggregate that returns a value.</xsd:documentation>
		</xsd:annotation>
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="objectType">
					<xsd:sequence>
						<xsd:element name="expression" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="datatype" type="xsd:string" minOccurs="0"/>
						<xsd:element name="datatypeCategory" minOccurs="0">
							<xsd:annotation>
								<xsd:documentation>High level datatype. </xsd:documentation>
							</xsd:annotation>
							<xsd:simpleType>
								<xsd:restriction base="xsd:NMTOKEN">
									<xsd:enumeration value="boolean"/>
									<xsd:enumeration value="string"/>
									<xsd:enumeration value="number"/>
									<xsd:enumeration value="datetime"/>
									<xsd:enumeration value="interval"/>
									<xsd:enumeration value="array"/>
									<xsd:enumeration value="object"/>
									<xsd:enumeration value="period"/>
								</xsd:restriction>
							</xsd:simpleType>
						</xsd:element>
						<xsd:element name="usage" default="automatic" minOccurs="0">
							<xsd:annotation>
								<xsd:documentation>Defines the intended usage of the query item. </xsd:documentation>
							</xsd:annotation>
							<xsd:simpleType>
								<xsd:restriction base="xsd:NMTOKEN">
									<xsd:enumeration value="automatic">
										<xsd:annotation>
											<xsd:documentation>Specifies that the usage is not known.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="identifier">
										<xsd:annotation>
											<xsd:documentation>Specifies that the object is to be treated as an identifier.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="fact">
										<xsd:annotation>
											<xsd:documentation>Specifies that the object is to be treated as a fact.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
									<xsd:enumeration value="attribute">
										<xsd:annotation>
											<xsd:documentation>Specifies that the object is to be treated as an attribute.</xsd:documentation>
										</xsd:annotation>
									</xsd:enumeration>
								</xsd:restriction>
							</xsd:simpleType>
						</xsd:element>
						<xsd:element name="facetDefinition" type="facetType" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>If facetDefinition is absent, treat it as automatic (see enabled in facetType).</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
						<xsd:element name="regularAggregate" type="regularAggregateType" default="automatic" minOccurs="0" maxOccurs="1">
							<xsd:annotation>
								<xsd:documentation>
									<para>Specifies the aggregation rule.</para>
								</xsd:documentation>
							</xsd:annotation>
						</xsd:element>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	<xsd:element name="filter">
		<xsd:annotation>
			<xsd:documentation>Specifies an expression used to query the data in the specified database.</xsd:documentation>
		</xsd:annotation>
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="objectType">
					<xsd:sequence>
						<xsd:element name="expression" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="postAutoAggregation" type="xsd:boolean" default="false" minOccurs="0" maxOccurs="1"/>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	<xsd:element name="drillGroup">
		<xsd:annotation>
			<xsd:documentation>represents a set of items related to each other as “coarse to finer”.</xsd:documentation>
		</xsd:annotation>
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="objectType">
					<xsd:sequence>
						<xsd:element name="segment" minOccurs="1" maxOccurs="unbounded">
							<xsd:annotation>
								<xsd:documentation>represents an item in drillGroup.</xsd:documentation>
							</xsd:annotation>
							<xsd:complexType>
								<xsd:complexContent>
									<xsd:extension base="objectType">
										<xsd:sequence>
											<xsd:element name="ref" type="xsd:string" minOccurs="1" maxOccurs="1">
												<xsd:annotation>
													<xsd:documentation>reference to a query item in the same module.</xsd:documentation>
												</xsd:annotation>
											</xsd:element>
										</xsd:sequence>
									</xsd:extension>
								</xsd:complexContent>
							</xsd:complexType>
						</xsd:element>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	<xsd:complexType name="splitType">
		<xsd:sequence>
			<xsd:element name="columnTreatment" minOccurs="1" maxOccurs="1">
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:enumeration value="show"></xsd:enumeration>
						<xsd:enumeration value="hide"></xsd:enumeration>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="display" minOccurs="1" maxOccurs="1">
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:enumeration value="inline"></xsd:enumeration>
						<xsd:enumeration value="folder"></xsd:enumeration>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="folderLabel" type="xsd:string" minOccurs="0" maxOccurs="1"></xsd:element>
			<xsd:element name="ref" type="xsd:string" minOccurs="1" maxOccurs="1">
				<xsd:annotation>
					<xsd:documentation>Reference to table that defines the columns to be split into</xsd:documentation>
				</xsd:annotation>
			</xsd:element>
			<xsd:element name="relationshipRef" type="xsd:string" minOccurs="0" maxOccurs="1"></xsd:element>
			<xsd:element name="columnsToShow" type="xsd:string" minOccurs="1" maxOccurs="unbounded"></xsd:element>
		</xsd:sequence>
	</xsd:complexType>
	<xsd:complexType name="taxonomyType">
		<xsd:sequence>
			<xsd:element name="domain" minOccurs="1" maxOccurs="1">
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:enumeration value="cognos" />
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="class" minOccurs="1" maxOccurs="1">
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:enumeration value="cNone" />
						<xsd:enumeration value="cTime" />
						<xsd:enumeration value="cGeoLocation" />
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="family" minOccurs="1" maxOccurs="1">
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:enumeration value="cNone" />
						<xsd:enumeration value="cDate" />
						<xsd:enumeration value="cYear" />
						<xsd:enumeration value="cQuarter" />
						<xsd:enumeration value="cSeason" />
						<xsd:enumeration value="cMonth" />
						<xsd:enumeration value="cWeek" />
						<xsd:enumeration value="cDay" />
						<xsd:enumeration value="cHour" />
						<xsd:enumeration value="cMinute" />
						<xsd:enumeration value="cSecond" />
						<xsd:enumeration value="cContinent" />
						<xsd:enumeration value="cSubContinent" />
						<xsd:enumeration value="cCountry" />
						<xsd:enumeration value="cRegion" />
						<xsd:enumeration value="cStateProvince" />
						<xsd:enumeration value="cCounty" />
						<xsd:enumeration value="cCity" />
						<xsd:enumeration value="cPostalCode" />
						<xsd:enumeration value="cStreetAddress" />
						<xsd:enumeration value="cPosition" />
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
		</xsd:sequence>
	</xsd:complexType>
</xsd:schema>