- Implementing Product Management
- Configure the Template for the Item Structure Report with Additional Attributes
Configure the Template for the Item Structure Report with Additional Attributes
You can configure the template for the item structure report with additional attributes by following the procedure in this topic.
Before you start
Ensure that the BI Publisher plug-in is enabled in Microsoft Word.Here's what to do
- In the Oracle Transactional Business Intelligence Catalog, expand Shared Folders > Supply Chain Management > Product Management > Items > Structures > Data Models.
-
Click Edit for the Item Structure Report Data
Model.
The Item Structure Report Data Model page appears.
-
In the Data Model pane, click Properties.
The properties for the data model are displayed.
-
In the Attachment section, in the Sample Data field,
click sample.xml.
A dialog box appears with options to save the
sample.xml
file. -
Select the location where the
sample.xml
file must be saved, and click Save. -
In Microsoft Word, open
UserDefined_ItemStructure.rtf
. -
On the BI Publisher tab, click Sample XML.
A dialog box opens.
-
Go to the
sample.xml
file, select it, and click Open. - In the confirmation dialog box that appears, click OK.
- Insert the header and data fields, and change the default/displayed text for the fields as required.
-
In the fields, insert the values displayed in this table:
Header Field
Data Field
@effLabel
ITEM_EFF
@label
AML_DFF
@label
MPN_DFF
@label
COMPONENT_DFF
-
Set the properties for the header and data fields for each attribute type on
the Advanced tab in the BI Publisher Properties dialog box.
Attribute Type
BI Publisher Property for Header Field
BI Publisher Property for Data Field
AML Descriptive Flexfield
<?split-column-header:AML_DFF_ATTR?> <?split-column-width-unit:5?> <?split-column-width:10?> <?@Label?>
<?split-column-data:AML_DFF_ATTR?> <?AML_DFF?> <?end?>
Component Descriptive Flexfield
<?split-column-header:COMPONENT_DFF_ATTR?> <?split-column-width-unit:5?> <?split-column-width:10?> <?@Label?>
<?split-column-data:COMPONENT_DFF_ATTR?> <?COMPONENT_DFF?> <?end?>
Item Extensible Flexfield
<?split-column-header:ITEM_EFF_ATTR?> <?split-column-width-unit:5?> <?split-column-width:10?> <?@effLabel?>
<?split-column-data:ITEM_EFF_ATTR?> <?ITEM_EFF?> <?end?>
MPN Descriptive Flexfield
<?split-column-header:MPN_DFF_ATTR?> <?split-column-width-unit:5?> <?split-column-width:10?> <?@Label?>
<?split-column-data:MPN_DFF_ATTR?> <?MPN_DFF?> <?end?>
-
Save the
UserDefined_ItemStructure.rtf
file.Note:Ensure that the
UserDefined_ItemStructure.rtf
file is backed up to the Custom folder because modified templates are deleted after upgrades and must be manually copied from the Custom folder after upgrades.
Related Topics
- Overview of Configuring the Template for the Item Structure Report with Attributes
- Download the Template for the Item Structure Report
- Configure the Template for the Item Structure Report with the Main and AML Attribute
- Upload the Configured Template for the Item Structure Report
- Verify the Configured Template for the Item Structure Report