Error: "The logical query disqualifies the plan cache plan exceeds maximum size" In Log When Attempting to Run an Analysis In OBIEE Resulting In Slow Analysis Loading (Doc ID 2423003.1)

Note: If a dashboard analysis is not reading a cache hit as you would expect it, you can diagnose the cache hit behavior of the analysis by executing the following steps:

1. Configure the Analysis cache logging:
   1. Login to OBIEE with an authoring role
   2. Browse in the catalog the location of your analysis
   3. Edit the Analysis
   4. Click the Advanced link
   5. Within the prefix field of the Advanced SQL Clauses section, add the following: Set Variable ENABLE_CACHE_DIAGNOSTICS=4,LOGLEVEL=5;
   6. Click Apply SQL
   7. Save the analysis
2. Test the analysis
   1. Login to OBIEE as the user who will load the analysis
   2. Load the dashboard with the analysis
   3. Review the OBIS Query log for detail ($OBIEE_Domain/servers/obis1/logs/obis1-query.log) Note, Cloud Customers will require this log to be provided by the operations team through a service request.
   4. Alternatively, you can test realtime while an OBIEE administrator is logged in, and the query log can be viewed by the administrator real-time:
   5. After you've loaded the dashboard analysis, have the administrator browse to Administration > Manage Sessions
   6. Click the View Log link for your analysis

For additional information on BI Server Cache settings with Primavera Analytics please refer to the following KM document - Oracle Business Intelligence Enterprise Edition (OBIEE) BI Server Cache And Presentation Server Cache Default Settings With Primavera Analytics (Doc ID 2349232.1)