8 Adding Custom Metadata for Oracle WebCenter Content Server

This topic describes how to use the data model editor to map fields from your data source to the custom metadata fields. When delivering reports to an Oracle WebCenter Content Server, BI Publisher can populate the custom metadata fields defined in your document profiles.

Topics:

• About Custom Metadata Mapping

• Mapping Data Fields to Custom Metadata Fields

• Deleting Unused Metadata Fields

About Custom Metadata Mapping

The Custom Metadata component of the data model enables mapping data fields, for example, invoice number or customer name, from your data model to the metadata fields defined in document profile rules configured on your Oracle WebCenter Content Server.

When you run the report and select an Oracle WebCenter Content server as the delivery destination, Oracle BI Publisher generates and stores the document on the content server with the metadata.

Prerequisites

Certain requirements must be met to use this feature of the data model editor.

Prerequisites:

• The content server must be configured as a delivery destination with custom metadata enabled.

• To map the custom metadata fields to data fields from your data model data set, the data set must be of a type that the data model editor can retrieve the data structure, for example, SQL data sets and Excel data sets are supported; however, Web service data sets are not.

Mapping Data Fields to Custom Metadata Fields

You can start metadata under a document profile.

To map custom metadata:

1. In the data model editor task pane, click Custom Metadata.
   
   

   
   Description of the illustration GUID-F618060B-D5EF-4CCF-80FE-43C941A69540-default.gif

   
   
2. Oracle WebCenter Content Server stores metadata under a document profile. A document profile is further nested into rules. To retrieve the metadata fields for mapping, you first select the WebCenter server, then the Content Profile, then the Rules set.

   On the Custom Metadata header region, select the Rules as follows:

   • Server — Select the Web content server where the content profile is defined.

   • Content Profile — Select the content profile that includes the rules that define custom metadata fields.

   • Rules — Select the Rules set that specifies the metadata fields.

     If you do not select a Rules set, then BI Publisher loads the metadata for all Rules under the Content Profile.

3. Click Load Metadata. The lower pane displays the metadata fields defined in the Rules you selected.
   
   

   
   Description of the illustration GUID-3ED86CBD-6264-46D0-A995-D361AB67B8D6-default.gif

   
   
4. For each metadata field, map a data field from your data sets by selecting it from the Data Mapping list. The Data Mapping list displays all the data fields from your data sets.

   If a metadata field is required a Y is displayed in the Required column.

   
   

   
   Description of the illustration GUID-0FC93EAF-252A-481A-9C39-28AF22C0D84A-default.gif

   
   
5. When you are done with mapping the metadata fields, click Save.

Deleting Unused Metadata Fields

BI Publisher loads all the metadata fields defined for the Rules set that you select. You can delete unneeded custom metadata fields.

1. Select the metadata field, either by clicking the field name on the left pane or by clicking the selection column in the table.
2. Click the Delete button.