Monday 7 May 2012

Popup window in OBIEE


Popup window in OBIEE 

Hi…
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.







2.      
Now click on Column Properties>Data format.







3.      
Check “Override Default Data Format “and
select “Custom Text Format”.







4.      
Put following formula in “Custom Text Format”
and click on OK:











@[html]
"<a
href="javascript:popitup('http://shahin-obiee.blogspot.in/2012/01/uploadingcalling-pdf-file-into-obiee.html')">"@"</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>"







5.      
Now go on “Results” tab and select “Static
Text” view.



























6.      
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>







7.      
It
will look like :































8.      
Now
remove the “Static Text” view from “Compound Layout” or
you can also keep it in it.







9.      
Save
the report on dashboard and test it. It will work as :



















Take Care.......:) 
























 
























Posted by



at







































39 comments:








  1. Anonymous10 December 2012 at 06:21
    Thank you very much for your good information. 
    As I noted in the ... given information is very usefull to every student who ever want to learn about 
      best obiee Online Training     .
    ReplyDelete
  2. Unknown16 April 2013 at 06:33
    Hi -  I have used above method successfully but the problem is when I export the report to Excel, the column with Custom Javascript contain few garbage characters.
    eg. if expected value in cell is 5YOLF then its comes as "@""';">5YOLF. This isa the case with all the column on which custom javscript is applied. 
    Could you please explain the reason and any possible soultion.

    Thanks !!!
    ReplyDelete
  3. Unknown30 April 2013 at 02:39
    Appreciation for nice Updates, I found something new and folks can get useful info about BEST ONLINE TRAINING 
    ReplyDelete
    Replies
    1. Smith3 April 2017 at 23:12
      This comment has been removed by the author.
      Delete
  4. Shilpa10 October 2014 at 13:06
    Hi,

    Can you tell me what does the popupex.html do ? is it required in the static view?

    Thanks,
    Ramya
    ReplyDelete
  5. Unknown15 February 2015 at 10:32
    Hi,

    How can you pass parameters through it?
    ReplyDelete
    Replies
    1. Unknown28 March 2018 at 11:29
      Have you found how to pass parameters ? It doesn't seem to possible passing parameter though. I can successfully pass static values but can't pass dynamic values.

      For instance
      'saw.dll?PortalGo&Action=Navigate&col1=%22Meetings%22.%22Id%22&val1=%2233401762-2c3e-11e8-a869-02b215474f0b%22&path=%2Fshared%2FSugarCRM-QMP%2FReports%2FMeeting_Notes')">" @4

      I have hardcoded the value of meeting id to 2233401762-2c3e-11e8-a869-02b215474f0b and it works but i am not able to pass the value of each row 
      i.e. @1

      Delete
  6. Unknown16 February 2016 at 04:37
    very nice article.Thanks for sharing the post...!
     Oracle Golden Gate Online Training

    ReplyDelete
  7. sheela22 January 2019 at 03:14
    Thanks for the good words! Really appreciated. Great post. I’ve been commenting a lot on a few blogs recently, but I hadn’t thought about my approach until you brought it up. 
    Devops Training in Bangalore
    Microsoft azure training in Bangalore
    Power bi training in Chennai 
    ReplyDelete
  8. priya3 February 2019 at 21:33
    It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Data Science training in chennai  
    Data Science training in OMR  
    Data Science training in chennai    
     Data Science Training in Chennai 
     Data Science training in Chennai 
    Data science training in bangalore 


    ReplyDelete
  9. Darshana M26 February 2019 at 02:30
    This comment has been removed by the author.
    ReplyDelete
  10. Jack Dorsey2 July 2019 at 03:01
    As QuickBooks Premier has various industry versions such as for example retail, manufacturing & wholesale, general contractor, general business, Non-profit & Professional Services, there was innumerous errors that will create your task quite troublesome. At QuickBooks Support Phone Number, you will find solution each and every issue that bothers your projects and creates hindrance in running your company smoothly. Our team is oftentimes willing to allow you to while using the best support services you could possibly ever experience.
    ReplyDelete
  11. Jamess2 July 2019 at 23:16
    You should arrive at us when it comes to a number of software issues. The satisfaction can be high class with us. It is possible to call us in several ways. You can journey to our website QuickBook Support It is time to get the best help.
    ReplyDelete
  12. kevin324 July 2019 at 00:45
    Adjust the info and time then Click on ”OK”  QuickBooks Support phone number helps to make the process a lot more convenient and straight forward by solving your any QuickBooks Support Phone Number issues and error in mere a person call.
    ReplyDelete
  13. rdsraftaar4 July 2019 at 03:09
    The payroll service functions inside the QuickBooks program, and that means you would not want to enter the data twice. Moreover, you can always avail expert assistance by connecting yourself utilizing the QuickBooks Payroll Tech Support Team. They are always available for your assistance regarding anything when you look at the software.
    ReplyDelete
  14. rdsraftaar4 July 2019 at 03:37
    Let’s speak about our QuickBooks Enterprise Support Number USA that'll be quite exciting for you personally all. The advanced QuickBooks Desktop App for QuickBooks Support can now act as an ERP system good for medium scale businesses. QuickBooks Desktop Enterprise is not alike to pro, premier & online versions. Capacity and capability can be the reason behind this.
    ReplyDelete
  15. QuickBooks Payroll Support5 July 2019 at 22:48
    Get prominent options for QuickBooks towards you right away! With no doubts, QuickBooks has revolutionized the process of doing accounting that is the core strength for small in addition to large-sized businesses. QuickBooks Customer Technical Support Number is assisted by our customer support representatives who answer your call instantly and resolve all your valuable issues at that moment.
    ReplyDelete
  16. Mathew6 July 2019 at 00:54
    You may need not to worry all things considered as you are seeking help beneath the guidance of supremely talented and skilled support engineers that leave no stone unturned to land you of all of the errors which are part and parcel of QuickBooks Tech Support Number.
    ReplyDelete
  17. Mathew10 July 2019 at 03:09
    QuickBooks Support Phone Number, particularly, doesn't need any introduction for itself. But one who is unknown for this great accounting software, we would like you to give it a try.
    ReplyDelete
  18. jameswill1110 July 2019 at 05:18
    QuickBooks Support Phone Number accords assistance to the QuickBooks users’ worldwide. The support team can be reached through various modes such as for instance: phone support, email support, live chat, FAQ, QuickBooks community etc.
    ReplyDelete
  19. Jamess14 July 2019 at 23:20
    Just dial QuickBooks Tech Support Number and inform us the QuickBooks product name for which you need QuickBooks help by our experts. Our QuickBooks customer care team will guide you for every single product of QuickBooks whether QuickBooks Enterprise Support, Accountant, Pro, and Premier.
    ReplyDelete
  20. xpert14 July 2019 at 23:41
    The group deployed at the final outcome of QuickBooks Tech Support takes great proper care of all from the issues for the software. QuickBooks Support telephone number have a team of experts which can be pro in handling all of the issues because of this incredible software. You may need not to worry all things considered as you are seeking help underneath the guidance of supremely talented and skilled support engineers that leave no stone unturned to land you of all of the errors which are part and parcel of QuickBooks.
    ReplyDelete
  21. accountingwizards16 July 2019 at 03:11
    As QuickBooks Support Phone Number executives for QuickBooks, we assure our twenty-four hours a day availability at our technical contact number.
    ReplyDelete
  22. jameswill1117 July 2019 at 00:19
    The group deployed at the conclusion of QuickBooks Support telephone number takes great good care of most from the issues for the software. Support For QuickBooks have a group of experts that might be pro in handling a lot of the issues because of this incredible software.
    ReplyDelete
  23. QuickBooks Support Phone Number18 July 2019 at 00:01
    QuickBooks Support USA Number for Instant Fix Issues You may get all sort of QuickBooks Tech Support Number related assistance from our expert tech support team suppliers. We give exceptionally qualified tech specialists who have involvement in settling all types of QuickBooks issues.
    ReplyDelete
  24. steffan18 July 2019 at 23:41
     You don’t have to worry for the as all of us is well-aware of the latest software problems and issues. Also, they keep themselves updated with the latest technology and errors introduced in the software on regular time frame. You simply have to relate with us on phone by dialing Quickbooks Tech Support.
    ReplyDelete
  25. Bryan Willson22 July 2019 at 22:14
     Amended income tracker, pinned notes, better registration process and understandings on homepage are the large choice of general alterations for several versions of QuickBooks 2015. It can benefit for QuickBooks Enterprise Technical Support Phone Number  to have technical help & support for QuickBooks. In September 2015, Intuit introduced QuickBooks 2016 that covers several enhancements to your existing ones and new types such as batch transaction, bill tracking, continuous feed label printer support, and batch delete/void transactions etc.
    ReplyDelete
  26. QuickBooks Payroll Support24 July 2019 at 02:31
    QuickBooks Support Phone Number is a simple, simple to use and powerful solution that solves the everyday small-business accounting needs like inventory part tracking, collecting and paying sales tax, time and mileage tracking, job costing and purchase orders and items receipt etc.
    ReplyDelete
  27. Jamess25 July 2019 at 22:09
    Our dedicated team is sure with you. These are generally surely working twenty-four hours a day to help and make suggestions if you come across any QuickBooks Tech Support Number Our QuickBooks Support team surely have in-depth knowledge in connection with problems and issues of QuickBooks.
    ReplyDelete
  28. rdsraftaar30 July 2019 at 22:40
    The most common errors faced by the QuickBooks users is unknown errors thrown by QuickBooks software at the time of software update. To be able to fix the problem, you ought to look at your internet and firewall setting, web browser setting and system time and date setting you can simply give us a call at 247 Tech Support Number for instant assistance in QB issues.
    ReplyDelete
  29. tom wick31 July 2019 at 02:24
    The point that differs it from the above two versions is that it has “No Penalties Guarantee” feature. Being mindful of this, it generates ensure to your user that you will see no penalties on tax filings. The QuickBooks Payroll Tech Support Number software can do tax filings automatically so that as per the procedure.
    ReplyDelete
  30. kevin3231 July 2019 at 22:56

    QuickBooks Enterprise Support Phone Number popularly known as the QB is the greatest accounting software which have integrated various tools in order to make your business accounting process a hurdle free one. QuickBooks is popular due to its reliable, certain and accurate calculations that do keep your time with regards to managing your company accounts the right way. 
    ReplyDelete
  31. kevin327 August 2019 at 23:08
    QuickBooks Help to Manage your online business payroll via Online support team
    QuickBooks Payroll Tech Support Number produced by Intuit assisting millions of businesses precisely. It manages monthly payroll along side tax filing.
    ReplyDelete
  32. kevin3212 August 2019 at 04:06
    common issues are: facing problem while upgrading QuickBooks Support Number to the newest version. There might be trouble while taking backup within your data, you might not be in a position to open your company file on multi-user mode.
    ReplyDelete
  33. kevin3213 August 2019 at 21:42
    A total package to create you clear of Financial accounting and back office worries any time to make sure you concentrate on QuickBooks Customer Service Number own expert area and yield potential development in business.
    ReplyDelete
  34. Jack sparrow25 February 2020 at 23:29
    This post is really nice and informative. The explanation given is really comprehensive and informative.I want to share about  oracle business intelligence training  and  angular js video tutorials 
    ReplyDelete
  35. Hussey3 December 2021 at 22:12
        Extraordinary Blog. Provides necessary information.
    german institute in Chennai
     ​​german coaching center in Chennai
    ReplyDelete
  36. Pavithra Devi17 February 2022 at 22:11
       This post is so interactive and informative.keep update more information…
    Artificial Intelligence Course in Velachery
    Artificial Intelligence Course in Chennai
    ReplyDelete
  37. Matt Reeves1 April 2022 at 21:10
    This post is so interactive and informative.keep update more information...
    SEO Training in Tambarama
    SEO Training in Chennai


    ReplyDelete




























        

      









Subscribe to:
Post Comments (Atom)