• What is dbt_artifacts?

    dbt_artifacts is a package for modeling a dbt project and its run metadata. It includes the following models to help you understand the current state of a dbt project and its performance over time. It...

  • Data migration from the Salesforce to snowflake Data warehouse by using Matillion

    Purpose of the Article: This blog explains how to load the data from Salesforce to Snowflake Intended Audience: This article will help our Organizational level kind of developers working on data migra...

  • WiMAX-A Study of Mobility

    1. Introduction The wireless market is growing rapidly; being pushed through wireless connectivity demand various wireless connectivity means are emerging (WLAN/802.11, WMAN/802.16a, WWAN/802.16d) [IE...

  • Weblogic Upgrade

    Patch Name wls1036_upgrade_generic.jar Reference https://www.youtube.com/watch?v=Be6hrYTANQE Just Click Next and Next MAKE SURE ALL OBIEE SERVICES ARE DOWN AND CLOSED IN PROCESS Open CMD prompt C:Mid...

Tags

bics installation OBIEE obiee 11g installation guide Oracle

Categories

Popup window in OBIEE 

Popup window in OBIEE 

We can open any sites or drill down report from our dashboard page by clicking on data value of report. Here is the original JavaScript for it…

<script language=”javascript” type=”text/javascript”>

<!–

function popitup(url) {

newwindow=window.open(url,’name’,’height=200,width=150′);

if (window.focus) {newwindow.focus()}

return false;

}

// –>

</script>

Then, you link to it by:

<a href=”popupex.html” onclick=”return popitup(‘popupex.html’)”        >Link to popup</a>

Ø  Now let’s implement it in our OBIEE…

  • Calling any site (URL) from web by clicking on data value of report using JavaScript.
  1. Create report of your choice.
  1. Now click on Column Properties>Data format.
  1. Check “Override Default Data Format “and select “Custom Text Format”.
  1. Put following formula in “Custom Text Format” and click onOK:

@[html] “<a href=”javascript:popitup(‘http://ids-sol.co.uk’)”>”@”</a>”<html>

 

Note: You can put any link in popitup () function shown above. For e.g. if you want to call L2 (drill down) report in new popup window then you will have to put following formula in Custom Text Format.

@[html] “<a href=”javascript:popitup(‘http://IP address of server/analytics/saw.dll?PortalGo&Action=prompt&path=report name if has space then separated using %2F for e.g. %2Freport%2Fname‘)”>”@”</a>”

  1. Now go on “Results”tab and select “Static Text” view.
  1. Put following JavaScript in “Static Text”view.

<html><script language=”javascript” type=”text/javascript”>

<!–

function popitup(url) {

newwindow=window.open(url,’name’,’height=800,width=800′);

if (window.focus) {newwindow.focus()}

}

// –>

</script>

<a href=”popupex.html” onclick=”return popitup(‘popupex.html’)”></a>

</html>

  1. It will look like :
  1. Now remove the “Static Text”view from “Compound Layout” or you can also keep it in it.
No Comments
Post a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.