If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Auto refresh every min

Started by M, 17 Jun 2016 09:58:13 AM

Previous topic - Next topic

M

Good day,

I am creating a report to auto refresh every minute. I got the Auto-refresh script from ibm site and report refresh every minute.but, the data in the report doesn't get updated even though the table is updated .

My report has Query 1 , query 2 and Query 3 ( query 1 -> left join Query 2).

I enabled caching option "NO" in query 1 and Query 2. When i enable caching option "No" in the Query 3 the report took lot of time to refresh (even minutes).

Do i missing any other setting?

Script to update :

// Licensed Material - Property of IBM
// © Copyright IBM Corp. 2003, 2009
<script type="text/javascript">
var intval;
var fW = (typeof getFormWarpRequest == "function" ? getFormWarpRequest() : document.forms["formWarpRequest"]);
if ( !fW || fW == undefined) 
{

      fW = ( formWarpRequest_THIS_ ? formWarpRequest_THIS_ : formWarpRequest_NS_ );

}
var preFix = "";
if (fW.elements["cv.id"])
{

      preFix = fW.elements["cv.id"].value;

}   
var nameSpace = "oCV" + preFix;
if(intval!="")
{

      self.clearInterval(intval);
      intval="";

}
self["RunReportInterval"] = self.setInterval( nameSpace + ".getRV().RunReport()",60000 );
intval = self["RunReportInterval"];
</script>


Many thanks Guys
M