RSS

How to bypass Presentation Server Cache in OBIEE 11G

17 Jul

During our development if we wanted to check the report level UI changes, sometimes we will not see the changes immidiately. This is due to Presentation Server Cache. Eventhough we disable the BI Server cache, It doesnt make any effect on presentation Server objects.

So in that situations we need to disable Presentation server cache permanently across OBI Application, To do this add the following parameters in instaceconfig.xml. (Make sure that you have taken a backup copy of instanceconfig.xml)

<ServerInstance>
———

<Cursors>
<ForceRefresh>true</ForceRefresh>
</Cursors>

——–

</ServerInstance>

Now restart the OBI Presentation server service and test the results.

Note: Keep in mind that this parameters cause Presentation Server to always bypass its cache. To be used only for testing – may have serious performance implications.

Keep smiling 🙂

Thanks,
Shiva

Advertisements
 
4 Comments

Posted by on July 17, 2012 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , , , , , , , , , , , , , ,

4 responses to “How to bypass Presentation Server Cache in OBIEE 11G

  1. Riccardo

    October 18, 2012 at 4:18 pm

    Hi Shiva, in obi 11.1.1.6.4 I need for a prompt with default value set by an SQL query. Suppose that the query is a time string (YYYYMMDDHH24MISS’). I noticed that even if the runtime value of sql query change, the default is still the same.
    For now I put in the SQL query WHERE ‘@{system.currentTime}’ = ‘@{system.currentTime}’

    I tried also with your solution , but no succcess. Pls refer to https://forums.oracle.com/forums/thread.jspa?messageID=10644125

     
  2. Narendra

    June 12, 2013 at 9:48 am

    Hi Shiva,

    Thanks for the post.

    I need to remove the Presentation server cache for one of the Database in my repository, not for entire application. Is there any way to delete/bypass cache for the DB instead for entire Presentation server cache.

     
  3. Ayyappan

    June 27, 2013 at 12:56 am

    Above blog suggestion is not working for us 11.1.1.6.9. Any suggestion ?

     
  4. chandrababu chennupati

    October 18, 2016 at 7:57 am

    how to disable cache in report level?
    give any suggestions

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: