General OBIEE

Get Involved. Join the Conversation.

Topic

    Dylan Donahue
    Only half of scheduled report being delivered
    Topic posted February 2, 2016 by Dylan DonahueBronze Medal: 1,250+ Points, tagged Analyses, Customizing Layout, Customizing Reports, OBI Answers, OTBI, Report Delivery, Report Layouts, Reports, Taleo Enterprise 
    61 Views
    Title:
    Only half of scheduled report being delivered
    Summary:
    I set up an agent to deliver the contents of a dashboard. Only half is coming through...
    Content:

    Hi - I'm having an issue now where only half of a dashboard page is coming through.  I've had success doing this in the past. I just created a new agent, doing the same thing, and only one of two analyses on a dashboard page are coming through...  Does anyone know why this may be?  Below is the XML of the Analysis that is not showing:

    <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;Recruiting&quot;" withinHierarchy="true">
          <saw:columns>
             <saw:column xsi:type="saw:regularColumn" columnID="c8c323f285e5532f6">
                <saw:columnFormula>
                   <sawx:expr xsi:type="sawx:sqlExpression">"Requisition Organization"."Organization Level1 Name"</sawx:expr></saw:columnFormula></saw:column>
             <saw:column xsi:type="saw:regularColumn" columnID="c34cfef58f7e8d2a9">
                <saw:columnFormula>
                   <sawx:expr xsi:type="sawx:sqlExpression">"Requisition Identification"."Req. Identifier"</sawx:expr></saw:columnFormula></saw:column>
             <saw:column xsi:type="saw:regularColumn" columnID="cd3172937d67abc07">
                <saw:columnFormula>
                   <sawx:expr xsi:type="sawx:sqlExpression">"Requisition Identification"."Title (BL)"</sawx:expr></saw:columnFormula>
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Requisition Identification</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat>
                   <saw:caption fmt="text">
                      <saw:text>Position Title</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:regularColumn" columnID="cc45e88481e6366ea">
                <saw:columnFormula>
                   <sawx:expr xsi:type="sawx:sqlExpression">"Requisition Status - Current"."Current Status"</sawx:expr></saw:columnFormula></saw:column>
             <saw:column xsi:type="saw:regularColumn" columnID="c48631c48dad1fd96">
                <saw:columnFormula>
                   <sawx:expr xsi:type="sawx:sqlExpression">"Requisition Recruiter"."Recruiter Name"</sawx:expr></saw:columnFormula></saw:column></saw:columns>
          <saw:filter>
             <sawx:expr xsi:type="sawx:logical" op="and">
                <sawx:expr xsi:type="sawx:comparison" op="equal">
                   <sawx:expr xsi:type="sawx:sqlExpression">"Requisition Organization"."Organization Level1 Name"</sawx:expr>
                   <sawx:expr xsi:type="xsd:string">OMG Media Services (P&amp;G)</sawx:expr></sawx:expr>
                <sawx:expr xsi:type="sawx:list" op="in">
                   <sawx:expr xsi:type="sawx:sqlExpression">"Requisition Status - Current"."Current Status"</sawx:expr>
                   <sawx:expr xsi:type="xsd:string">Approved</sawx:expr>
                   <sawx:expr xsi:type="xsd:string">Draft</sawx:expr>
                   <sawx:expr xsi:type="xsd:string">Sourcing</sawx:expr></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:displayFormat>
                         <saw:formatSpec/></saw:displayFormat></saw:cvCell></saw:cvRow>
                <saw:cvRow>
                   <saw:cvCell viewName="tableView!1">
                      <saw:displayFormat>
                         <saw:formatSpec/></saw:displayFormat></saw:cvCell></saw:cvRow></saw:cvTable></saw:view>
          <saw:view xsi:type="saw:titleView" name="titleView!1" includeName="true" startedDisplay="none"/>
          <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="c8c323f285e5532f6"/>
                      <saw:edgeLayer type="column" columnID="c34cfef58f7e8d2a9"/>
                      <saw:edgeLayer type="column" columnID="cd3172937d67abc07"/>
                      <saw:edgeLayer type="column" columnID="cc45e88481e6366ea"/>
                      <saw:edgeLayer type="column" columnID="c48631c48dad1fd96"/></saw:edgeLayers></saw:edge>
                <saw:edge axis="column" showColumnHeader="rollover"/></saw:edges></saw:view></saw:views></saw:report>