Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion ERP Analytics

Categories

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

Generate multiple Excel sheets based on parameter value

Received Response
19
Views
2
Comments
Sonia Choudhary
Sonia Choudhary Rank 0 - Community Observer
in Oracle Fusion ERP Analytics

Hi All,

We are using Oracle Fusion Cloud Application 25C and Oracle BI Publisher Desktop for developing data template reports. Our requirement is to generate Excel output where the number of sheets depends on parameter value dynamically.

If parameter X is A, all three sheets (A, B, C) are generated in Excel, if parameter X is B, only sheet B is generated, if parameter X is C only sheet C is generated. How can I create this in rtf template or Excel? I tried using rtf and splitting on multiple pages, but each page has different columns.

Could you please recommend the steps to achieve sheets dynamically.

Tagged:

Answers

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Mod

    Hi @Sonia Choudhary ,

    Thank you for visiting and posting in Fusion Data Intelligence(FDI) Product Community Page.

    This forum is for FDI product and looks like your question is for Fusion Applications.

    Please note that this Question is for Fusion Apps and it is managed in our sister community, which can be found at the below links:

    Oracle Cloud Customer Connect :

    Welcome to Cloud Customer Connect
    https://community.oracle.com/customerconnect
    Oracle’s premier online cloud community
    Please make a note of the above URL and visit those Fusion Apps forums to submit ideas, receive support from our FA Cloud experts and check out the resources they have available for you.

    Thanks
    Subha

  • RVohra
    RVohra Rank 6 - Analytics Lead

    I donot think it is possible with RTF Template, might be with Excel but you need to ready to try few things: High level steps could be create 3 sheets - let's say SheetA, SheetB, SheetC

    1. On each sheet, define the layout you want (headers, columns, etc.)
      1. These can be totally different across sheets.
    2. Replace 'PARAM_X' with the actual parameter name you defined in the data model.
      • <?if:xdoxslt:getXDOProperty('PARAM_X')='A' or xdoxslt:getXDOProperty('PARAM_X')='ALL'?>... Sheet content ...<?end if?>
      • <?if:xdoxslt:getXDOProperty('PARAM_X')='B' or xdoxslt:getXDOProperty('PARAM_X')='ALL'?>... Sheet content ...<?end if?>
    3. Save the template as .xlsx
    • Define parameter X with values:
      • A
      • B
      • C
      • (optional) ALL
    • Include logic in your SQL to return data for each sheet section if necessary, or return all data and filter in the template.

    Try this .xlsx template in BIPublisher and output type Excel