Be careful when you are setting the Cache attribute values. For implementations under significant stress increase this value to 1000 or a higher value as mentioned below. The main factor that affects its size is the memory consumption.
Maximum range of Global Cache storage size (in Megabytes) to use when BI Server cache is enabled – 9,999
Maximum number of cache entries; used to tune cache performance – 99,999
Maximum size (in Megabytes) for individual server cache entries – 9,999
Data Display/Download:
The Maximum no.of rows that we can set to display/download in the Table/Pivot views. But keep in mind OBIEE is NOT meant to be a tool to extract huge amounts of information.
Maximum number of rows of data to include in Table views – 9,999,999
Maximum number of rows of data to include in delivered emails – 9,999,999
Maximum number of rows to export to excel – 9,999,999