12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484 |
- <?xml version="1.0" encoding="UTF-8"?>
- <!--
- Licensed Materials - Property of IBM
- IBM Cognos Products: rspec
- (C) Copyright IBM Corp. 2003, 2019
- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
- -->
- <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rspec="http://developer.cognos.com/schemas/report/15.3/" elementFormDefault="qualified" attributeFormDefault="unqualified">
- <xs:include schemaLocation="V5_base.xsd"/>
- <xs:include schemaLocation="V5_queryBase.xsd"/>
- <xs:element name="query" type="queryType">
- <xs:annotation>
- <xs:documentation>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.</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:group name="dataItemElement">
- <xs:choice>
- <xs:element ref="dataItem"/>
- <xs:element name="dataItemMember">
- <xs:annotation>
- <xs:documentation>Repreesents a single member.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMember"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemDetailAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemCalculatedMember">
- <xs:annotation>
- <xs:documentation>A V5 expressin that results in a single calculated member.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="expression"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemCalculatedMemberAttributes"/>
- <xs:attributeGroup ref="DataItemDetailAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemMemberProperty">
- <xs:annotation>
- <xs:documentation>Represents a member property from either a level or hierarchy.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMemberProperty"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="dmLevel" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemMeasure">
- <xs:annotation>
- <xs:documentation>Represents a single measure. For the most part, measures are the same as members.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMember"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemMeasureRollupAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemTextMeasure">
- <xs:annotation>
- <xs:documentation>Represents a single text measure. For the most part, measures are the same as members.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMember"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemCalculatedMeasure">
- <xs:annotation>
- <xs:documentation>A V5 expressin that results in a single calculated member.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="expression"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemCalculatedMemberAttributes"/>
- <xs:attributeGroup ref="DataItemMeasureRollupAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemSet">
- <xs:annotation>
- <xs:documentation>Describes an explicit set of members. Generates a V5 expressions of the form set(MUN1, MUN2, ...).</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMembers"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="setSorting" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemDetailAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemChildrenSet">
- <xs:annotation>
- <xs:documentation>Describes the set of children of a member. Generates a V5 expression of the form children(MUN).</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMember"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="setSorting" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemDetailAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemSetExpression">
- <xs:annotation>
- <xs:documentation>A V5 expression that results in a set of members.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="expression"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="setSorting" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemDetailAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemLevelSet">
- <xs:annotation>
- <xs:documentation>The members of a level.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmLevel"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="setSorting" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemDetailAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemHierarchySet">
- <xs:annotation>
- <xs:documentation>The member of a hierarchy</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="setSorting" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attribute name="rootMembersOnly" type="xs:boolean" default="false"/>
- <xs:attributeGroup ref="DataItemDetailAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemNamedSet">
- <xs:annotation>
- <xs:documentation>References a named set from the model.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="NSUN"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy" minOccurs="0"/>
- <xs:element ref="setSorting" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemDetailAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemTuple">
- <xs:annotation>
- <xs:documentation>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, ..)</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmTuple"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemMemberSet">
- <xs:annotation>
- <xs:documentation>Comment describing your root element</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element name="setDefinition">
- <xs:complexType>
- <xs:group ref="setDefinitionType"/>
- </xs:complexType>
- </xs:element>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="setSorting" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- <xs:element name="dataItemSharing" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Information related to sharing the data item.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:attribute name="shareName" type="xs:string" use="required">
- <xs:annotation>
- <xs:documentation>The name used to reference the data item in a sharing scenario. The shareName must be unique within the report.</xs:documentation>
- </xs:annotation>
- </xs:attribute>
- <xs:attribute name="description" type="xs:string" use="optional"/>
- </xs:complexType>
- </xs:element>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemDetailAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemListSummary">
- <xs:complexType>
- <xs:all>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attribute name="refDataItem" type="xs:string" use="required"/>
- <xs:attribute name="aggregateMethod" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:NMTOKEN">
- <xs:enumeration value="aggregate">
- <xs:annotation>
- <xs:documentation source="doc_enum_automatic_aggregate"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="total"/>
- <xs:enumeration value="minimum"/>
- <xs:enumeration value="maximum"/>
- <xs:enumeration value="average"/>
- <xs:enumeration value="count"/>
- <xs:enumeration value="calculated">
- <xs:annotation>
- <xs:documentation source="doc_enum_calculated_aggregate"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="countDistinct"/>
- <xs:enumeration value="median"/>
- <xs:enumeration value="standardDeviation"/>
- <xs:enumeration value="variance"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemEdgeSummary">
- <xs:complexType>
- <xs:all>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attribute name="refDataItem" type="xs:string" use="required"/>
- <xs:attribute name="aggregateMethod" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:NMTOKEN">
- <xs:enumeration value="aggregate">
- <xs:annotation>
- <xs:documentation source="doc_enum_automatic_aggregate"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="total"/>
- <xs:enumeration value="minimum"/>
- <xs:enumeration value="maximum"/>
- <xs:enumeration value="average"/>
- <xs:enumeration value="count"/>
- <xs:enumeration value="median"/>
- <xs:enumeration value="standardDeviation"/>
- <xs:enumeration value="variance"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attribute name="useSetAggregation" type="xs:boolean" default="false"/>
- <xs:attributeGroup ref="DataItemCalculatedMemberAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemDimensionalEdgeSummary">
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attribute name="refDataItem" type="xs:string" use="required"/>
- <xs:attribute name="aggregateMethod" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:NMTOKEN">
- <xs:enumeration value="aggregate">
- <xs:annotation>
- <xs:documentation source="doc_enum_automatic_aggregate"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="total"/>
- <xs:enumeration value="minimum"/>
- <xs:enumeration value="maximum"/>
- <xs:enumeration value="average"/>
- <xs:enumeration value="count"/>
- <xs:enumeration value="median"/>
- <xs:enumeration value="standardDeviation"/>
- <xs:enumeration value="variance"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attribute name="useSetAggregation" type="xs:boolean" default="true"/>
- <xs:attributeGroup ref="DataItemCalculatedMemberAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemCustomGroup">
- <xs:annotation>
- <xs:documentation>Represents a custom grouping calcuation stored as a high level grouping of relational names or dimenstional members or value ranges associated with a name.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element name="customGroups">
- <xs:complexType>
- <xs:sequence maxOccurs="unbounded">
- <xs:choice>
- <xs:element name="customValuesGroup">
- <xs:annotation>
- <xs:documentation>Custom group for relation dataitems defined by matching specified values.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:element name="selectedValue" type="TextType" maxOccurs="unbounded"/>
- </xs:sequence>
- <xs:attribute name="label" type="xs:string" use="required"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="customRangeGroup">
- <xs:annotation>
- <xs:documentation>Custom group for dimensional or relational data items defined by ranages of values.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element name="lowValue" type="TextType" minOccurs="0"/>
- <xs:element name="highValue" type="TextType" minOccurs="0"/>
- </xs:all>
- <xs:attribute name="label" type="xs:string" use="required"/>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="customGroupRemainingValues">
- <xs:annotation>
- <xs:documentation>Represents what to do with values in the refDataItem that do not fall into one of the defined custom groups.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:choice>
- <xs:element name="showRemainingValues">
- <xs:annotation>
- <xs:documentation>Other values that do not match the custom groping are returned as normal.</xs:documentation>
- </xs:annotation>
- <xs:complexType/>
- </xs:element>
- <xs:element name="hideRemainingValues">
- <xs:annotation>
- <xs:documentation>Other values that do not match the custom groping are returned as null values.</xs:documentation>
- </xs:annotation>
- <xs:complexType/>
- </xs:element>
- <xs:element name="groupRemainingValuesAs">
- <xs:annotation>
- <xs:documentation>Other values that do not match the custom groping are returned as a single label.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:attribute name="label" type="xs:string" use="required"/>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:complexType>
- </xs:element>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemDetailAttributes"/>
- <xs:attribute name="refDataItem" type="xs:string" use="required"/>
- <xs:attribute name="dataType" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="integer"/>
- <xs:enumeration value="decimal"/>
- <xs:enumeration value="float"/>
- <xs:enumeration value="date"/>
- <xs:enumeration value="time"/>
- <xs:enumeration value="dateTime"/>
- <xs:enumeration value="interval"/>
- <xs:enumeration value="string"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- <xs:element name="dataItemMeasurePercentage">
- <xs:annotation>
- <xs:documentation>Represents a measure percentage calcuation.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element name="measureRef">
- <xs:annotation>
- <xs:documentation>References a dataItemMeasure or a dataItemCalculatedMeasure from the current query that is the actual measure in the percentage calculation.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:attribute name="refDataItem" type="xs:string" use="required"/>
- </xs:complexType>
- </xs:element>
- <xs:element ref="dmTuple"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="DataItemAttributes"/>
- <xs:attributeGroup ref="DataItemMeasureRollupAttributes"/>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:group>
- <xs:element name="selection">
- <xs:annotation>
- <xs:documentation>The selection identifies the metadata elements upon which the query is based. This is analogous to a projection from the source.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:group ref="dataItemElement" minOccurs="0" maxOccurs="unbounded"/>
- </xs:sequence>
- <xs:attribute name="autoSummary" type="xs:boolean" use="optional" default="true"/>
- </xs:complexType>
- <xs:unique name="dataItemUniqueness">
- <xs:selector xpath="*"/>
- <xs:field xpath="@name"/>
- </xs:unique>
- </xs:element>
- <xs:element name="slicer">
- <xs:annotation>
- <xs:documentation>a list of member expressions. the list is interpreted as a tuple of members.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:choice>
- <xs:sequence>
- <xs:element ref="slicerMemberSet" maxOccurs="unbounded"/>
- </xs:sequence>
- <xs:sequence>
- <xs:element name="contextSlice" maxOccurs="unbounded">
- <xs:annotation>
- <xs:documentation>There can only be one contextSlicer per dimension or hierarchy depending on the data source.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="dmLevel" minOccurs="0"/>
- <xs:element name="contextSliceDefinition">
- <xs:annotation>
- <xs:documentation>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.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:choice>
- <xs:element ref="dmMembers"/>
- </xs:choice>
- </xs:complexType>
- </xs:element>
- <xs:element name="parameterizedSlice" minOccurs="0">
- <xs:annotation>
- <xs:documentation>This element indicates that the slicer will be converted into a parameter against either the hierarchy or level when the report is run. </xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:attribute name="type" use="required">
- <xs:annotation>
- <xs:documentation source="doc_att_type_parameterizedSlice"/>
- </xs:annotation>
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="hierarchy"/>
- <xs:enumeration value="level">
- <xs:annotation>
- <xs:documentation source="doc_enum_level_parameterizedSlice"/>
- </xs:annotation>
- </xs:enumeration>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attribute name="singleMember" type="xs:boolean" default="false">
- <xs:annotation>
- <xs:documentation>If true, then slicer will appear as a single member parameter. If false, the slicer will appear as a multiple value parameter.</xs:documentation>
- </xs:annotation>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- </xs:all>
- </xs:complexType>
- </xs:element>
- </xs:sequence>
- </xs:choice>
- </xs:complexType>
- <xs:unique name="contextSliceUniqueness">
- <xs:selector xpath="rspec:contextSlice/rspec:dmHierarchy"/>
- <xs:field xpath="rspec:HUN"/>
- </xs:unique>
- </xs:element>
- <xs:element name="dmLevel">
- <xs:complexType>
- <xs:all>
- <xs:element name="LUN" type="queryExpressionType">
- <xs:annotation>
- <xs:documentation>Level Unique Name</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element ref="itemCaption"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="dmMember">
- <xs:annotation>
- <xs:documentation>Reference to a member</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="MUN"/>
- <xs:element ref="itemCaption"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="dmMembers">
- <xs:annotation>
- <xs:documentation>A list of member references</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:element ref="dmMember" maxOccurs="unbounded"/>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="dmTuple">
- <xs:annotation>
- <xs:documentation>A tuple definition. A tuple can only reference one member per dimension.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:choice maxOccurs="unbounded">
- <xs:element name="dmTuplePart">
- <xs:annotation>
- <xs:documentation>Refers to a member or measure in the tuple.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMember"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy" minOccurs="0"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="dmTuplePartDataItemRef">
- <xs:annotation>
- <xs:documentation>References a dataItemCalculatedMember or a dataItemCalculatedMeasure from the current query in the tuple.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:attribute name="refDataItem" type="xs:string" use="required"/>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:sequence>
- </xs:complexType>
- <xs:unique name="tupleMemberHierarchyUniqueness">
- <xs:selector xpath="rspec:dmTuplePart/rspec:dmHierarchy"/>
- <xs:field xpath="rspec:HUN"/>
- </xs:unique>
- </xs:element>
- <xs:element name="dmMemberProperty">
- <xs:complexType>
- <xs:all>
- <xs:element name="MPUN" type="queryExpressionType">
- <xs:annotation>
- <xs:documentation>Member Property Unique Name</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element ref="itemCaption"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="itemCaption" type="TextType"/>
- <xs:element name="setSorting">
- <xs:annotation>
- <xs:documentation>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.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:choice minOccurs="0">
- <xs:element ref="dmTuple"/>
- <xs:element ref="dmMemberProperty"/>
- </xs:choice>
- <xs:attribute name="ascending" type="xs:boolean" default="true"/>
- <xs:attribute name="breakHierarchy" type="xs:boolean" default="true">
- <xs:annotation>
- <xs:documentation>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.</xs:documentation>
- </xs:annotation>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- <xs:element name="dmHierarchy">
- <xs:annotation>
- <xs:documentation>Reference to a hierarchy</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="HUN"/>
- <xs:element ref="itemCaption"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="dmDimension">
- <xs:annotation>
- <xs:documentation>Reference to a dimension</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="DUN"/>
- <xs:element ref="itemCaption"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="HUN" type="queryExpressionType">
- <xs:annotation>
- <xs:documentation>Hierarchy Unique Name</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="MUN" type="queryExpressionType">
- <xs:annotation>
- <xs:documentation>Member Unique Name</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="DUN" type="queryExpressionType">
- <xs:annotation>
- <xs:documentation>Dimension Unique Name</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="NSUN" type="queryExpressionType"/>
- <xs:group name="setDefinitionType">
- <xs:choice>
- <xs:element name="setExplicitMembers">
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMembers"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setChildrenMembers">
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMember"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setLevelMembers">
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmLevel"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setHierarchyMembers">
- <xs:complexType>
- <xs:attribute name="rootMembersOnly" type="xs:boolean" default="false"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="setExpression">
- <xs:complexType>
- <xs:all>
- <xs:element ref="expression"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setNamedReference">
- <xs:complexType>
- <xs:all>
- <xs:element ref="NSUN"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setExceptMembers">
- <xs:annotation>
- <xs:documentation>Removes members from a set.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmMembers"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setTopCount">
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmTuple"/>
- </xs:all>
- <xs:attribute name="value" type="xs:positiveInteger" use="required"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="setTopPercent">
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmTuple"/>
- </xs:all>
- <xs:attribute name="value" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:decimal">
- <xs:minExclusive value="0"/>
- <xs:maxInclusive value="100"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- <xs:element name="setTopSum">
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmTuple"/>
- </xs:all>
- <xs:attribute name="value" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:decimal"/>
- </xs:simpleType>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- <xs:element name="setBottomCount">
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmTuple"/>
- </xs:all>
- <xs:attribute name="value" type="xs:positiveInteger" use="required"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="setBottomPercent">
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmTuple"/>
- </xs:all>
- <xs:attribute name="value" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:decimal">
- <xs:minExclusive value="0"/>
- <xs:maxInclusive value="100"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- <xs:element name="setBottomSum">
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmTuple"/>
- </xs:all>
- <xs:attribute name="value" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:decimal"/>
- </xs:simpleType>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- <xs:element name="setUnion">
- <xs:complexType>
- <xs:all>
- <xs:element name="baseSets">
- <xs:complexType>
- <xs:sequence>
- <xs:group ref="setDefinitionType" maxOccurs="unbounded"/>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- </xs:all>
- <xs:attribute name="all" type="xs:boolean" default="false">
- <xs:annotation>
- <xs:documentation>If true, retains duplicate members after the union.</xs:documentation>
- </xs:annotation>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- <xs:element name="setMoveMembersToTop">
- <xs:annotation>
- <xs:documentation>Removes the members from the base set and then positions them at the top of the resultant set.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmMembers"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setMoveMembersToBottom">
- <xs:annotation>
- <xs:documentation>Removes the members from the base set and then positions them at the bottom of the resultant set.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmMembers"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setExpandMember">
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmMember"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setCollapseMember">
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element ref="dmMember"/>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setFilter">
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element name="setFilterCriteria">
- <xs:complexType>
- <xs:group ref="setFilterCondition"/>
- </xs:complexType>
- </xs:element>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setCustomGroup">
- <xs:complexType>
- <xs:all>
- <xs:element ref="baseSet"/>
- <xs:element name="setCustomGroups">
- <xs:complexType>
- <xs:sequence maxOccurs="unbounded">
- <xs:element name="customMembersGroup">
- <xs:annotation>
- <xs:documentation>Custom group for dimensional dataitems defined by lists of members.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMembers"/>
- </xs:all>
- <xs:attribute name="label" type="xs:string" use="required"/>
- </xs:complexType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="customGroupRemainingMembers">
- <xs:annotation>
- <xs:documentation>Represents what to do with any members from the base set that do not fall into one of the defined custom groups.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:choice>
- <xs:element name="includeRemainingMembers">
- <xs:annotation>
- <xs:documentation>Other members that do not match the custom groping are included in the set.</xs:documentation>
- </xs:annotation>
- <xs:complexType/>
- </xs:element>
- <xs:element name="excludeRemainingMembers">
- <xs:annotation>
- <xs:documentation>Other members that do not match the custom groping are excluded from the set.</xs:documentation>
- </xs:annotation>
- <xs:complexType/>
- </xs:element>
- <xs:element name="groupRemainingMembersAs">
- <xs:annotation>
- <xs:documentation>Other members that do not match the custom groping are grouped under as a single label.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:attribute name="label" type="xs:string" use="required"/>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:complexType>
- </xs:element>
- </xs:all>
- </xs:complexType>
- </xs:element>
- <xs:element name="setReference">
- <xs:complexType>
- <xs:all>
- <xs:element ref="reportPath"/>
- <xs:element name="referenceDefinition">
- <xs:complexType>
- <xs:group ref="setDefinitionType"/>
- </xs:complexType>
- </xs:element>
- </xs:all>
- <xs:attribute name="refShareName" type="xs:string" use="required"/>
- <xs:attribute name="inclusion" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="designTime"/>
- <xs:enumeration value="runTime"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:group>
- <xs:element name="baseSet">
- <xs:complexType>
- <xs:group ref="setDefinitionType"/>
- </xs:complexType>
- </xs:element>
- <xs:group name="setFilterCondition">
- <xs:annotation>
- <xs:documentation>Represents a simple or compound set filter condition</xs:documentation>
- </xs:annotation>
- <xs:choice>
- <xs:element name="setFilterAnd">
- <xs:complexType>
- <xs:sequence>
- <xs:group ref="setFilterCondition" minOccurs="2" maxOccurs="unbounded"/>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="setFilterOr">
- <xs:complexType>
- <xs:sequence>
- <xs:group ref="setFilterCondition" minOccurs="2" maxOccurs="unbounded"/>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="setFilterNot">
- <xs:complexType>
- <xs:group ref="setFilterCondition"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="memberCaptionCondition">
- <xs:annotation>
- <xs:documentation>Defines a condition against the member caption.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:attribute name="operator" use="required">
- <xs:annotation>
- <xs:documentation source="doc_att_filterCondition_operator"/>
- </xs:annotation>
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="contains">
- <xs:annotation>
- <xs:documentation source="doc_enum_memberCaptionCondition_operator_contains"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="beginsWith">
- <xs:annotation>
- <xs:documentation source="doc_enum_memberCaptionCondition_operator_beginsWith"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="endsWith">
- <xs:annotation>
- <xs:documentation source="doc_enum_memberCaptionCondition_operator_endsWith"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="matches">
- <xs:annotation>
- <xs:documentation source="doc_enum_memberCaptionCondition_operator_matches"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="containsNot">
- <xs:annotation>
- <xs:documentation source="doc_enum_memberCaptionCondition_operator_containsNot"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="beginsWithNot">
- <xs:annotation>
- <xs:documentation source="doc_enum_memberCaptionCondition_operator_beginsWithNot"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="endsWithNot">
- <xs:annotation>
- <xs:documentation source="doc_enum_memberCaptionCondition_operator_endsWithNot"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="matchesNot">
- <xs:annotation>
- <xs:documentation source="doc_enum_memberCaptionCondition_operator_matchesNot"/>
- </xs:annotation>
- </xs:enumeration>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attribute name="value" type="xs:string" use="required"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="stringPropertyCondition">
- <xs:annotation>
- <xs:documentation>Defines a condition against a string member property. The value attribute must be provided for all operators except isNull and isNotNull.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMemberProperty"/>
- </xs:all>
- <xs:attribute name="operator" use="required">
- <xs:annotation>
- <xs:documentation source="doc_att_filterCondition_operator"/>
- </xs:annotation>
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="contains">
- <xs:annotation>
- <xs:documentation source="doc_enum_stringPropertyCondition_operator_contains"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="beginsWith">
- <xs:annotation>
- <xs:documentation source="doc_enum_stringPropertyCondition_operator_beginsWith"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="endsWith">
- <xs:annotation>
- <xs:documentation source="doc_enum_stringPropertyCondition_operator_endsWith"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="matches">
- <xs:annotation>
- <xs:documentation source="doc_enum_stringPropertyCondition_operator_matches"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="containsNot">
- <xs:annotation>
- <xs:documentation source="doc_enum_stringPropertyCondition_operator_containsNot"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="beginsWithNot">
- <xs:annotation>
- <xs:documentation source="doc_enum_stringPropertyCondition_operator_beginsWithNot"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="endsWithNot">
- <xs:annotation>
- <xs:documentation source="doc_enum_stringPropertyCondition_operator_endsWithNot"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="matchesNot">
- <xs:annotation>
- <xs:documentation source="doc_enum_stringPropertyCondition_operator_matchesNot"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="isNull"/>
- <xs:enumeration value="isNotNull"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attribute name="value" type="xs:string" use="optional"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="numericPropertyCondition">
- <xs:annotation>
- <xs:documentation>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.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMemberProperty"/>
- </xs:all>
- <xs:attribute name="operator" use="required">
- <xs:annotation>
- <xs:documentation source="doc_att_filterCondition_operator"/>
- </xs:annotation>
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="equal"/>
- <xs:enumeration value="notEqual"/>
- <xs:enumeration value="greaterThan"/>
- <xs:enumeration value="greaterThanEqual"/>
- <xs:enumeration value="lessThan"/>
- <xs:enumeration value="lessThanEqual"/>
- <xs:enumeration value="isNull"/>
- <xs:enumeration value="isNotNull"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attribute name="value" type="xs:decimal" use="optional"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="tupleCondition">
- <xs:annotation>
- <xs:documentation>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.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmTuple"/>
- </xs:all>
- <xs:attribute name="operator" use="required">
- <xs:annotation>
- <xs:documentation source="doc_att_filterCondition_operator"/>
- </xs:annotation>
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="equal"/>
- <xs:enumeration value="notEqual"/>
- <xs:enumeration value="greaterThan"/>
- <xs:enumeration value="greaterThanEqual"/>
- <xs:enumeration value="lessThan"/>
- <xs:enumeration value="lessThanEqual"/>
- <xs:enumeration value="isNull"/>
- <xs:enumeration value="isNotNull"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attribute name="value" type="xs:decimal" use="optional"/>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:group>
- <xs:group name="filterElement">
- <xs:choice>
- <xs:element name="filterAnd">
- <xs:complexType>
- <xs:sequence minOccurs="2" maxOccurs="unbounded">
- <xs:group ref="filterElement"/>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterOr">
- <xs:complexType>
- <xs:sequence minOccurs="2" maxOccurs="unbounded">
- <xs:group ref="filterElement"/>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterNot">
- <xs:complexType>
- <xs:group ref="filterElement"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterInMembers">
- <xs:complexType>
- <xs:all>
- <xs:element ref="dmMembers" minOccurs="0"/>
- <xs:element ref="dmDimension"/>
- <xs:element ref="dmHierarchy"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="FilterElementCommonAttributes"/>
- <xs:attributeGroup ref="FilterElementParameterAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterInValues">
- <xs:complexType>
- <xs:all>
- <xs:element name="filterValues" minOccurs="0">
- <xs:complexType>
- <xs:sequence>
- <xs:element ref="filterValue" maxOccurs="unbounded"/>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="FilterElementCommonAttributes"/>
- <xs:attributeGroup ref="FilterElementAllDataTypeAttributes"/>
- <xs:attributeGroup ref="FilterElementIncludeNullAttributes"/>
- <xs:attributeGroup ref="FilterElementIncludeStringAttributes"/>
- <xs:attributeGroup ref="FilterElementParameterAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterCompare">
- <xs:complexType>
- <xs:all>
- <xs:element ref="filterValue"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="FilterElementCommonAttributes"/>
- <xs:attributeGroup ref="FilterElementComparableDataTypeAttributes"/>
- <xs:attributeGroup ref="FilterElementIncludeNullAttributes"/>
- <xs:attribute name="operator" use="required">
- <xs:annotation>
- <xs:documentation source="doc_att_filterCondition_operator"/>
- </xs:annotation>
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="greaterThan"/>
- <xs:enumeration value="greaterThanEqual"/>
- <xs:enumeration value="lessThan"/>
- <xs:enumeration value="lessThanEqual"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attributeGroup ref="FilterElementParameterAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterStringCompare">
- <xs:complexType>
- <xs:all>
- <xs:element ref="filterValue"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="FilterElementCommonAttributes"/>
- <xs:attributeGroup ref="FilterElementIncludeNullAttributes"/>
- <xs:attributeGroup ref="FilterElementIncludeStringAttributes"/>
- <xs:attribute name="operator" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="contains"/>
- <xs:enumeration value="beginsWith"/>
- <xs:enumeration value="endsWith"/>
- <xs:enumeration value="like"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attribute name="caseInsensitive" default="dataSource">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="yes"/>
- <xs:enumeration value="dataSource"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attribute name="escapeCharacter" type="xs:string" use="optional">
- <xs:annotation>
- <xs:documentation>A single escape character that can be used to escape wildcard characters in the value text.</xs:documentation>
- </xs:annotation>
- </xs:attribute>
- <xs:attributeGroup ref="FilterElementParameterAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterRange">
- <xs:complexType>
- <xs:all>
- <xs:element name="filterFrom" minOccurs="0">
- <xs:complexType>
- <xs:simpleContent>
- <xs:extension base="TextType"/>
- </xs:simpleContent>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterTo" minOccurs="0">
- <xs:complexType>
- <xs:simpleContent>
- <xs:extension base="TextType"/>
- </xs:simpleContent>
- </xs:complexType>
- </xs:element>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="FilterElementCommonAttributes"/>
- <xs:attributeGroup ref="FilterElementComparableDataTypeAttributes"/>
- <xs:attributeGroup ref="FilterElementIncludeNullAttributes"/>
- <xs:attributeGroup ref="FilterElementParameterAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterNulls">
- <xs:complexType>
- <xs:all>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="FilterElementCommonAttributes"/>
- <xs:attributeGroup ref="FilterElementAllDataTypeAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterEmpty">
- <xs:complexType>
- <xs:all>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="FilterElementCommonAttributes"/>
- <xs:attributeGroup ref="FilterElementAllDataTypeAttributes"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterWhitespace">
- <xs:complexType>
- <xs:all>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attributeGroup ref="FilterElementCommonAttributes"/>
- <xs:attributeGroup ref="FilterElementAllDataTypeAttributes"/>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:group>
- <xs:element name="filterValue" type="TextType"/>
- <xs:element name="detailFilter">
- <xs:annotation>
- <xs:documentation>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.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="filterExpression" minOccurs="0"/>
- <xs:element ref="filterDefinition" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attribute name="use" use="optional" default="required">
- <xs:annotation>
- <xs:documentation>{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".</xs:documentation>
- </xs:annotation>
- <xs:simpleType>
- <xs:restriction base="xs:NMTOKEN">
- <xs:enumeration value="required"/>
- <xs:enumeration value="optional"/>
- <xs:enumeration value="prohibited"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- <xs:attribute name="postAutoAggregation" type="xs:boolean" use="optional" default="false">
- <xs:annotation>
- <xs:documentation>{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.</xs:documentation>
- </xs:annotation>
- </xs:attribute>
- <xs:attribute name="canBeChangedInAdvancedViewer" type="xs:boolean" default="false"/>
- </xs:complexType>
- </xs:element>
- <xs:element name="summaryFilter">
- <xs:annotation>
- <xs:documentation>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.</xs:documentation>
- </xs:annotation>
- <xs:complexType>
- <xs:all>
- <xs:element ref="filterExpression" minOccurs="0"/>
- <xs:element ref="filterDefinition" minOccurs="0"/>
- <xs:element ref="summaryFilterLevels" minOccurs="0"/>
- <xs:element ref="XMLAttributes" minOccurs="0"/>
- </xs:all>
- <xs:attribute name="use" use="optional" default="required">
- <xs:annotation>
- <xs:documentation>{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".</xs:documentation>
- </xs:annotation>
- <xs:simpleType>
- <xs:restriction base="xs:NMTOKEN">
- <xs:enumeration value="required"/>
- <xs:enumeration value="optional"/>
- <xs:enumeration value="prohibited"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- </xs:complexType>
- </xs:element>
- <xs:element name="filterDefinition">
- <xs:complexType>
- <xs:group ref="filterElement"/>
- </xs:complexType>
- </xs:element>
- <xs:attributeGroup name="FilterElementCommonAttributes">
- <xs:attribute name="refDataItem" type="xs:string" use="required"/>
- <xs:attribute name="not" type="xs:boolean" default="false"/>
- </xs:attributeGroup>
- <xs:attributeGroup name="FilterElementIncludeNullAttributes">
- <xs:attribute name="includeNulls" type="xs:boolean" default="false">
- <xs:annotation>
- <xs:documentation>The set of values being filtered (in or not in) should also include any null values.</xs:documentation>
- </xs:annotation>
- </xs:attribute>
- </xs:attributeGroup>
- <xs:attributeGroup name="FilterElementIncludeStringAttributes">
- <xs:attribute name="includeEmpty" type="xs:boolean" default="false">
- <xs:annotation>
- <xs:documentation>The set of values being filtered (in or not in) should also include any empty values.</xs:documentation>
- </xs:annotation>
- </xs:attribute>
- <xs:attribute name="includeWhitespace" type="xs:boolean" default="false">
- <xs:annotation>
- <xs:documentation>The set of values being filtered (in or not in) should also include any value that is 1 or more spaces.</xs:documentation>
- </xs:annotation>
- </xs:attribute>
- </xs:attributeGroup>
- <xs:attributeGroup name="FilterElementComparableDataTypeAttributes">
- <xs:attribute name="dataType" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="integer"/>
- <xs:enumeration value="decimal"/>
- <xs:enumeration value="float"/>
- <xs:enumeration value="date"/>
- <xs:enumeration value="time"/>
- <xs:enumeration value="dateTime"/>
- <xs:enumeration value="interval"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- </xs:attributeGroup>
- <xs:attributeGroup name="FilterElementAllDataTypeAttributes">
- <xs:attribute name="dataType" use="required">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:enumeration value="string"/>
- <xs:enumeration value="integer"/>
- <xs:enumeration value="decimal"/>
- <xs:enumeration value="float"/>
- <xs:enumeration value="date"/>
- <xs:enumeration value="time"/>
- <xs:enumeration value="dateTime"/>
- <xs:enumeration value="interval"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- </xs:attributeGroup>
- <xs:attributeGroup name="FilterElementParameterAttributes">
- <xs:attribute name="parameterized" type="xs:boolean" default="false">
- <xs:annotation>
- <xs:documentation>Indicates that when the report is run in the viewer the user should be prompted for the value(s). </xs:documentation>
- </xs:annotation>
- </xs:attribute>
- <xs:attribute name="parameterName" type="xs:string" use="optional">
- <xs:annotation>
- <xs:documentation>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.</xs:documentation>
- </xs:annotation>
- </xs:attribute>
- </xs:attributeGroup>
- <xs:attributeGroup name="DataItemMeasureRollupAttributes">
- <xs:attribute name="rollupAggregate" use="optional" default="automatic">
- <xs:simpleType>
- <xs:restriction base="xs:NMTOKEN">
- <xs:enumeration value="none">
- <xs:annotation>
- <xs:documentation source="doc_enum_none_rollupAggregate"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="automatic">
- <xs:annotation>
- <xs:documentation source="doc_enum_automatic_rollupAggregate"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="summarize">
- <xs:annotation>
- <xs:documentation source="doc_enum_summarize_rollupAggregate"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="total"/>
- <xs:enumeration value="minimum"/>
- <xs:enumeration value="maximum"/>
- <xs:enumeration value="average"/>
- <xs:enumeration value="count"/>
- <xs:enumeration value="calculated">
- <xs:annotation>
- <xs:documentation source="doc_enum_calculated_rollupAggregate"/>
- </xs:annotation>
- </xs:enumeration>
- <xs:enumeration value="countDistinct"/>
- <xs:enumeration value="standardDeviation"/>
- <xs:enumeration value="variance"/>
- <xs:enumeration value="median"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:attribute>
- </xs:attributeGroup>
- </xs:schema>
|