Oracle Transactional Business Intelligence

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

CSV Extract for Custom Report

Received Response
21
Views
1
Comments
Rank 1 - Community Starter

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

  • Rank 7 - Analytics Coach
    edited Sep 1, 2023 8:12AM

    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

Welcome!

It looks like you're new here. Sign in or register to get started.