Cache Management (Disable Cache in Perticular Report and Whole Environment)

Cache Management (OBIEE 10g and OBIEE 11g)

Cache management is used to improve query performance of reporting in OBIEE environment. But due to some reasons sometime we require to disable cache in OBIEE environment.

Below is the process how to disable/enable cache in OBIEE 10g and OBIEE 11g.

Cache management in OBIEE 10g:

There are 3 ways that we can implement to disable cache:

1. Disable cache for whole environment.

2. Disable Query Cache for one session

3. Disable query cache for single report/answer.

Disable cache for whole environment

To disable the query cache for the entire application, you must set to the ENABLE cache parameter the value NO in the file NQSConfig.INI

Disable Query Cache for one session:

To disable query cache for one session, you have to set the below mentioned session system variables with the value 1:

• DISABLE_CACHE_HIT

• DISABLE_CACHE_SEED

Disable Query Cache for for one Request/Answer:

 To disable query cache for one Request/Answers, you have to set the below mentioned request variables with the value 1:

• DISABLE_CACHE_HIT

• DISABLE_CACHE_SEEDE

If you want to disable query cache for a particular request, then do thefollowing things.

1. First add the required number of columns in criteria tab of Answer.

2. Then click on Advanced table.

3. Find the Prefix Box and write the following statements.

SET VARIABLE DISABLE_CACHE_SEED=1,DISABLE_CACHE_HIT=1;

When the value of the request variable DISABLE_CACHE_SEED is 1 for any request, then the OBI Server does not store the result of that request in Query Cache.

When the value of the request variable DISABLE_CACHE_HIT is 1 for any request, then the OBI Server does not look into Query Cache. So, even theQuery Cache contains result of the similar request, BI Server will not look into it,and it will get the result from back end Database.

OBIEE 11G Disable Caching

1. Open a browser and enter the following URL to navigate to Enterprise Manager Fusion Middleware Control: http://localhost:7001/em 

2. Log in as an administrative user. Typically you use the administrative username and password provided during the Oracle BI installation. In this example the user name is Weblogic.

3. In the left navigation pane, expand Business Intelligence and click coreapplication.

4. Click the Capacity Management tab.

5. Click the Performance sub tab.

6. Locate the Enable BI Server Cache section. Cache is enabled by default.

 

7. Click Lock and Edit Configuration.

8. Click Close when you receive the confirmation message "Lock and Edit Configuration - Completed Successfully.

 9. Deselect Cache enabled. Caching is typically not used during development. Disabling cache improves query performance.

 10. Click Apply

11. Click Activate Changes.

12. Click Close when you receive the confirmation message Activate Changes - Completed Successfully.

13. Restart the server to apply changes.