Translate

Friday, 2 December 2011

OBIEE Cursor Cache clear from Dashboard Java Script

OBIEE Cursor cache is normally cleared from the Administration - Manage Sessions Screen...

Here is a way that a piece of java can be embedded into a dashboard and call an xframe so you cant see it being called and clear the OBIEE Cursor cache - Presentation cache in effect.

1. Just insert a text box into Dashboard - Tick the "Contains HTML Markup"
2. Paste the script below into the text box

<script language="javascript">
document.write(
 "<iframe width=0px height=0px src=" +
  document.location.href.match(/^[^?]+/) +
"?ManageSessions" +
document.location.href.match(/&_scid=[^&]+/) +
"&Action=CloseAllCursors&Done=saw.dll%3fSessions',{ensureFreshUrl:true});return false;')></iframe>"
);
</script>


Voila - when ever you click on the dashboard or refresh it the cursor cache will get cleared.

No comments:

Post a Comment

Google Big Query Clone / Copy DataSets / Tables - PROD --> TEST --> DEV Projects

Google Big Query Cloning of Datasets & Tables across GCS Projects. We searched the internet and could not find a simple cloning / ...