Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

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

Add Expand - Collapse option in Excel Templates

Received Response
23
Views
1
Comments
Zohrah Meetoo
Zohrah Meetoo Rank 1 - Community Starter
edited Jan 16, 2026 7:00AM in Oracle Fusion AI Data Platform Forum

Hello,

We currently have a requirement to add an expand/collapse feature within a report's output. We plan to use an Excel Template to design the report's layout.

I would like to know if it is possible to create expandable/collapsible groups in the report output using the native Excel grouping feature found under Data tab -> Outline -> Group.

If this is possible, could you please provide details on how to ensure this functionality is preserved when the report is generated?

Thank you for your assistance.

Regards,
Zohrah

Tagged:

Answers

  • RVohra
    RVohra Mod

    There is no simple answer for this functionality because Oracle BI Publisher (BIP) Excel Templates do support Excel’s native Expand/Collapse (Outline Grouping) and the functionality can be preserved in the generated report IF the grouping is done correctly in the .xlsx template before uploading it to BIP.

    Oracle BI Publisher preserves Excel grouping as long as:

    1. You manually create the grouping in Excel before uploading the template into BIP.
    2. The grouped rows in Excel correspond to fixed rows in the template.

    I would say refer Creating Excel Templates for current capabilities. Hope it helps!