Question

How can I run a report in Analytics to retrieve all recently cancelled Rialto Orders?

Answer

While there is not an out-of-the-box report at this time, this can be achieved by pasting the following code into the Advanced > Analysis XML box when creating a new report in Analytics. This will recall Rialto orders cancelled within the last 60 days, but can be modified to suit more specific needs by editing the filters manually on the Criteria page of your new report, once the XML is applied. 

<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" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlVersion="201201160">
   <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;Purchase Requests&quot;" withinHierarchy="true">
      <saw:columns>
         <saw:column xsi:type="saw:regularColumn" columnID="c6cebd11b64e38739">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Rialto Selector"."Rialto Selector Full Name"</sawx:expr></saw:columnFormula></saw:column>
         <saw:column xsi:type="saw:regularColumn" columnID="c67817a8e99350f5b">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Bibliographic Details"."Title"</sawx:expr></saw:columnFormula></saw:column>
         <saw:column xsi:type="saw:regularColumn" columnID="c0015d1720f49b712">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Bibliographic Details"."ISBN"</sawx:expr></saw:columnFormula></saw:column>
         <saw:column xsi:type="saw:regularColumn" columnID="cb8a5326b35bdcf59">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Bibliographic Details"."Modification Date (Calendar)"</sawx:expr></saw:columnFormula></saw:column>
         <saw:column xsi:type="saw:regularColumn" columnID="c3e32bf5d9ec7af24">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Bibliographic Details"."Publication Date"</sawx:expr></saw:columnFormula></saw:column>
         <saw:column xsi:type="saw:regularColumn" columnID="ce5efdd0f94d40466">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Bibliographic Details"."Publisher"</sawx:expr></saw:columnFormula></saw:column>
         <saw:column xsi:type="saw:regularColumn" columnID="cc90ebdbe6616813d">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Purchase Request Measures"."Estimated Cost"</sawx:expr></saw:columnFormula></saw:column>
         <saw:column xsi:type="saw:regularColumn" columnID="c071a53ef57abfce3">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Purchase Request Details"."Requested Format"</sawx:expr></saw:columnFormula></saw:column></saw:columns>
      <saw:filter>
         <sawx:expr xsi:type="sawx:logical" op="and">
            <sawx:expr xsi:type="sawx:logical" op="or">
               <sawx:expr xsi:type="sawx:list" op="in">
                  <sawx:expr xsi:type="sawx:sqlExpression">"Rialto Request Details"."Rialto Order Status"</sawx:expr>
                  <sawx:expr xsi:type="xsd:string">Canceled - not available</sawx:expr>
                  <sawx:expr xsi:type="xsd:string">Canceled - open access</sawx:expr>
                  <sawx:expr xsi:type="xsd:string">Cancelled</sawx:expr>
                  <sawx:expr xsi:type="xsd:string">Cancelled as Requested</sawx:expr>
                  <sawx:expr xsi:type="xsd:string">Cancelled by request</sawx:expr>
                  <sawx:expr xsi:type="xsd:string">Cancelled-No Reply to Orders/Claims</sawx:expr></sawx:expr>
               <sawx:expr xsi:type="sawx:list" op="containsAny">
                  <sawx:expr xsi:type="sawx:sqlExpression">"Rialto Request Details"."Rialto Order Status"</sawx:expr>
                  <sawx:expr xsi:type="xsd:string">Cancelled</sawx:expr></sawx:expr></sawx:expr>
            <sawx:expr xsi:type="sawx:sql">"Bibliographic Details"."Modification Date (Calendar)" &gt;= TIMESTAMPADD(SQL_TSI_DAY, -60, CURRENT_DATE)</sawx:expr></sawx:expr></saw:filter></saw:criteria>
   <saw:views currentView="0">
      <saw:view xsi:type="saw:compoundView" name="compoundView!1">
         <saw:cvTable>
            <saw:cvRow>
               <saw:cvCell viewName="titleView!1"/></saw:cvRow>
            <saw:cvRow>
               <saw:cvCell viewName="tableView!1"/></saw:cvRow></saw:cvTable></saw:view>
      <saw:view xsi:type="saw:titleView" name="titleView!1"/>
      <saw:view xsi:type="saw:tableView" name="tableView!1" scrollingEnabled="false">
         <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="c6cebd11b64e38739"/>
                  <saw:edgeLayer type="column" columnID="c67817a8e99350f5b"/>
                  <saw:edgeLayer type="column" columnID="c0015d1720f49b712"/>
                  <saw:edgeLayer type="column" columnID="cb8a5326b35bdcf59"/>
                  <saw:edgeLayer type="column" columnID="cc90ebdbe6616813d"/>
                  <saw:edgeLayer type="column" columnID="c071a53ef57abfce3"/>
                  <saw:edgeLayer type="column" columnID="c3e32bf5d9ec7af24"/>
                  <saw:edgeLayer type="column" columnID="ce5efdd0f94d40466"/></saw:edgeLayers></saw:edge>
            <saw:edge axis="column" showColumnHeader="rollover"/></saw:edges></saw:view></saw:views></saw:report>

• Article last edited: 28-APR-2021