Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Publisher Forum

Categories

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

Extracting excel output in multiple tabs

Received Response
121
Views
2
Comments
Sunil Pradhan
Sunil Pradhan Rank 1 - Community Starter
in Oracle Analytics Publisher Forum

Hi All - Has anybody worked on below requirement and is it feasible in Oracle ERP fusion?

We have a RTF template, and excel output. Is it possible to split the output by number of records (say 30K) as separate sheets in excel output.

Answers

  • Kathy-Oracle
    Kathy-Oracle Rank 3 - Community Apprentice

    Please see the following doc for details to see if this gives you the option to split the output by number of records as separate sheets in excel output.

    Oracle Fusion BI Publisher: Need To Split Data Based On Row Count (Doc ID 2099308.1)

  • Sunil Pradhan
    Sunil Pradhan Rank 1 - Community Starter

    Thank you Kathy !

    This works as per my requirement (output). It has .xls template and controlled by xsl.

    Is there a way (report properties/bursting settings etc.) this can be achieved through an RTF template and .xlsx output ?