I was intrigued about this and I found a blog that might help: (es una verision diferente pero a mi me ayudo ver como se hace en esa version) http://obieetraining11.blogspot.com/2012/08/obiee-11g-creating-column-selector-and.html

Figure a work around... for now! I was able to pivot what I needed and reduced my row count 57%. Thanks for the help!

It’s an OBI infrastructure and network resource issue.

@Gianni Ceresa Let's say i do not have that limit. If I use the section SQL Issued on the advance tab, can i pivot data using sql? I tried different variations of the following with no luck: SELECT * FROM ( SELECT "Time"."yyyymm", "HR Profile"."Country", "HR Profile"."Alias", "HR Profile"."Name", " HR Profile"."Position",…

I mean they can be changed but they will not be changed... same with 10,00 row agent limits and...

@Gianni Ceresa @Charles M thank you for your responses. I talked to the support team before posting and those limits can not by changed. I'll keep looking (SQL) and let you know if I find a work around.

Oracle Business Intelligence 12.2.1.4.0 Error View Display Error Exceeded configured maximum number of allowed output prompts, sections, rows, or columns. Error Details