Oracle® Fusion Middleware Developer's Guide for Oracle Business Intelligence Publisher (Oracle Fusion Applications Edition) 11g Release 1 (11.1.1) Part Number E26385-02 |
|
|
PDF · Mobi · ePub |
This chapter describes how to add a BI Publisher report to an ADF application using Oracle JDeveloper.
It includes the following sections:
Section 9.1, "About Including Oracle BI Publisher Content in ADF Applications"
Section 9.2, "Adding BI Publisher Content to an ADF Project"
Note:
This chapter assumes familiarity with Oracle Application Development Framework (ADF) and Oracle JDeveloper. For more information about these see:
Oracle Fusion Middleware Fusion Developer's Guide for Oracle Application Development Framework
Oracle JDeveloper 11g Online Help
A report designer uses Oracle BI Publisher to create content intended for inclusion in ADF applications. When a developer adds a BI Publisher report to an ADF page, that form contains a reference to the BI Publisher object and does not contain a copy of the object. When the report is modified within the BI Publisher application, any changes will appear in the ADF application the next time the user runs the form.
The Oracle BIPublisher and ADF JDeveloper integration is available from the Oracle Fusion Applications Development Environment extension bundle. For more information about obtaining this bundle, see the Oracle Fusion Applications Developer's Guide.
The following procedures describe how to add BI Publisher content to an ADF project:
Section 9.2.2, "Adding a BI Publisher Region to the JSF Page"
Section 9.2.5, "Setting Properties for a BI Publisher Region"
Perform this procedure to add the proper technology scopes to the ADF project.
In Oracle JDeveloper, go to the Projects Pane and right-click the project to which you want to add the technology scopes and select Project Properties.
Select Technology Scope.
In the Available Technologies list, select BI Publisher as shown in Figure 9-1:
Click the right shuttle button to add BI Publisher and its dependent technologies to your project. Dependent technologies are moved together. Figure 9-2 shows the results of this action.
Click Finish.
The BI Publisher region must reside on a JSF page. The page could be either JSP or JSPX. To add a JSF page to your project:
Right-click your project and select New.
From the Gallery dialog, on the Categories pane, under Web Tier, select JSF.
From the items presented in the right pane, select JSF Page, as shown in Figure 9-3.
On the Create JSF Page dialog, enter a name for your JSF page as shown in Figure 9-4.
Select a Component Palette list. BI Publisher will be an option, as shown in Figure 9-5.
Drag and drop the BI Publisher ADF component from the palette to the page you just created.
Once the BI Publisher Region is dropped to the JSPX page, the Insert BI Publisher Region dialog, shown in Figure 9-6, appears. Enter a region ID for the BI Publisher Region. The region ID must be unique and must not include the underscore "_" character.
Click OK. When the BI Publisher region is inserted, the following will occur:
A report image is displayed in Design Mode.
The BI Publisher configuration file, /WEB-INF/xmlp-client-config.xml is created. Click Refresh on the Projects pane if it does not display immediately.
The Property Inspector presents the BI Publisher region properties for update when the BI Publisher region is selected.
Figure 9-7 shows these items:
To establish a connection to the catalog, update the xmlp-client-config.xml file under Project > Web Content > WEB-INF with the connection information as follows:
Double-click xmlp-client-config.xml to open the file for editing. Figure 9-8 shows the xmlp-client-config.xml file.
Update the following properties (keys):
<properties> <comment>BIP Server Information</comment> <entry key="bipuri"></entry> <entry key="username"></entry> <entry key="password"></entry> </properties>
bipuri - enter the URL for the BI Publisher server. For example: http://example.com:7001/xmlpserver
username - enter the BI Publisher user name
password - for the BI Publisher user name entered above
Note that the username and password are for testing purposes only and are not needed in the production environment. In production, the OWSM layer, in conjunction with the server and client side policy, handles the security between the ADF BIP client and server.
Double-click the JSPX and enter values for reportId, width, and height, for example:
<xdo:BIPRegion id="bipRegion1" reportId="/Executive/Quarterly Income Statement.xdo" width="800px" height="600px">
To deploy and run:
From Project Properties, click Deployment, click New and enter a value for the J2EE application name. Figure 9-9 shows the Create Deployment Profile dialog.
Click WEB-INF/lib. BI Publisher Runtime does not have to be included so long as weblogic.xml and weblogic-application.xml are properly configured. Figure 9-10 shows libraries selected for deployment.
Ensure that Oracle Business Intelligence Publisher shared libraries are installed on your target WebLogic Server instance.
oracle.xdo.runtime: $
MW_HOME
/jdeveloper/xdo/lib/xdoruntime.ea
r
oracle.xdo.webapp: $
MW_HOME
/jdeveloper/xdo/lib/xdowebapp.war
Once all the shared libraries are properly installed, you can see them in the WebLogic Server console as shown in Figure 9-11.
Add a shared library reference to weblogic.xml
and weblogic-application.xml
as shown in Figure 9-12 and Figure 9-13.
From the JDeveloper menu, select Run > Start Server Instance. Do not run the JSPX page directly.
Right-click the application and select Deploy - (your BIP ADF App1ication name) - to IntegratedWLSConnection as shown in Figure 9-14. Make sure the BIP ADF Application deployment profile has your J2EE application name (webapp21 in this example) selected on Application Assembly.
The deployment completed message will display in the Log window.
Open your browser and enter http://hostname:port/j2eeWebAppName/faces/report.jspx
in the address field. Template, OutputFormat, and Locale fields display, as shown in Figure 9-15.
Click Go. A generated report displays, as shown in Figure 9-16.
The following properties are available in the Property Inspector:
Table 9-1 Common Properties
Property | Description |
---|---|
id |
The unique ID for each BI Publisher region. |
reportID |
The path to the report in the BI Publisher catalog. A report will have the extension ".xdo". For example: "/HR Reports/Manager/EmployeeSalaryReport.xdo" |
rendered |
The control to show or hide the BI Publisher region when the page is rendered. The default is true (show). |
Table 9-2 Advanced Properties
Property | Description |
---|---|
TemplateId |
Sets the default template id. The TemplateID is the layout name. |
OutputFormat |
Sets the default output format. For example: PDF, HTML. |
Parameters |
Allows to pass report parameters with Hashtable type. |
ReportData |
This enables to support push data model. |
Table 9-3 Appearance Properties
Property | Description |
---|---|
width |
Sets the report region width. The unit can be either px or % |
height |
Sets the report region height. The unit can be either px or %. |
RenderActionPanel |
Controls whether to show or hide the action panel. The default is true. Note that if you set this to 'false', then you should set renderReportOnLoad to 'true'. |
RenderFormatList |
Controls whether to show or hide the Format List. Default is true. |
RenderReportOnLoad |
Determines whether a report is generated when the ADF page is launched. Default is true. |