tag:blogger.com,1999:blog-5705818669612605666.post219670223928981104..comments2024-03-28T01:38:19.526-04:00Comments on Sathya's Tech Notes: Oracle ADF BI IntegrationSathya AGhttp://www.blogger.com/profile/17711711259619024371noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-5705818669612605666.post-41138084783461803362017-05-27T10:15:06.781-04:002017-05-27T10:15:06.781-04:00Hi Sathya,
I am currently using oracle ADF 12c, i...Hi Sathya,<br /><br />I am currently using oracle ADF 12c, in which I was not able to perform the step 6 mentioned by you(The problem is Technology Scope is not there in project properties). I am able to add new BI connection under Application Resources.But the reports created under the BI publisher are not getting displayed. Can someone help me to resolve this.<br /><br />sindhuhttps://www.blogger.com/profile/07063637730553181743noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-61481762424478484792017-04-27T02:12:44.123-04:002017-04-27T02:12:44.123-04:00Hi,
I did exactly as mentioned and was able to pu...Hi,<br /><br />I did exactly as mentioned and was able to pull dashnoards and individual analysis, however if i want to build a complete dashboard that is pull prompts and analysis i was not able to do that. In the folder i can see only dashboards and analysis, no prompts. Is there something that can be done fof the same.Betsyhttps://www.blogger.com/profile/14523390723467556963noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-50879035112856541072016-04-19T03:31:43.674-04:002016-04-19T03:31:43.674-04:00Hi Lakshmi Vara Prasad Hari,
Did you got any sol...Hi Lakshmi Vara Prasad Hari, <br /><br />Did you got any solution for your problem, I am still facing the same problem. Anonymoushttps://www.blogger.com/profile/16494707511240252309noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-69019569441684192292015-07-28T06:06:43.248-04:002015-07-28T06:06:43.248-04:00Sathyam :(
WebCenter extension is not available f...Sathyam :(<br /><br />WebCenter extension is not available for my J Dev Version 11.1.2.2.0. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-79077686904252418152015-02-05T09:09:06.914-05:002015-02-05T09:09:06.914-05:00Hi Satyam,
I was able to integrate OBIEE with WC...Hi Satyam, <br /><br />I was able to integrate OBIEE with WC-Portal successfully and also showing the dashboard with grids/tables/Charts. <br />But Maps are not getting shown, instead seeing the below message :<br />"Unable to download resource files from Oracle Fusion Middleware MapViewer. Please contact your administrator if this problem persists".<br /><br />Can you help me please. Lakshmi Harihttps://www.blogger.com/profile/10798082082768609453noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-90353720725023881492014-12-29T06:33:17.991-05:002014-12-29T06:33:17.991-05:00I am trying to integrate ADF and OBIEE in jdevelop...I am trying to integrate ADF and OBIEE in jdeveloper using BI Presentation Service. But it show the following error :<br /><br />Dec 29, 2014 2:57:38 PM oracle.bi.presentation.soap.connection.impl.LogonTokenImpl <br />SEVERE: Perform impersonation was enabled for the BI Presentation Services SOAP connection, but there was no logged in user!<br /><br />And in Test Connection it shows the following Error:<br />Connection attempt failed.<br />com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 404: Not Found: http://dev2.corp.ecubein:9704/analytics-ws/saw.dll?SoapImpl=nQSessionServic<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-74415842831305587692014-09-19T04:36:05.707-04:002014-09-19T04:36:05.707-04:00Hi,
I have integrated OBIEE contents into my ADF...Hi,<br /><br /> I have integrated OBIEE contents into my ADF page and deployed it on server. when i open the page through HTTP URL it works fine and get me proper data.<br /><br />But when i use HTTPS URL to open my ADF page, my browsers block the OBIEE contents and then i have to click on "Load Unsafe scripts" to open the OBIEE contents. This has to be done each time i open the page.<br /><br />shirishhttps://www.blogger.com/profile/01134919997300878892noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-48510337187654334532014-05-25T02:29:26.553-04:002014-05-25T02:29:26.553-04:00I haven't tried this on secured ADF applicatio...I haven't tried this on secured ADF applications. Can you please post this on forums.oracle.com to seek resolution. I would also appreciate if you could post resolution (if any) on this post so it would be helpful for others. Thanks!Sathya AGhttps://www.blogger.com/profile/17711711259619024371noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-66305585357388121752014-05-25T02:25:15.898-04:002014-05-25T02:25:15.898-04:00Amit,
First observation is that you are using JDe...Amit,<br /><br />First observation is that you are using JDev 12c and this post clearly defines the version of each product and extension used. Also all your documentation references are for 11g. Please use the recommended product versions as stated in the documentation and follow this post for any guideline/help. Hope that helps.Sathya AGhttps://www.blogger.com/profile/17711711259619024371noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-91928833371486086892014-05-19T17:59:50.797-04:002014-05-19T17:59:50.797-04:00Hi Satya,
I am also getting same issue for secure...Hi Satya,<br /><br />I am also getting same issue for secured application what Amit has mentioned above. Can you please help. I am getting below issue.<br /><br />Unable to connect to the BI Presentation Server. Please ensure that it is running, configured properly, and that the connection details within this application are correct.javax.xml.ws.soap.SOAPFaultException: Authentication error. An invalid User Name or Password was entered.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-80909152643590122862014-04-28T20:47:28.385-04:002014-04-28T20:47:28.385-04:00Hi Sathya,
I am getting same error what Amit has ...Hi Sathya,<br /><br />I am getting same error what Amit has mentioned in previous post when security is configured. Can you please help me out. Thanks in advance.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-25656110395526040582014-04-28T15:12:00.962-04:002014-04-28T15:12:00.962-04:00Hi Sathya,
Thank you for posting an article I'...Hi Sathya,<br />Thank you for posting an article I'm struggling to find over the web!<br />I'm trying to create a jsf page(jspx/jsp any page) which can display an OBIEE report.<br /><br />I have jdev v 12c.<br />First I followed the steps to " Embedding Business Intelligence Objects in ADF Applications"<br />as in Oracle link - <br />http://docs.oracle.com/cd/E28271_01/bi.1111/e10545/embedding_adf.htm<br />http://oraclebisolutions.blogspot.com/2013/02/obiee-11g-adf-integration.html<br /><br />I was able to connect to OBIEE presentation catalog and was able to drag the report into the jspx page. <br />However the table does not have any formatting. No borders for the analysis etc. Plus I was not able to see any graphs in the analysis.<br /><br />I was hoping you knew of any steps or instructions I might be missing potentially.<br /><br />2. Then I followed the link - http://docs.oracle.com/cd/E28271_01/bi.1111/e10545/sql_bi_view_object.htm<br />for - Using the Oracle BI EE Logical SQL View Object<br /><br />The website gave me the hint that this would help me display Analysis in table/graph format.<br /><br />However after following all the steps- I keep getting the error-<br /><br /> <Failure occurred in the execution of deployment request with ID "1398699897845" for task "25". Error is: "weblogic.application.ModuleException: weblogic.common.resourcepool.ResourceSystemException: Cannot load driver class: oracle.bi.jdbc.AnaJdbcDriver"<br />weblogic.application.ModuleException: weblogic.common.resourcepool.ResourceSystemException: Cannot load driver class: oracle.bi.jdbc.AnaJdbcDriver<br /> at weblogic.jdbc.module.JDBCModule.prepare(JDBCModule.java:338)<br /> at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:100)<br /> at weblogic.application.internal.flow.ModuleStateDriver$1.next(ModuleStateDriver.java:172)<br /> at weblogic.application.internal.flow.ModuleStateDriver$1.next(ModuleStateDriver.java:167)<br /> at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:42)<br /> Truncated. see log file for complete stacktrace<br /><br />I do not see any help anywhere for this error. Hope you have some insights-<br /><br />OBIEE - 11.1.1.7<br />WebLogic Server Version: 10.3.6.0<br />JDEV 12c<br />Studio Edition Version 12.1.2.0.0<br />Build JDEVADF_12.1.2.0.0_GENERIC_130608.2330.6668<br />Added all the extensions required/ described<br /><br />I tried with JDEV 11g as well to get same errors.<br />Studio Edition Version 11.1.1.7.0<br />Build JDEVADF_11.1.1.7.0_GENERIC_130226.1400.6493<br /><br />Any help is highly appreciated.<br />ramhttps://www.blogger.com/profile/12164819161492268844noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-67262935442163066362013-09-10T06:44:34.621-04:002013-09-10T06:44:34.621-04:00Hi I am getting this error on my page.
Please help...Hi I am getting this error on my page.<br />Please help me with this.I have a sample adf application without any security .The same connection shows results on my adf page but when i try to show the analysis on other adf application where security is enabled, the following exception occurs.<br /><br />I am struggling since last week .Please guide me ...<br /><br /> Cannot lookup the connection,BIPresentattion using fallbacks<br />oracle.bi.presentation.soap.connection.BISoapException: javax.xml.ws.soap.SOAPFaultException: Authentication error. An invalid User Name or Password was entered.<br />Anonymoushttps://www.blogger.com/profile/12871471827821605407noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-67285799562527156472013-09-10T06:34:18.715-04:002013-09-10T06:34:18.715-04:00Hi Sathya ,
I have created an analysis/dashborad ...Hi Sathya ,<br /><br />I have created an analysis/dashborad in obiee and saved it.Can i see this analysis on my adf page by calling a webservice as you said.If yes can you guide me with the steps.I have seen that BI publisher has been exposed as webservice but in case of bi analytics i havent seen any webservice call which would fetch the analysis/dashboard created in BI AnalyticsAnonymoushttps://www.blogger.com/profile/12871471827821605407noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-62962502924747666282013-08-28T02:28:33.433-04:002013-08-28T02:28:33.433-04:00Really good piece of knowledge, I had come back to...Really good piece of knowledge, I had come back to understand regarding your website from my friend Sumit, Hyderabad And it is very useful for who is looking for <a href="http://biginfosys.com/oracle-adf-online-training.html" rel="nofollow">ORACLE ADF</a>.<br />Anonymoushttps://www.blogger.com/profile/16952375189502544500noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-33030752650554959222013-08-07T02:06:07.068-04:002013-08-07T02:06:07.068-04:00Hi Lokesh,
Absolutely. That is the beauty of open...Hi Lokesh,<br /><br />Absolutely. That is the beauty of open, standards-based, best-of-breed Oracle technology. Just ensure that your OBIEE reports are webservice enabled (through action link framwork) and consume it as any other normal webservice from your application.<br /><br />You will have to tackle the single-sign on using identity management software - like Oracle Adaptive Access Manager.Sathya AGhttps://www.blogger.com/profile/17711711259619024371noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-77525320890257223802013-07-24T07:26:36.679-04:002013-07-24T07:26:36.679-04:00Hi Sathya,
How to display Obiee reports in html/js...Hi Sathya,<br />How to display Obiee reports in html/jsp with out using jdeveloper.<br /><br /><br />Thanks,<br />Aj<br />Anonymoushttps://www.blogger.com/profile/10571578878021141816noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-2668135778200959332013-02-14T18:09:08.006-05:002013-02-14T18:09:08.006-05:00Hi Sathya, This is a great post. While developing ...Hi Sathya, This is a great post. While developing Mobile App for OBIEE with Oracle ADF Mobile do what is the function of Oracle ADF, Do we still have to integrate ORACLE ADF and OBIEE and then use oracle ADF mobile to build the mobile app.<br /><br />REgards,<br />Mainak<br />mainakmitra.officemail@gmail.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-72106583898664649872013-02-03T03:56:46.872-05:002013-02-03T03:56:46.872-05:00Vishnu,
Absolutely. You can follow the steps on t...Vishnu,<br /><br />Absolutely. You can follow the steps on the post to integrate ADF & BI technologies. If you want to have a secured communication, you must configure Oracle BI Presentation Services to communicate over SSL. You can refer to documentation for more details on how to do this. After integraion, your ADF application as such can be secured by ADF security. After all ADF security is built on top of OPSS. Hope this helps.Sathya AGhttps://www.blogger.com/profile/17711711259619024371noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-67840850267953496402013-01-29T23:06:46.167-05:002013-01-29T23:06:46.167-05:00Hi Sathya,
I have a new requirement to build an a...Hi Sathya,<br /> I have a new requirement to build an application which contains mostly OBIEE reports/dashboards and few ADF pages . The question is how to integrate these 2 technologies into 1 application with common security enabled.Please let me know the best way to proceed.<br />Your response is highly appreciated.<br /><br />Thanks,<br />Vishnu.<br />Vishnuhttps://www.blogger.com/profile/01859676603180205225noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-8688856446776733932013-01-14T04:39:34.269-05:002013-01-14T04:39:34.269-05:00Are you able to establish connection successfully ...Are you able to establish connection successfully from your JDeveloper otherwise? ie., from Resource Palette? <br /><br />When I encountered this error, disabling 'Credentials' option worked just fine.Sathya AGhttps://www.blogger.com/profile/17711711259619024371noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-91844197780569058392013-01-09T08:21:01.535-05:002013-01-09T08:21:01.535-05:00Hi Sathyam,
Great post!
But after disabling the ...Hi Sathyam,<br /><br />Great post!<br /><br />But after disabling the credentials option I still get the same error: Cannot lookup the connection,BI Extension Services using fallbacks....<br /><br />What shoult it be?<br /><br />I really struggling with this since 1 week!<br /><br />Would be great to hear from youverklixthttps://www.blogger.com/profile/10116874587659028596noreply@blogger.comtag:blogger.com,1999:blog-5705818669612605666.post-68098097957738399772012-09-11T14:02:44.829-04:002012-09-11T14:02:44.829-04:00Hi Sathyam,
I followed the steps mentioned in the...Hi Sathyam,<br /><br />I followed the steps mentioned in the post to embed obiee reports in a ADF page, data is displaying fine but the style sheets are not getting displayed.My email address is reddysiebel@gmail.com, can you please send me an email so i can send the screen shots.<br /><br />Thanks,<br />SukumarAnonymousnoreply@blogger.com