trellis_pivot_firstlast.xml

<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>

pop