Oracle Analytics and AI

User_35Y1B

 As per the oracle documentation , OAC has a default system-imposed limit of 300 visible columns per view in a pivot table , please increase the limit to 500+ per view

We have migrated the reports from On prem OAS to OAC , the reports are getting failed with error
View Display Error for exceeded configured number of allowed output columns.

We have decommissioned the OAS Servers as we migrated to OAC , so now couple of the reports are failing in production due to this issue. So customer needs to use this report for there asset and location attribution features to track down through couple of reports and the attribute columns count is almost 500-550 , due to restriction in OAC to 300 columns count these reports are failing and they need to be fixed.

Please help us to resolve it ASAP as client is not able to ue the rports for some time now.

Branden Pavol

Wow. 300+ columns in one report is a lot. Are you sure an OAC report is the correct solution? I find it hard to believe they are able to do analytics on that. I tell all my analysts that if they need to scroll left and right, then we have failed at delivering a good visualization to our users. It sounds like they just want to treat this report as a database. You might consider just giving them access to a database table or creating a table in APEX. I have a strong feeling that all they are doing is exporting it to Excel to build other reports on top of it. I would say OAC is not fit for this solution, in my opinion.