Oracle Analytics Publisher Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Publisher Idea Lab

Categories

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

ADD MORE THAN 20 COLUMN IN ROWS SECTION OF PIVOT TABLE FOR BI PUBLISHER

Archived
4
Views
1
Comments
Noriko Ishizuka
Noriko Ishizuka Rank 1 - Community Starter
edited May 9, 2025 5:44PM in Oracle Analytics Publisher Idea Lab

Description

Now we can add less than 5 column in rows section of pivot table for BI Publisher.
So we can't prepare for reports meeting client's request.
 

Use Case and Business Need

We need more than 20 column in rows section of pivot table for BI publisher.

Thanks 

Original Idea Number: 891f0ebc65

1
1 votes

Archived · Last Updated

Archiving due to available workaround and feasibility.

Comments

  • Sandeep S. Chauhan-Oracle
    Sandeep S. Chauhan-Oracle Mod

    Pivot tables in Publisher are limited to 5 row columns in interactive layouts(XPT) due to page width and readability constraints in interactive output. Expanding beyond this affects usability and layout rendering.

    For interactive exploration, use OBIEE/OAC analysis pivot views instead.

    For larger printable crosstabs, use an RTF template with cross-tab design, which allows more row columns and supports horizontal page splits (PDF/HTML output)
    https://docs.oracle.com/en/middleware/bi/analytics-server/design-publish/use-advanced-report-layouts.html