7 Replies Latest reply: Feb 25, 2011 1:13 PM by User294199 RSS

    What Is Presentation Services Cache In Fact?

    AnTonic
      I have searched on this forum and on BI blogs but don't understand the concept of a presentation services cache clearly.

      At first let tell what I need.

      I have a dashboard page with prompts and report. From this report I navigate to another dashboard page with reports and several promts that have to be initialized with values from previous dashboard page. The navigation is based on PortalPageNav() function.

      I created table in DB, PL/SQL function , through EVALUATE I passed parameters to PL/SQL function and wrote its into DB table.
      Then I added this table in RPD and on Presentation Layer.
      In Answers I get correct results.
      Then I initialize the default values of prompts on a second dashboard page through 'SQL Results' and type something like this:
      SELECT "Parameters"."Value" FROM "BO" WHERE "Parameters"."Name"='Param1'

      1. I login and go to first dashboard page, change prompts, run report then navigate to second dashboard (it opens in new window). All prompts initialize correctly.
      2. I open window with first dashboard page change prompts, run report then navigate to second dashboard again. And I see the previous values in prompts. But in a DB table I see new values.

      There 2 ways for deciding this problem
      1. By clearing cursor cache:
      answers - administration- manage session - close all cursors
      or
      answers - administration- manage session - choose appropriate cursor and close it

      2. By reloading second dashboard page

      All ways are not convenient or user friendly.

      BUT I NEED IN AUTOMATIC CLEARING OR NOT CACHING SOME PROMPTS!
      I cant't write in a user's guide - for correct work you have to login as Administrator and clear cursor cache every time after changing prompts on first dashboard page or reloading second dashboard page :)

      I became research this issue.
      1. BI Server Cache is turned off through NQSConfig.ini
      2. I began read a lot of info about Presentation Services Cache:
      1) John Minkjan blog - [http://obiee101.blogspot.com/2008/11/obiee-presentation-services-cache.html]
      I need no turn Presentation Services Cache or disable it.
      2) [http://businessdecisionsystems.com/blog/?p=122] this article give us info about storing log records but there is no info about clearing cursors.
      3) [http://hekatonkheires.blogspot.com/2010/02/obiee-10g-presentation-server-cache.html] good article about physical storing of presentation services cache but I didn't find any info on clearing some cursors
      4) Nico in a blog write [http://gerardnico.com/wiki/dat/obiee/html_cache#clear_the_presentation_server_cache_without_stopping_and_restarting_the_services] that Presentation Services Cache is a HTML cache but he don't say how clean the entries without clicking on 'Close All Cursors' button.
      5) In this topic presentation cache refresh in prompt the same problem and no answer :(
      6) The user10203008 in a topic To pass new session variable value to stored proc before running a report. has the same issue but all advices about BI Server Cache. He found solution but it is disable whole Presentation Services Cache. I need clear ONLY SOME CURSORS.

      So, I have a answer!
      DOES ANYBODY KNOW WHERE IS STORING DATA ABOUT CURSORS ON A PAGE ANSWERS - ADMINISTRATION - MANAGE SESSION ?

      May be somebody knows a developer of Siebel Analytics or may be he is on a forum and tell us how realized a clearing some cursors in a automatic mode?

      Edited by: AnTonic on Jan 28, 2011 7:17 PM

      Edited by: AnTonic on Jan 28, 2011 7:18 PM

      Edited by: AnTonic on Jan 28, 2011 7:20 PM
        • 1. Re: What Is Presentation Services Cache In Fact?
          AnTonic
          May anybody show the way for realizing this feature (clearing some cursor in a automatic mode)?
          • 2. Re: What Is Presentation Services Cache In Fact?
            Nathan John Morgan
            You have a check box to "Bypass Presentation Server Cache" on the Advanced tab of your request. Will that help?
            • 3. Re: What Is Presentation Services Cache In Fact?
              AnTonic
              No. This checkbox only works for Answers not for Prompts. There is no 'Advanced' tab on a prompt creating page.
              • 4. Re: What Is Presentation Services Cache In Fact?
                AnTonic
                I found a solution.
                I decide to emulate a pressing button 'Refresh' at the end of a page. So I look at a html code of Dashboard page and found a corresponding javascript function. It is
                RefreshPage('saw.dll?Dashboard&PortalPath=<PortalPath>&Page=<PagePath>')
                So I trying to create a text box with HTML Markup option and enter RefreshPage on onload() function. But then I got a cycle: open dashboard page -> onload() -> RefreshPage() -> onload() -> RefreshPage() -> ...
                So I decide to find a code of this function. The function code is in %SAROOTDIR%\web\app\res\b_mozilla\dashboards\portalscript.js
                //-------------------
                // force cache refresh
                function RefreshPage(sCmd)
                {
                   var viewStateDiv = document.getElementById("idViewStateDiv");
                   if (viewStateDiv)
                   {
                      sCmd += "&Action=RefreshAll";
                      sCmd += "&ViewState=" + viewStateDiv.getAttribute("stateID");
                      sCmd += "&StateAction=samePageState";
                   }
                   window.location.replace(sCmd);
                   return false;
                }
                We may see that for refreshing page the Action='RefreshAll' is used. So we need pass this Action.
                I wrote in a first post that I was using PortalPageNav() javascript function for navigation. So I created my custom CustomPortalPageNav() function which is based on original PortalPageNav() code with one new parameter 'sAction'. So I pass a value 'RefreshAll' through this parameter and it works!
                • 5. Re: What Is Presentation Services Cache In Fact?
                  User294199
                  Hi AnTonic,
                  i've your same issue.
                  I've inserted function RefreshPage() in a narrative (prefix) but it isn't executed.
                  Can you explain step by step where insert the function?
                  Otherwise can you explain me how disable Presentation Service Cache?. In my case it's not a problem.

                  Thanks

                  Giancarlo
                  • 6. Re: What Is Presentation Services Cache In Fact?
                    AnTonic
                    832596 wrote:
                    Otherwise can you explain me how disable Presentation Service Cache?. In my case it's not a problem.
                    Giancarlo
                    Add these rows to instanceconfig.xml file
                    <CacheMaxExpireMinutes>-1</CacheMaxExpireMinutes>
                    <CacheMinExpireMinutes>-1</CacheMinExpireMinutes>
                    <CacheMinUserExpireMinutes>-1</CacheMinUserExpireMinutes>
                    • 7. Re: What Is Presentation Services Cache In Fact?
                      User294199
                      Hi AnTonic,
                      thanks for your reply. Before to apply changes you have suggested me, i would ask you if they can resolve my issue explained in post Re: Prompt stores old value in presentation variable If i've understood your post, it seems you had my same problem, however i'd like a confirm.

                      P.S. I've made changes, but it doesn't work. Can you suggest however any solution?

                      Thanks

                      Giancarlo

                      Edited by: 832596 on 25-feb-2011 5.13