Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
<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

This comment has been minimized.

Copy link

@mahfoud13 mahfoud13 commented Jul 10, 2015

pop

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.