Oracle Transactional Business Intelligence

Products Banner

CSV Extract for Custom Report

Received Response
23
Views
1
Comments

Hi,

I am looking to do a full csv extract from a custom report from within OTBI.

I know this is possible with built in reports using scheduled jobs and generating a data file.

Any advice is appreciated.


Oracle Fusion Cloud Applications

23B (11.13.23.04.0)

Tagged:

Answers

  • Nathan CCC
    Nathan CCC ✭✭✭✭✭
    edited September 2023

    Hi,

    Actually no it is only possible to view as CSV, in your custom report or one of the pre-defined reports, if the designer of the report selected output format data "CSV" on your selected layout for that run. You can view the output as CSV whether or not you run the report yourself like from a dashboard page or from the catalog or whether you run it as a scheduled report job in OTBI or as an enterprise scheduled process job - it makes no difference how you consume it.

    In the report editor you need to select "View a List" then select the layout row

    then select one or more "Output Formats". Scroll to the bottom for the 2 Data ones XML and CSV.

    For more information read the manual

    Oracle® Fusion Middleware

    Report Designer's Guide for Oracle Business Intelligence Publisher

    12c (12.2.1.3.0)

    E80602-02 September 2017

    https://docs.oracle.com/middleware/12213/bip/BIPRD/toc.htm