1 2 Previous Next 18 Replies Latest reply on Feb 14, 2017 8:10 PM by Christian Berg

    BI Server Cache and Maximum Number of Rows Processed

    3310714

      Hi,

       

      I'm trying to understand the way OBIEE 12c processes data and have these questions. 

       

      1)  I have BI server cache ENABLED and my Maximum Number of Rows Processed is the default 65,000.  I have a table with 100,000 records.  If I create an Analysis to return all records from the table, the BI server retrieves 100,000 records from the DB, creates a cache entry file for the 100,000 records, but only renders the first 65000 records, right? 

       

      2)  I have BI server cache DISABLED and my Maximum Number of Rows Processed is the default 65,000.  I have a table with 100,000 records.  If I create an Analysis to return all records from the table, the BI server retrieves 100,000 records from the DB, the results sit in memory somewhere in BI server, but only renders the first 65000 records, right? 

       

      Is my understanding of how OBI processes data correct?  Please advise.

        1 2 Previous Next