RSS

To disable Presentation cache in OBIEE11g

23 Aug

To turn off the Presentation Services Catalog Attribute Cache in OBIEE 11g. We need to set the following tags in the instanceconfig.xml file:

<ps:Cache xmlns:ps=”oracle.bi.presentation.services/config/v1.1″>
<ps:CatalogAttributes>
<ps:Enabled>false</ps:Enabled>
</ps:CatalogAttributes>
</ps:Cache>

 

 

 

Thanks,

Shiva

 
5 Comments

Posted by on August 23, 2010 in OBI EE, OBIEE 11g

 

5 responses to “To disable Presentation cache in OBIEE11g”

  1. ShivJoshi Santosh

    August 23, 2010 at 9:37 pm

    Hi Shiv,
    Thanks for your posts. I actually had a design question for you. One of my reports (with 20 cols) consists of multiple rows with repeated customer names (about 100 distinct customer names and approx total 5000 rows). We wanted to automatically filter out the report on customer names and send the filtered reports to the respective customers. So these 100 customers will receive their own 50 rows. We were wondering how we should go about doing this. We thought of maybe using a) iBots or b) GO URL with dummy dashboard. I was wondering if you have had experience tackling this issue and iterate some high level design steps that will be required.
    Thanks!
    ShivJoshi
    ~Shiv

    Reply
     

    • Shiva Molabanti

      August 24, 2010 at 4:12 pm

      Hey shiv,
      This functionality can be achieved by BI Publisher Bursting concept.

      Thanks,
      Shiva

      Reply
       

  2. Ruby

    January 15, 2011 at 7:57 pm

    HI Shiva,

    I have read your blogs and I have a quick question. As I have impplemented SSO and I am letting the users into BI via company portal , I don’t want the users to have the “Sign out” button as it redirects you back to login page of BI. Is there a way to disable this or redirecting the ” Sign out” back to the portal page.

    Thanks
    Ruby

    Reply
     

  3. Adil H

    February 11, 2011 at 1:31 pm

    Hi Shiva,
    Thanks for this very interesting post.
    I am not able to find this config tag anywhere in the official documentation, where did you get it ? 🙂 I can only find the following:

    100
    60
    10
    10

    Unfortunately twe cannot set the values to -1 like in obiee10g, the Presentation server cannot restart anymore.
    Were you able to test this new config tag.

    Best regards
    Adil

    Reply
     

  4. Adil H

    February 11, 2011 at 1:33 pm

    Sorry this was not displyed by the browser
    Cache
    Query
    MaxEntries 100 /MaxEntrie
    MaxExpireMinutes 60 MaxExpireMinutes
    MinExpireMinutes 10 MinExpireMinutes
    MinUserExpireMinutes 10 /MinUserExpireMinutes
    /Query
    /Cache

    Reply
     

Leave a comment