Using the Java code below OBIEE BI Server cache can be cleared from Dashboard
1.Insert a Text box into a dashboard "Contains HTML" must be ticked
2. Paste below code into Text Box
<script language="javascript">
document.write(
"<iframe width=Opx height=Opx src=" +
document.location.href.match(/^[^?]+/) +
"?IssueRawSQL" +
document.location.href.match(/&_scid=[^&]+/) +
"&SQL=CALL+SAPurgeAllCache();)></iframe>"
);
</script>
1.Insert a Text box into a dashboard "Contains HTML" must be ticked
2. Paste below code into Text Box
<script language="javascript">
document.write(
"<iframe width=Opx height=Opx src=" +
document.location.href.match(/^[^?]+/) +
"?IssueRawSQL" +
document.location.href.match(/&_scid=[^&]+/) +
"&SQL=CALL+SAPurgeAllCache();)></iframe>"
);
</script>
Note: only a member of this blog may post a comment.