Unable to Add More Than 5 Columns in OTBI Pivot Table

Question

Hi everyone,

I’m creating a report in Oracle Fusion OTBI based on a data model, and I want the report to be displayed as a pivot table. However, when I try to select the columns for the pivot table, I can’t add more than 5 columns to the layout.

I’m wondering if this is a limitation of OTBI or if it’s related to the data model or system settings. Has anyone encountered a similar issue? If so, how can I resolve it?

Rajasekhar Bandaru-Oracle · Answer

Hi Burak

Please review the existing post for the similar issue.

https://community.oracle.com/customerconnect/discussion/843359/bi-publisher-pivot-table-limit-configuration-of-able-to-add-only-5-columns