2 Replies Latest reply on Jan 25, 2016 11:52 AM by cesar.advincula.o

    Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.?

    SanthoshSreshta

      Hi All,

       

      I am trying to display more than 10,000,000. it is been showing error as Exceeded configured maximum number of allowed output prompts, sections, rows, or columns. , the columns were only just 5 and 2 prompts.

      The links I have found were.

      https://shivabizint.wordpress.com/2013/10/08/obiee-11g-configurations-maximum-limits/

      I have goggled about this error and finally came to know that OBIEE can only able to display 9,999,999 records but there it is not mentioned as for 11.1.1.9 version, so I need some info regarding the maximum number of rows obiee can be able to display in PIVOT & TABLE. Need some official information regarding this.

      and anyone help me in displaying such amount of data in reports.

       

      In official oracle website I was able to find only default values but not max values .

      http://docs.oracle.com/cd/E25178_01/bi.1111/e10541/answersconfigset.htm

      I am using 11.1.1.9 version.

       

      Please help.

      Thanks,

      Santhosh S.