Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <report xmlns="http://developer.cognos.com/schemas/report/16.2/" useStyleVersion="11.6" expressionLocale="en-us">
- <drillBehavior/>
- <layouts>
- <layout>
- <reportPages>
- <page name="Page1">
- <style>
- <defaultStyles>
- <defaultStyle refStyle="pg"/>
- </defaultStyles>
- </style>
- <pageBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="pb"/>
- </defaultStyles>
- </style>
- <contents>
- <table>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="tb"/>
- </defaultStyles>
- <CSS value="border-collapse:collapse;width:100%"/>
- </style>
- <tableRows>
- <tableRow>
- <tableCells>
- <tableCell>
- <contents>
- <block>
- <contents>
- <textItem>
- <dataSource>
- <staticValue>11.1 Visualizations</staticValue>
- </dataSource>
- </textItem>
- </contents>
- </block>
- <vizControl type="com.ibm.vis.line" name="Line">
- <vcDataSets>
- <vcDataSet idDataSet="data" refDataStore="dataStore">
- <vcSlots>
- <vcSlotData idSlot="categories">
- <vcSlotDsColumns>
- <vcSlotDsColumn refDsColumn="YearMo"/>
- </vcSlotDsColumns>
- </vcSlotData>
- <vcSlotData idSlot="series">
- <vcSlotDsColumns>
- <vcSlotDsColumn refDsColumn="Country"/>
- </vcSlotDsColumns>
- </vcSlotData>
- <vcSlotData idSlot="values">
- <vcSlotDsColumns>
- <vcSlotDsColumn refDsColumn="Cumulative Quantity" rollupMethod="total">
- <vcValueFormat>
- <dataFormat>
- <numberFormat decimalSize="0" scale="-6"/>
- </dataFormat>
- </vcValueFormat>
- </vcSlotDsColumn>
- </vcSlotDsColumns>
- </vcSlotData>
- </vcSlots>
- </vcDataSet>
- </vcDataSets>
- <vizPropertyValues>
- <vizPropertyLengthValue name="vcWidth">550px</vizPropertyLengthValue>
- <vizPropertyLengthValue name="vcHeight">350px</vizPropertyLengthValue>
- <vizPropertyBooleanValue name="markers.visible">false</vizPropertyBooleanValue>
- <vizPropertyCSSFontValue name="itemAxis.title.font">font-size:8pt</vizPropertyCSSFontValue>
- <vizPropertyCSSFontValue name="itemAxis.ticks.labels.font">font-size:8pt</vizPropertyCSSFontValue>
- <vizPropertyCSSFontValue name="valueAxis.title.font">font-size:8pt</vizPropertyCSSFontValue>
- <vizPropertyCSSFontValue name="widget.legend.font">font-size:8pt</vizPropertyCSSFontValue>
- <vizPropertyCSSFontValue name="widget.legend.titleFont">font-size:8pt</vizPropertyCSSFontValue>
- </vizPropertyValues>
- </vizControl>
- </contents>
- <style>
- <CSS value="text-align:left;vertical-align:top"/>
- </style>
- </tableCell>
- <tableCell>
- <contents>
- <block>
- <contents>
- <textItem>
- <dataSource>
- <staticValue>11.0 Visualizations</staticValue>
- </dataSource>
- </textItem>
- </contents>
- </block>
- <viz type="rave-library-line,line" name="Line1" outputType="static">
- <XMLAttributes>
- <XMLAttribute output="no" name="supportsDefaultDataFormatting" value="true"/>
- </XMLAttributes>
- <vizPropertyValues>
- <vizPropertyIntegerValue name="width">550</vizPropertyIntegerValue>
- <vizPropertyIntegerValue name="height">350</vizPropertyIntegerValue>
- <vizPropertyEnumValue name="legend.position">top</vizPropertyEnumValue>
- <vizPropertyEnumValue name="lineWithPoints.display">line</vizPropertyEnumValue>
- <vizPropertyCSSFontValue name="axis.y.labels.style.font">font-size:8pt</vizPropertyCSSFontValue>
- <vizPropertyCSSFontValue name="axis.x.labels.style.font">font-size:8pt</vizPropertyCSSFontValue>
- <vizPropertyCSSFontValue name="axis.y.title.style.font">font-size:8pt</vizPropertyCSSFontValue>
- <vizPropertyCSSFontValue name="axis.x.title.style.font">font-size:8pt</vizPropertyCSSFontValue>
- <vizPropertyCSSFontValue name="legend.titlestyle.font">font-size:8pt</vizPropertyCSSFontValue>
- <vizPropertyCSSFontValue name="legend.entrystyle.font">font-size:8pt</vizPropertyCSSFontValue>
- </vizPropertyValues>
- <vizDataSets>
- <vizDataSet idDataSet="data" name="Line1: Tabular data set" refQuery="Query2">
- <vizCategories>
- <vizCategoryEdge refEdge="xEdge">
- <vizCategoryLevels>
- <vizCategoryLevel>
- <vizCategoryField idField="x" valueRange="all">
- <vizCategoryDataItems>
- <vizCategoryDataItem refDataItem="YearMo"/>
- </vizCategoryDataItems>
- </vizCategoryField>
- </vizCategoryLevel>
- </vizCategoryLevels>
- </vizCategoryEdge>
- <vizCategoryEdge refEdge="colorEdge">
- <vizCategoryLevels>
- <vizCategoryLevel>
- <vizCategoryField idField="color" valueRange="all">
- <vizCategoryDataItems>
- <vizCategoryDataItem refDataItem="Country"/>
- </vizCategoryDataItems>
- </vizCategoryField>
- </vizCategoryLevel>
- </vizCategoryLevels>
- </vizCategoryEdge>
- </vizCategories>
- <vizValues>
- <vizValue idField="y" refDataItem="Cumulative Quantity">
- <vizValueRange>
- <vizValueRangeComputed rangeData="all"/>
- </vizValueRange>
- <style>
- <dataFormat>
- <numberFormat decimalSize="0" scale="-6"/>
- </dataFormat>
- </style>
- </vizValue>
- </vizValues>
- </vizDataSet>
- </vizDataSets>
- </viz>
- </contents>
- <style>
- <CSS value="text-align:left;vertical-align:top"/>
- </style>
- </tableCell>
- </tableCells>
- </tableRow>
- <tableRow>
- <tableCells>
- <tableCell>
- <contents>
- <block>
- <contents>
- <textItem>
- <dataSource>
- <staticValue>Legacy Visualizations</staticValue>
- </dataSource>
- </textItem>
- </contents>
- </block>
- <viz type="az.Line" name="Line2" outputType="static">
- <XMLAttributes>
- <XMLAttribute output="no" name="supportsDefaultDataFormatting" value="true"/>
- </XMLAttributes>
- <vizPropertyValues>
- <vizPropertyIntegerValue name="width">550</vizPropertyIntegerValue>
- <vizPropertyIntegerValue name="height">350</vizPropertyIntegerValue>
- <vizPropertyEnumValue name="legendLocation">top</vizPropertyEnumValue>
- <vizPropertyColorValue name="chartBodyColor" r="0" g="0" b="0" a="0"/>
- <vizPropertyColorValue name="firstNumericAxisGridlineColor" r="192" g="192" b="192"/>
- <vizPropertyColorValue name="categoryAxisLineColor" r="192" g="192" b="192"/>
- <vizPropertyColorValue name="firstNumericAxisLineColor" r="192" g="192" b="192"/>
- <vizPropertyFontValue name="labelFont" family="Arial Unicode MS, Andale WT, Tahoma, Arial, MS UI Gothic, Gulim, SimSun, PMingLiU, Raghu8, sans-serif" size="8pt" weight="normal" style="normal"/>
- </vizPropertyValues>
- <vizDataSets>
- <vizDataSet idDataSet="dataSet" name="Line2: Data" refQuery="Query2">
- <vizCategories>
- <vizCategoryEdge refEdge="categoriesEdge">
- <vizCategoryLevels>
- <vizCategoryLevel>
- <vizCategoryField idField="categories" valueRange="all">
- <vizCategoryDataItems>
- <vizCategoryDataItem refDataItem="YearMo"/>
- </vizCategoryDataItems>
- </vizCategoryField>
- </vizCategoryLevel>
- </vizCategoryLevels>
- </vizCategoryEdge>
- <vizCategoryEdge refEdge="seriesEdge">
- <vizCategoryLevels>
- <vizCategoryLevel>
- <vizCategoryField idField="series" valueRange="all">
- <vizCategoryDataItems>
- <vizCategoryDataItem refDataItem="Country"/>
- </vizCategoryDataItems>
- </vizCategoryField>
- </vizCategoryLevel>
- </vizCategoryLevels>
- </vizCategoryEdge>
- </vizCategories>
- <vizValues>
- <vizValue idField="size" refDataItem="Cumulative Quantity">
- <vizValueRange>
- <vizValueRangeComputed rangeData="all"/>
- </vizValueRange>
- <style>
- <dataFormat>
- <numberFormat scale="-6" decimalSize="0"/>
- </dataFormat>
- </style>
- </vizValue>
- </vizValues>
- </vizDataSet>
- </vizDataSets>
- </viz>
- </contents>
- <style>
- <CSS value="text-align:left;vertical-align:top"/>
- </style>
- </tableCell>
- <tableCell>
- <contents>
- <block>
- <contents>
- <textItem>
- <dataSource>
- <staticValue>Charts</staticValue>
- </dataSource>
- </textItem>
- </contents>
- </block>
- <v2_combinationChart maxHotspots="10000" name="Combination chart1" refQuery="Query2">
- <v2_combinationTypeTooltips/>
- <v2_commonAxis>
- <v2_ordinalAxis>
- <v2_axisTitle refQuery="Query2">
- <v2_chartTextContents>
- <v2_automaticText/>
- </v2_chartTextContents>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="at"/>
- </defaultStyles>
- <CSS value="font-size:8pt"/>
- </style>
- </v2_axisTitle>
- <v2_axisLine lineWeight="0"/>
- <v2_axisLabels>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="al"/>
- </defaultStyles>
- <CSS value="font-size:8pt"/>
- </style>
- </v2_axisLabels>
- </v2_ordinalAxis>
- <chartNodes>
- <chartNode>
- <chartNodeMembers>
- <chartNodeMember refDataItem="YearMo">
- <chartContents>
- <chartTextItem>
- <dataSource>
- <memberCaption/>
- </dataSource>
- </chartTextItem>
- </chartContents>
- </chartNodeMember>
- </chartNodeMembers>
- </chartNode>
- </chartNodes>
- </v2_commonAxis>
- <v2_topLeftAxis>
- <v2_combinationChartTypes>
- <v2_line>
- <v2_linePalette markerSize="5pt">
- <v2_linePaletteEntries>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#8599D3">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#8599D3"/>
- <v2_gradientColor colorPosition="100" gradientColor="#5876AE"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#8599D3"/>
- <v2_gradientColor colorPosition="100" gradientColor="#5876AE"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#E3AE6C">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#E3AE6C"/>
- <v2_gradientColor colorPosition="100" gradientColor="#CD854E"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#E3AE6C"/>
- <v2_gradientColor colorPosition="100" gradientColor="#CD854E"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#839862">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#839862"/>
- <v2_gradientColor colorPosition="100" gradientColor="#6C7F56"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#839862"/>
- <v2_gradientColor colorPosition="100" gradientColor="#6C7F56"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#B7C873">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#B7C873"/>
- <v2_gradientColor colorPosition="100" gradientColor="#AFB885"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#B7C873"/>
- <v2_gradientColor colorPosition="100" gradientColor="#AFB885"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#8484A8">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#8484A8"/>
- <v2_gradientColor colorPosition="100" gradientColor="#525E7E"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#8484A8"/>
- <v2_gradientColor colorPosition="100" gradientColor="#525E7E"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#C0CCED">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#C0CCED"/>
- <v2_gradientColor colorPosition="100" gradientColor="#B0C2E5"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#C0CCED"/>
- <v2_gradientColor colorPosition="100" gradientColor="#B0C2E5"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#8C5580">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#8C5580"/>
- <v2_gradientColor colorPosition="100" gradientColor="#794067"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#8C5580"/>
- <v2_gradientColor colorPosition="100" gradientColor="#794067"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#C789BC">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#C789BC"/>
- <v2_gradientColor colorPosition="100" gradientColor="#BB72BC"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#C789BC"/>
- <v2_gradientColor colorPosition="100" gradientColor="#BB72BC"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#D5BAEF">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#D5BAEF"/>
- <v2_gradientColor colorPosition="100" gradientColor="#C29FD1"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#D5BAEF"/>
- <v2_gradientColor colorPosition="100" gradientColor="#C29FD1"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#83683F">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#83683F"/>
- <v2_gradientColor colorPosition="100" gradientColor="#604926"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#83683F"/>
- <v2_gradientColor colorPosition="100" gradientColor="#604926"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#DCB05A">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#DCB05A"/>
- <v2_gradientColor colorPosition="100" gradientColor="#C09C52"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#DCB05A"/>
- <v2_gradientColor colorPosition="100" gradientColor="#C09C52"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#F4DF9E">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#F4DF9E"/>
- <v2_gradientColor colorPosition="100" gradientColor="#E4CF87"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#F4DF9E"/>
- <v2_gradientColor colorPosition="100" gradientColor="#E4CF87"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#5F8A8C">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#5F8A8C"/>
- <v2_gradientColor colorPosition="100" gradientColor="#537579"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#5F8A8C"/>
- <v2_gradientColor colorPosition="100" gradientColor="#537579"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#96C4B2">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#96C4B2"/>
- <v2_gradientColor colorPosition="100" gradientColor="#89B0A0"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#96C4B2"/>
- <v2_gradientColor colorPosition="100" gradientColor="#89B0A0"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#CBE8E7">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#CBE8E7"/>
- <v2_gradientColor colorPosition="100" gradientColor="#BDD6D5"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#CBE8E7"/>
- <v2_gradientColor colorPosition="100" gradientColor="#BDD6D5"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#AE6564">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#AE6564"/>
- <v2_gradientColor colorPosition="100" gradientColor="#875352"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#AE6564"/>
- <v2_gradientColor colorPosition="100" gradientColor="#875352"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#D88C6F">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#D88C6F"/>
- <v2_gradientColor colorPosition="100" gradientColor="#C47D61"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#D88C6F"/>
- <v2_gradientColor colorPosition="100" gradientColor="#C47D61"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#E3C9B0">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#E3C9B0"/>
- <v2_gradientColor colorPosition="100" gradientColor="#D2B2A5"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#E3C9B0"/>
- <v2_gradientColor colorPosition="100" gradientColor="#D2B2A5"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#848484">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#848484"/>
- <v2_gradientColor colorPosition="100" gradientColor="#555555"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#848484"/>
- <v2_gradientColor colorPosition="100" gradientColor="#555555"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#a4a4a4">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#a4a4a4"/>
- <v2_gradientColor colorPosition="100" gradientColor="#909090"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#a4a4a4"/>
- <v2_gradientColor colorPosition="100" gradientColor="#909090"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- <v2_linePaletteEntry>
- <v2_lineFill defaultColor="#C7C7C7">
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#C7C7C7"/>
- <v2_gradientColor colorPosition="100" gradientColor="#c1c1c1"/>
- </v2_linearGradient>
- </v2_lineFill>
- <v2_pointPaletteEntry>
- <v2_fillEffect>
- <v2_linearGradient>
- <v2_gradientColor gradientColor="#C7C7C7"/>
- <v2_gradientColor colorPosition="100" gradientColor="#c1c1c1"/>
- </v2_linearGradient>
- </v2_fillEffect>
- </v2_pointPaletteEntry>
- </v2_linePaletteEntry>
- </v2_linePaletteEntries>
- </v2_linePalette>
- <chartNodes>
- <chartNode>
- <chartNodeMembers>
- <chartNodeMember refDataItem="Country">
- <chartContents>
- <chartTextItem>
- <dataSource>
- <memberCaption/>
- </dataSource>
- </chartTextItem>
- </chartContents>
- </chartNodeMember>
- </chartNodeMembers>
- </chartNode>
- </chartNodes>
- </v2_line>
- </v2_combinationChartTypes>
- <v2_axis>
- <v2_axisTitle refQuery="Query2">
- <v2_chartTextContents>
- <v2_automaticText/>
- </v2_chartTextContents>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="at"/>
- </defaultStyles>
- <CSS value="font-size:8pt"/>
- </style>
- </v2_axisTitle>
- <v2_axisLine lineWeight="0"/>
- <v2_axisRange>
- <v2_automaticRange/>
- </v2_axisRange>
- <v2_axisLabels>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="al"/>
- </defaultStyles>
- <CSS value="font-size:8pt"/>
- <dataFormat>
- <numberFormat decimalSize="0" scale="-6"/>
- </dataFormat>
- </style>
- </v2_axisLabels>
- <v2_majorGridlines lineWeight="0" lineColor="#CCCCCC"/>
- </v2_axis>
- </v2_topLeftAxis>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="ch"/>
- </defaultStyles>
- <CSS value="width:550px;height:350px"/>
- </style>
- <noDataHandler>
- <contents>
- <block>
- <contents>
- <textItem>
- <dataSource>
- <staticValue>No Data Available</staticValue>
- </dataSource>
- </textItem>
- </contents>
- <style>
- <CSS value="padding:16px;"/>
- </style>
- </block>
- </contents>
- </noDataHandler>
- <v2_defaultChartMeasure refDataItem="Cumulative Quantity"/>
- <v2_legend>
- <v2_legendPosition>
- <v2_legendPreset legendPositionPreset="top"/>
- </v2_legendPosition>
- <v2_legendTitle refQuery="Query2">
- <v2_chartTextContents>
- <v2_automaticText/>
- </v2_chartTextContents>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lx"/>
- </defaultStyles>
- <CSS value="font-size:8pt"/>
- </style>
- </v2_legendTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lg"/>
- </defaultStyles>
- <CSS value="font-size:8pt"/>
- </style>
- </v2_legend>
- </v2_combinationChart>
- </contents>
- <style>
- <CSS value="text-align:left;vertical-align:top"/>
- </style>
- </tableCell>
- </tableCells>
- </tableRow>
- </tableRows>
- </table>
- </contents>
- </pageBody>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_legacyDrillDown" value="0"/>
- </XMLAttributes>
- </page>
- </reportPages>
- </layout>
- </layouts>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_CreateExtendedDataItems" value="true"/>
- <XMLAttribute output="no" name="listSeparator" value=","/>
- <XMLAttribute output="no" name="decimalSeparator" value="."/>
- <XMLAttribute output="no" name="RS_modelModificationTime" value="2015-11-25T21:38:24.820Z"/>
- </XMLAttributes>
- <queries>
- <query name="Query1">
- <source>
- <model/>
- </source>
- <selection>
- <dataItem aggregate="none" rollupAggregate="none" name="Country">
- <expression>[Sales (query)].[Branch].[Country]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Year">
- <expression>[Sales (query)].[Time].[Year]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="1"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Month (numeric)">
- <expression>[Sales (query)].[Time].[Month (numeric)]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="1"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem name="YearMo" aggregate="none" rollupAggregate="none">
- <expression>cast([Year] * 100 + [Month (numeric)], varchar(6))</expression>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Month Abbrev">
- <expression>substring([Sales (query)].[Time].[Month], 1, 3)</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem name="Mon Year" aggregate="none" rollupAggregate="none">
- <expression>[Month Abbrev] + ' ' + cast([Year] as varchar(10))</expression>
- </dataItem>
- <dataItem aggregate="total" name="Quantity">
- <expression>[Sales (query)].[Sales].[Quantity]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="1"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="2"/>
- </XMLAttributes>
- </dataItem>
- </selection>
- <detailFilters>
- <detailFilter>
- <filterExpression>[Country] starts with 'S'</filterExpression>
- </detailFilter>
- </detailFilters>
- </query>
- <query name="Query2">
- <source>
- <queryRef refQuery="Query1"/>
- </source>
- <selection>
- <dataItem aggregate="none" rollupAggregate="none" name="Country">
- <expression>[Query1].[Country]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Year">
- <expression>[Query1].[Year]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="1"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Month (numeric)">
- <expression>[Query1].[Month (numeric)]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="1"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="YearMo">
- <expression>[Query1].[YearMo]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="1"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Month Abbrev">
- <expression>[Query1].[Month Abbrev]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Mon Year">
- <expression>[Query1].[Mon Year]</expression>
- </dataItem>
- <dataItem name="Cumulative Quantity" aggregate="total" rollupAggregate="total">
- <expression>running-total([Query1].[Quantity] for [Country])</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="2"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="2"/>
- </XMLAttributes>
- </dataItem>
- </selection>
- </query>
- </queries>
- <modelPath>/content/folder[@name='Samples']/folder[@name='Models']/package[@name='GO sales (query)']/model[@name='model']</modelPath>
- <reportName>Broken Charts</reportName>
- <reportDataStores>
- <reportDataStore name="dataStore">
- <dsSource>
- <dsV5ListQuery refQuery="Query2">
- <dsV5DataItems>
- <dsV5DataItem dsColumnType="value" refDataItem="Cumulative Quantity"/>
- <dsV5DataItem dsColumnType="indexed" refDataItem="Country"/>
- <dsV5DataItem dsColumnType="indexed" refDataItem="YearMo"/>
- </dsV5DataItems>
- </dsV5ListQuery>
- </dsSource>
- </reportDataStore>
- </reportDataStores>
- </report>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement