Creating a BI Publisher/Oracle Analytics Publisher Report in Unifier

To create a BI Publisher/Oracle Analytics Publisher report

Note: For creating and updating BI Publisher/Oracle Analytics Publisher custom reports and BI Publisher/Oracle Analytics Publisher custom prints, and importing reports from BI Publisher/Oracle Analytics Publisher into Unifier (synchronization), refer to the Unifier General Administration Guide.

Sign in to your Unifier environment.
Go to the Company Workspace tab and switch to Admin mode.
In the left Navigator, click Configuration > Custom Templates.
In the right pane:
1. Select the New (drop-down arrow).
2. Choose Report with Internal Data Model or Report with External Data Model.
  If you choose Report with External Data Model, you will continue using the steps in the section.
  
  Notes:
  - Internal data model: Unifier maintains the data model file internally. Any changes in the data views, data links, query parameters, and additional parameters are being applied and saved in the data model when the BI Publisher/Oracle Analytics Publisher report is saved.
  - External data model: Users need to upload the data model (.xdm) file and maintain it externally. This means that the user may modify the .XDM file manually or by using the BI Publisher/Oracle Analytics Publisher data model editor.
In the General tab of the Custom Report dialog box:
1. In the Name field, enter a name for the report.
2. In the Description field, enter a brief description about the report (maximum 250 characters and non-ASCII characters are permitted).
3. The Data Model Type field is a pre-populated and read-only field with values that can be internal or external based on the option selected at the time of creating the custom print.
4. In the Report Level field, select a type for the report.
5. In the Main View field, select a type of view for the report.
  Note: The administrator can create these user-defined views. Refer to the Unifier General Administration Guide for more information on creating data views.
In the Views tab, click Add or Remove to edit the views for the report.
Click Apply.
When the Sample Data tab opens, you can download the sample XML data for creating or modifying report layouts:
- If you are using the Internal Data Model:
  1. Select a project/shell.
  2. Select a number of rows to return.
  3. Click Generate.
  4. Click Download.
  5. Save the XML file.
- If you are using the External Data Model:
  Note: You cannot download sample data until after you define and publish the report.
  1. Select a project/shell.
  2. Click Generate.
  3. Click Download.
  4. Save the XML file.
Create a report layout in Microsoft Word to have templates available in Microsoft Word when you publish reports:
1. Open Microsoft Word.
2. Create an RTF file.
3. In the BI Publisher or Oracle Analytics Publisher tab:
  1. Select Sample XML in the Load Data section.
  2. Upload the XML file you created above.
  3. Create a table for the layout using the Table Wizard included with the BI Publisher/Oracle Analytics Publisher plug-in.
  4. Save and close the RTF file.
Return to the Custom Report dialog box.
In the Template File tab (consisting of Add, Modify, Remove, and Download options)
1. Click Add to open the template window.
2. Enter information in the following fields: Template Name, Template Type, and Report Layout File.
  - To localize the Custom Report output for different languages, you can provide XLIFF files for RTF-type templates here.
  - The Template Name field accepts spaces and other characters.
3. Click Browse to select the template file for uploading.
4. Click OK to confirm the upload.
Return to the Company Workspace tab.
In the left pane:
1. Expand Configuration.
2. Select Custom Reports.
In the right pane, select the report you want to publish.
Click the Status drop-down list on the toolbar and select Published.

If you have not already installed the BI Publisher/Oracle Analytics Publisher plug-in for Microsoft Word, install it now. You can find it here: http://www.oracle.com/technetwork/middleware/analytics-publisher/downloads/index.html.

Note: For the full list of system requirements, applications, and application version levels, refer to the Unifier Tested Configurations document.

Refer to the documentation included with BI Publisher/Oracle Analytics Publisher for more information on using this plug-in.

To create a BI Publisher/Oracle Analytics Publisher report

Related Topics