Oracle Analytics Cloud and Server

Products Banner

BI Publisher mutliple-reports for OTM

Received Response
132
Views
16
Comments

Summary

BI Publisher mutliple-reports for OTM

Content

Hello,

I've managed, thanks to some help from this forum ( ) to activate multi-reporting on OTM, but when I select multiple shipments on OTM, it merges my different reports instead of making 2 distinct reports (either multiple pdf's or 1 pdf with one report after another). What should I do to change that ?

Antoine

Answers

  • Antoine KAIBER
    Antoine KAIBER ✭✭✭✭✭

    Ok, I don't necessarily need multiple PDF's actually, if I can get one PDF but with the ShipmentA report and ShipmentB report with data that hasn't merged it is fine as well. I will send you the documents by mail !

  • Antoine KAIBER
    Antoine KAIBER ✭✭✭✭✭

    Yes one data model. Actually I need to 2 pdf's that come out from one report. Apparently I can't upload anything other than an image, a video or a link, or maybe you know a way to upload word documents here ?

  • send to venkythota54@gmail.com

    Its not possible for generating two pdf files from one report when running report Online.

    You need to use bursting concept to deliever multiple PDF's from single report.

    https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T555155.htm

  • You want to create two separate reports using one data model ? one for shipmnetA and shipmentB.

    upload you xml and template ,along with output samples

  • Can you detail your requirement what you are trying to achieve ?

    what i understood was that you have one data model and on top of that you have to create two separate reports ?

  • Antoine KAIBER
    Antoine KAIBER ✭✭✭✭✭

    So basically I have a data model (image attached) and when I go in OTM (Oracle Transportation Management) and try to run the pick-up sheet report for multiple shipments, I get only one report with is a merger of the two shipments I selected.

    Before I couldn't even select more than 1 shipment ID to run a report but someone helped me by telling me to add the condition "and SH.SHIPMENT_GID in(:P_SHIP_ID)" to my SQL Table (see above) to be able to run multiple reports.

    Now this works but the reports are merged in one PDF (for example in the item area of the report I have all the items of shipment A and Shipment B where I need two reports. One for shipment A and one for shipment B) when I need them to be separate.

  • Antoine KAIBER
    Antoine KAIBER ✭✭✭✭✭

    My SQL table for my Data Set shipment is this :

    select sh.SHIPMENT_GID

    , sh.SHIPMENT_XID

    , sh.DEST_LOCATION_GID

    , coalesce (c1.CORPORATION_NAME,' ') DEST_NAME

    ,coalesce (c1.CORPORATION_GID,' ') DEST_GID

    , l1.LOCATION_NAME DEST_LOC_NAME

    , l1.CITY DEST_CITY

    , l1.POSTAL_CODE DEST_CP

    , l1.COUNTRY_CODE3_GID DEST_COUNTRY

    , ct1.COUNTRY_NAME DEST_COUNTRY_NAME

    , substr(LTRIM(sh.DEST_LOCATION_GID,sh.DOMAIN_NAME||'.'),13,19) DEST_GATE

    , substr(LTRIM(sh.DEST_LOCATION_GID,sh.DOMAIN_NAME||'.'),1,11) DEST_PLANID

    , sh.SOURCE_LOCATION_GID

    , coalesce (c2.CORPORATION_NAME,' ') SRC_NAME

    ,coalesce (c2.CORPORATION_GID,' ') SRC_GID

    , l2.LOCATION_NAME SRC_LOC_NAME

    , l2.CITY SRC_CITY

    , l2.POSTAL_CODE SRC_CP

    , l2.COUNTRY_CODE3_GID SRC_COUNTRY

    , ct2.COUNTRY_NAME SRC_COUNTRY_NAME

    , substr(LTRIM(sh.SOURCE_LOCATION_GID,sh.DOMAIN_NAME||'.'),13,19) SRC_GATE

    , substr(LTRIM(sh.SOURCE_LOCATION_GID,sh.DOMAIN_NAME||'.'),1,11) SRC_PLANID

    , sh.SERVPROV_GID

    , sh.VOYAGE_GID

    , sh.TOTAL_WEIGHT

    , sh.TOTAL_WEIGHT_UOM_CODE

    , sh.TOTAL_VOLUME

    , sh.TOTAL_VOLUME_UOM_CODE

    , sh.TOTAL_SHIP_UNIT_COUNT

    , sh.TOTAL_PACKAGING_UNIT_COUNT

    , sh.TOTAL_ITEM_PACKAGE_COUNT

    , sh.SHIPMENT_TYPE_GID

    from SHIPMENT sh

    ,LOCATION l1 left join LOCATION_CORPORATION lc1

    ON l1.LOCATION_GID= lc1.LOCATION_GID left join CORPORATION c1

    ON lc1.CORPORATION_GID= c1.CORPORATION_GID

    , LOCATION l2 left join LOCATION_CORPORATION lc2

    ON l2.LOCATION_GID= lc2.LOCATION_GID left join CORPORATION c2

    ON lc2.CORPORATION_GID= c2.CORPORATION_GID

    ,COUNTRY_CODE ct1,COUNTRY_CODE ct2

    where l2.LOCATION_GID=sh.SOURCE_LOCATION_GID

    and l1.LOCATION_GID=sh.DEST_LOCATION_GID

    and l1.COUNTRY_CODE3_GID=ct1.COUNTRY_CODE3_GID

    and l2.COUNTRY_CODE3_GID=ct2.COUNTRY_CODE3_GID

    and SH.SHIPMENT_GID in(:P_SHIP_ID)

  • creation of more than one report is possible using single data model. send me documents.

  • Antoine KAIBER
    Antoine KAIBER ✭✭✭✭✭

    Ok i sent you the email

  • Antoine KAIBER
    Antoine KAIBER ✭✭✭✭✭

    I sent you the documents on your address yesterday, you didn't receive them ? I have a yahoo address.

  • Antoine KAIBER
    Antoine KAIBER ✭✭✭✭✭

    I will try to learn more about bursting if you think it is the solution to my problem, though i'm quite a newbie atm.

  • 3371002
    3371002 ✭✭✭✭

    Hi Elkbir,

    Can you please share your solution? I am working on the same issue. Please email your solution to imtiaz20@gmail.com if you cannot share it here.

    Thanks in advance

  • Antoine KAIBER
    Antoine KAIBER ✭✭✭✭✭

    Solved the problem another way. It was a foreach end loop that needed to be activated on all the template and the "start body" needed to be before the loop.

  • Antoine KAIBER
    Antoine KAIBER ✭✭✭✭✭

    Unfortunately I can't share my template for confidentiality reasons, i've already made the mistake of sharing it...But what I can tell you is that my template has this shape :

    <?start:body?>

    for-each

    xxxxx

    yyyyy

    zzzz

    E 

    <?end body?>

    E is the end of the loop and in "For-each" I put "<?for-each-group:SHIPMENT;./SHIPMENT_GID?>".  Hope this helps you !