Business Intelligence – Oracle

Archive for the ‘Web Center Suite’ Category

Oracle BI EE 10.1.3.3/2 – Deploying JSR 168 Portlets – Displaying Reports in Web Center Suite using JDeveloper

Posted by Venkatakrishnan J on December 20, 2007

I have been thinking about blogging about this for quite some time now. I got some time today to work on this and here is the result. As you would probably know, BI EE by default comes pre-bundled with JSR-168 portlets that can be deployed in any standard Portal that complies with WSRP and JSR-168 standards. So basically one can access the BI EE reports from any standard compliant portal. Today we shall see how to go about using these compliant portlets to retrieve a sample report into Web Center Suite using JDeveloper. The entire process can be divided into 3 main phases. They are

1.   Deploying WSRP Java Containers in an Oracle Application Server   –   Phase 1
2.   Deploying BI EE JSR 168 portlets into the above WSRP Java container   –   Phase 2
3.   Calling BI EE reports from Web Center suite using the above deployed Portlet   –   Phase 3

In my case, i have the following list of components.

   1.   BI EE running on a standalone OC4J in a laptop (say Machine A)
   2.   A standard Oracle Application Server (10.1.2 or above) running on a seperate Machine (say Machine B. This is where we will deploy the Portlets). This Application Server has Portal and Wireless installed.
   3.   JDeveloper (10.1.3.2 or above since they get bundled with a Web Center Suite OC4J) on Machine A.

Phase 1:

   For Phase 1 ie to install the WSRP container, the documentation is very clear and you can get the list of the step by step instructions here

Phase 2:

1.   Once the WSRP container has been created (in my case i have created a container called wsrp), go to {OracleBI}\web\sdk. There you would find a file called sawjsr168portlets.war. Copy this file to a local folder like D:\Portlets.

      

2.   Open a command prompt and navigate to D:\Portlets folder( the folder to which we copied the jsr168portlets.war file). Now type in the following command

jar -xf sawjsr168portlets.war

What this would do is it would open up the war file and will expose the contents in the same directory. So, you basically can see new directories like WEB-INF that would get created.

3.   Now go to D:\Portlets\WEB-INF and open the Portlets.xml file in a text editor. Search for oracle.bi.presentation.sawserver.URL and in the “value” tag enter the URL of the BI EE presentation services.

For example

<preference>
            <name>oracle.bi.presentation.sawserver.URL</name>
            <value>http://10.176.246.99:9704/analytics/saw.dll</value&gt;
            <read-only>false</read-only>
         </preference>

Search for oracle.bi.presentation.portlets.jsr168.reportui.AdminUserName and enter Administrator in the value tag. For example

<preference>
            <name>oracle.bi.presentation.portlets.jsr168.reportui.AdminUserName</name>
            <value>Administrator</value>
            <read-only>false</read-only>
         </preference>

Search for oracle.bi.presentation.portlets.jsr168.reportui.AdminPwd and enter the password for the Administrator user. For example

<preference>
            <name>oracle.bi.presentation.portlets.jsr168.reportui.AdminPwd</name>
            <value>welcome1</value>
            <read-only>false</read-only>
         </preference>

Search for oracle.bi.presentation.report.Path and enter a report URL. For example

<preference>
            <name>oracle.bi.presentation.report.Path</name>
            <value>/shared/paint demo/demo report</value>
            <read-only>false</read-only>
         </preference>

      

4.   Now open up web.xml in a text editor. Search for com.siebel.analytics.web.SAWServer.Host and enter the machine name/ip where BI EE is hosted. For example,

<init-param>
            <param-name>com.siebel.analytics.web.SAWServer.Host</param-name>
            <param-value>10.176.246.99</param-value>
         </init-param>

5.   Now go back to D:\portlets via command prompt and enter the following commands.

jar -uf sawjsr168portlets.war WEB-INF\portlet.xml
jar -uf sawjsr168portlets.war WEB-INF\web.xml

This would update the war file with the changes that we made above.

6.   Now go to the Application Server enterprise manager and Deploy this war file inside the WSRP container that was created above. i have used biee and /biee for the application name and its URL. Ensure that you are able to access the WSDL using the URL http://MIDTIERHOST:PORT/biee/portlets?WSDL

      

      

Now our Phase 2 is complete.

Phase 3:

1.   Open JDeveloper 10.1.3.2 and create a sample application using Webcenter Application as the template.

      

2.   Now lets register the portlet that we deployed above. Give it some name and enter the WSDL url while doing the registration. After that click on finish (keep everything else default).

      

      

3.   Once registered create a simple JSF-JSP page and include this portlet that we registered from the Component Pallette. Ensure that you are exposing the UI components with some sample class names.

      

      

4.   Now execute this JSP. You should see the sample report output.

      

You can also pass the report path dynamically from within web center suite. You need to bind the parameter to the URL.

Posted in All Posts, OBI EE Plus, Web Center Suite | 8 Comments »