This discussion is archived
0 Replies Latest reply: Nov 30, 2012 12:20 AM by 922503 RSS

BI publisher Reports

922503 Newbie
Currently Being Moderated
Hi All,

We are working on BI Publisher reports

We are uploading the XML file in the MSword then after data sucessfully loaded, we are uploading the RTF file ( same uploaded xml file ) in the BI Publisher Enterprise.

Once these things done we are trying to view the output ( using the "view" option )

we can only see the header details but not fetching the data.


In the data model we have used this code in the SQL Query field :

select request_id
,ad.city
,psr.rk_store_type store_type
, rsi.quantity_received
, rsi.quantity_damaged
, rir.status
, rir.process_date
, rir.created_by
, rir.create_datetime
from item_request_report_v irrv
,address_detail ad
,pa_str_rtl psr
,rk_shipment_item rsi
,rk_item_request rir
where irrv.store_id=ad.entity_id
AND irrv.store_id=psr.id_str_rt
And rir.item_request_id= irrv.request_id


*****************************************************************

XML code :

<?xml version = '1.0' encoding = 'utf-8'?>
<report version="1.1" xmlns="http://xmlns.oracle.com/oxp/xmlp" defaultDataSourceRef="BIP-SIM-DATASOURCE">
<title>ItemRequestReport</title>
<properties>
<property name="showControls" value="true"/>
<property name="online" value="true"/>
<property name="parameterColumns" value="3"/>
<property name="openLinkInNewWindow" value="true"/>
<property name="autoRun" value="true"/>
</properties>
<dataModel defaultDataSet="ItemReqDataSet">
<dataSet id="ItemReqDataSet">
<sql dataSourceRef="BIP-SIM-DATASOURCE">
<![CDATA[select request_id
      ,ad.city
      ,psr.rk_store_type store_type
      , rsi.quantity_received
      , rsi.quantity_damaged
      , rir.status
      , rir.process_date
      , rir.created_by
      , rir.create_datetime
    from item_request_report_v irrv
    ,address_detail ad
    ,pa_str_rtl psr
    ,rk_shipment_item rsi
    ,rk_item_request rir
where irrv.store_id=ad.entity_id
AND   irrv.store_id=psr.id_str_rt
And   rir.item_request_id= irrv.request_id
]]>
</sql>

<group name="Digi_G_1" source="BIP-SIM-DATASOURCE">
          <element name=" request_id" value="request_id" />
          <element name="ad.city" value="ad.city" />
          <element name="store_type" value="store_type"/>     
          <element name="rsi.quantity_received" value="rsi.quantity_received" />
          <element name="rsi.quantity_damaged" value="rsi.quantity_damaged" />
          <element name="rir.status" value="rir.status" />
          <element name="rir.process_date" value="rir.process_date" />
          <element name="rir.created_by" value="rir.created_by" />
          <element name="rir.create_datetime" value="rir.create_datetime" />
</group>
          
<input id="Store_Timezone" value="${Store_Timezone}" dataType="xsd:string"/>
<input id="Item_Request_ID" value="${Item_Request_ID}" dataType="xsd:string"/>
</dataSet>
</dataModel>
<valueSets/>
<parameters>
<parameter id="Item_Request_ID">
<input label="Item_Request_ID"/>
</parameter>
<parameter id="Store_Timezone">
<input label="Store Timezone"/>
</parameter>
</parameters>
<templates default="ItemRequestTemplate">
<template label="ItemRequestTemplate" type="rtf" url="ItemRequestTemplate.rtf"/>
</templates>
<burst enabled="false"/>
</report>

Mapping has been done accordingly.

please let us know what we have do to resolve the issue.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points