Skip to content

Instantly share code, notes, and snippets.

@rmoff
Created March 22, 2013 10:08
Show Gist options
  • Save rmoff/5220265 to your computer and use it in GitHub Desktop.
Save rmoff/5220265 to your computer and use it in GitHub Desktop.
<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1">
<saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;A - Sample Sales&quot;">
<saw:columns>
<saw:column xsi:type="saw:regularColumn" columnID="cf43f9bc2886b224b">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Time"."T03 Per Name Qtr"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cf87e6e5395c89ec3">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Orders"."R2 Order Type"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="ce5f7785783d54d4a">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Base Facts"."1- Revenue"</sawx:expr></saw:columnFormula></saw:column></saw:columns>
<saw:columnOrder>
<saw:columnOrderRef columnID="cf87e6e5395c89ec3" direction="ascending"/>
<saw:columnOrderRef columnID="cf43f9bc2886b224b" direction="ascending"/></saw:columnOrder></saw:criteria>
<saw:views currentView="0">
<saw:view xsi:type="saw:compoundView" name="compoundView!1">
<saw:cvTable>
<saw:cvRow>
<saw:cvCell viewName="htmlview!1" colSpan="2"/>
<saw:cvCell viewName="tableView!1" rowSpan="3"/></saw:cvRow>
<saw:cvRow>
<saw:cvCell viewName="trellisView!1">
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:cvCell>
<saw:cvCell viewName="pivotTableView!2"/></saw:cvRow>
<saw:cvRow>
<saw:cvCell viewName="pivotTableView!1" colSpan="2">
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:cvCell></saw:cvRow></saw:cvTable></saw:view>
<saw:view xsi:type="saw:titleView" name="titleView!1"/>
<saw:view xsi:type="saw:tableView" name="tableView!1" rowsPerPage="90">
<saw:edges>
<saw:edge axis="page" showColumnHeader="true"/>
<saw:edge axis="section"/>
<saw:edge axis="row" showColumnHeader="true">
<saw:edgeLayers>
<saw:edgeLayer type="column" columnID="cf87e6e5395c89ec3"/>
<saw:edgeLayer type="column" columnID="cf43f9bc2886b224b"/>
<saw:edgeLayer type="column" columnID="ce5f7785783d54d4a"/></saw:edgeLayers></saw:edge>
<saw:edge axis="column"/></saw:edges></saw:view>
<saw:view xsi:type="saw:pivotTableView" name="pivotTableView!1">
<saw:edges>
<saw:edge axis="page" showColumnHeader="true"/>
<saw:edge axis="section"/>
<saw:edge axis="row" showColumnHeader="true">
<saw:displayGrandTotals>
<saw:displayGrandTotal id="t1" grandTotalPosition="none"/></saw:displayGrandTotals>
<saw:edgeLayers>
<saw:edgeLayer type="column" columnID="cf87e6e5395c89ec3"/></saw:edgeLayers></saw:edge>
<saw:edge axis="column">
<saw:displayGrandTotals>
<saw:displayGrandTotal id="t1" grandTotalPosition="none"/></saw:displayGrandTotals>
<saw:edgeLayers>
<saw:edgeLayer type="measure"/>
<saw:edgeLayer type="column" columnID="cf43f9bc2886b224b"/></saw:edgeLayers></saw:edge></saw:edges>
<saw:measuresList>
<saw:measure columnID="ce5f7785783d54d4a"/></saw:measuresList></saw:view>
<saw:view xsi:type="saw:trellisView" name="trellisView!1" type="multiviz">
<saw:nestedViews>
<saw:nestedView position="embedded">
<saw:view xsi:type="saw:dvtmicrochart" name="Trellisf77101131aea5ac8">
<saw:display type="line" subtype="default" renderFormat="default" mode="online">
<saw:style barStyle="default" lineStyle="default" scatterStyle="default" fillStyle="default" bubblePercentSize="100" effect="2d"/></saw:display>
<saw:canvasFormat height="13" width="100">
<saw:dataLabels display="default" label="default" position="below" transparentBackground="true" valueAs="default"/></saw:canvasFormat>
<saw:selections>
<saw:categories>
<saw:category>
<saw:columnRef columnID="cf43f9bc2886b224b"/></saw:category></saw:categories>
<saw:measures showMeasureLabelsOnCategory="false">
<saw:column measureType="y">
<saw:columnRef columnID="ce5f7785783d54d4a"/></saw:column></saw:measures>
<saw:seriesGenerators>
<saw:measureLabels/></saw:seriesGenerators></saw:selections>
<saw:legendFormat position="default" transparentFill="true"/></saw:view></saw:nestedView></saw:nestedViews>
<saw:edges>
<saw:edge axis="page" showColumnHeader="true"/>
<saw:edge axis="section"/>
<saw:edge axis="row" showColumnHeader="true">
<saw:edgeLayers>
<saw:edgeLayer type="column" columnID="cf87e6e5395c89ec3"/></saw:edgeLayers></saw:edge>
<saw:edge axis="column" dependent="true">
<saw:edgeLayers>
<saw:edgeLayer type="measure"/></saw:edgeLayers></saw:edge></saw:edges>
<saw:measuresList>
<saw:measure columnID="ce5f7785783d54d4a" name="Trellisf77101131aea5ac8" type="view"/>
<saw:measure columnID="ce5f7785783d54d4a" name="Trellis68eeef51734d07a7" duplicateID="d2" aggRule="first">
<saw:memberFormat>
<saw:displayFormat>
<saw:formatSpec wrapText="true"/></saw:displayFormat>
<saw:caption>
<saw:text>First</saw:text></saw:caption></saw:memberFormat></saw:measure>
<saw:measure columnID="ce5f7785783d54d4a" name="Trellis1cfc9c7ddd53258e" duplicateID="d1" aggRule="last">
<saw:memberFormat>
<saw:displayFormat>
<saw:formatSpec wrapText="true"/></saw:displayFormat>
<saw:caption>
<saw:text>Last</saw:text></saw:caption></saw:memberFormat></saw:measure></saw:measuresList></saw:view>
<saw:view xsi:type="saw:pivotTableView" name="pivotTableView!2">
<saw:edges>
<saw:edge axis="page" showColumnHeader="true"/>
<saw:edge axis="section"/>
<saw:edge axis="row" showColumnHeader="true">
<saw:displayGrandTotals>
<saw:displayGrandTotal id="t1" grandTotalPosition="none"/></saw:displayGrandTotals>
<saw:edgeLayers>
<saw:edgeLayer type="column" columnID="cf87e6e5395c89ec3"/></saw:edgeLayers></saw:edge>
<saw:edge axis="column">
<saw:displayGrandTotals>
<saw:displayGrandTotal id="t1" grandTotalPosition="none"/></saw:displayGrandTotals>
<saw:edgeLayers>
<saw:edgeLayer type="measure"/></saw:edgeLayers></saw:edge></saw:edges>
<saw:measuresList>
<saw:measure columnID="ce5f7785783d54d4a" aggRule="first">
<saw:memberFormat>
<saw:displayFormat>
<saw:formatSpec wrapText="true"/></saw:displayFormat>
<saw:caption>
<saw:text>First</saw:text></saw:caption></saw:memberFormat></saw:measure>
<saw:measure columnID="ce5f7785783d54d4a" aggRule="last" duplicateID="d4">
<saw:memberFormat>
<saw:displayFormat>
<saw:formatSpec wrapText="true"/></saw:displayFormat>
<saw:caption>
<saw:text>Last</saw:text></saw:caption></saw:memberFormat></saw:measure></saw:measuresList></saw:view>
<saw:view xsi:type="saw:htmlview" name="htmlview!1">
<saw:staticText>
<saw:caption fmt="text">
<saw:text>Having set the sort order for the dimensions in the [b]Criteria[/b], is it 'safe' to use First and Last aggregation rules in the [b]Trellis[/b] view? </saw:text></saw:caption></saw:staticText></saw:view></saw:views></saw:report>
@mahfoud13
Copy link

pop

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment