Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Generate ZIP file out of CSV-XML Output from Report

Submitted
483
Views
6
Comments
user5017886
user5017886 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Description

We have requirement to generate the zip file consist of BI report CSV and XML output and have to upload it to UCM server for further processing

Use Case and Business Need

We have requirement to generate the zip file consist of BI report CSV and XML output and have to upload it to UCM server for further processing

More details

Currently this functionality is not supported

Original Idea Number: 636fb5e065

Tagged:
2
Up
2 votes

Submitted · Last Updated

Comments

  • user5017886
    user5017886 Rank 1 - Community Starter

    Hi BI/Analytics Team

    could you please review the requirement and provide solution approach.

     

    Regards

    Mahesh

     

  • user5017886
    user5017886 Rank 1 - Community Starter

    Hello Team
    do you have any update?

    Maheshhs

  • mgoswami
    mgoswami Rank 4 - Community Specialist

    Hi Mahesh,

    Is it OTBI analyses or OBIEE/OAS/OAC analyses? Did you check the BI Publisher? I will check it and come back to you if I find anything. I am not sure about generating zip file but I think there is something for UCM.

  • User_405PI
    User_405PI Rank 1 - Community Starter

    Hi Mahesh,

    I have worked on the above requirement with a slight modification to it. I am zipping a text file. You can modify the below bursting query as per your requirement.

    Also, note that when you schedule the report in BIP, do not forget to choose the option Compress output prior to Delivery. This REQ is not possible to achieve if we schedule the report via ESS Job.

    SELECT 1 AS "KEY",
         'XLA_TRANSACTION_ENTITIES TEMPLATE'  TEMPLATE,
         'ETEXT'  TEMPLATE_FORMAT,
    'en-US' LOCALE,
         'text'  OUTPUT_FORMAT,
    'WCC'  DEL_CHANNEL,
         'SERVER_NAME' PARAMETER1,
         'FAFusionImportExport' PARAMETER2,
         'XLA_TRANSACTION_ENTITIES_Extract'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')||'.zip' PARAMETER5,
         'XLA_TRANSACTION_ENTITIES_Extract'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')||'.zip' PARAMETER6,
    'true' parameter9
    FROM 
    dual

     

    customer_connect_schedule_report.PNG

  • Sandeep Pati-Trinamix
    Sandeep Pati-Trinamix Rank 1 - Community Starter

    Hi Team, Through ESS we are triggering the BIP. there is No provision for the zip Output, Only csv option available. as this is an old discussion, do we have a provision as of 24C now ?

  • Jayant Ajayrao Deshmukh
    Jayant Ajayrao Deshmukh Rank 3 - Community Apprentice

    To achieve the requirement of generating a ZIP file containing both CSV and XML output from a BI report and uploading it to the UCM (Universal Content Management) server in Oracle Fusion, you can implement a workaround using Oracle BI Publisher’s scheduling and file generation capabilities along with PL/SQL or Java to manage the ZIP creation and upload.

    1. Generate Reports in CSV and XML Formats:
      • Schedule the BI Publisher report to generate outputs in both CSV and XML formats.
      • Configure the outputs to be saved to a specified location or sent as email attachments to a common accessible location.