Skip Headers
Oracle® Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition (Oracle Fusion Applications Edition)
11g Release 1 (11.1.1)

Part Number E20836-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

G XML Schema Files for ADF Mapping Customizations

This appendix describes the app_segment_rule.xsd and mapping_rules.xsd XML schema files. XML files based on these XML validation schemas define mapping rules that control the physical to logical mapping behavior for ADF data source objects.

This appendix contains the following sections:

app_segment_rule.xsd XML Schema File

The XML schema file app_segment_rule.xsd contains mapping rules that define the physical table to logical table mapping. This section provides an annotated version of the app_segment_rule.xsd XML schema file.

Example G-1 app_segment_rule.xsd

<?xml version="1.0" encoding="utf-8" ?> 
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
 <xs:complexType name="alias_t">
  <xs:attribute name="aliasTableName" type="xs:string" use="required" /> 
 </xs:complexType>
 <xs:complexType name="aliasTableList_t">
  <xs:sequence>
   <xs:element name="AliasTable" type="alias_t" minOccurs="1" maxOccurs=
   "unbounded" /> 
  </xs:sequence>
 </xs:complexType>
 <xs:complexType name="subjectArea_t">
  <xs:attribute name="subjectAreaName" type="xs:string" use="required" /> 
 </xs:complexType>
 <xs:complexType name="subjectAreaList_t">
  <xs:sequence>
   <xs:element name="OTBISubjectArea" type="subjectArea_t" minOccurs="1"
   maxOccurs="unbounded" /> 
  </xs:sequence>
 </xs:complexType>
 <xs:complexType name="columnmapping_t">

<!-- voColumnName specifies the ADF VO column name -->

  <xs:attribute name="voColumnName" type="xs:string" use="required" />

<!-- logicalDimColumnName specifies the logical column name -->

  <xs:attribute name="logicalDimColumnName" type="xs:string" use="required" />
 </xs:complexType>
 <xs:complexType name="columnMappingsList_t">
  <xs:sequence>

<!-- ColumnMapping specifies the set of column mappings -->

   <xs:element name="ColumnMapping" type="columnmapping_t" minOccurs="1"
   maxOccurs="unbounded" /> 
  </xs:sequence>
 </xs:complexType>
 <xs:complexType name="labelToDimMap_t">
  <xs:sequence>

<!-- For mapping the _ and _c suffixed value and value set columns in the code,
combine flattened fact VOS corresponding to the segment mapped to the logical 
table -->

   <xs:element name="FlattenedFlexVOColumnMappings" type="columnMappingsList_t"
   minOccurs="0" maxOccurs="1" />

<!-- TableSpecificColumnMappingOverrides is for future use -->

   <xs:element name="TableSpecificColumnMappingOverrides"
   type="columnMappingsList_t" minOccurs="0" maxOccurs="1" />

<!-- TableSpecificOTBISubjectAreas specifies the Oracle Transactional Business
Intelligence subjects areas. The unqualified segment Logical Tables Dim - GL
Segment 1 - 10 are dragged to these subject areas. For other use cases, specify
your own repository subject areas. -->

   <xs:element name="TableSpecificOTBISubjectAreas" type="subjectAreaList_t"
   minOccurs="0" maxOccurs="1" />

<!-- DFFBaseVOAliases is for future use -->

   <xs:element name="DFFBaseVOAliases" type="aliasTableList_t" minOccurs="0"
   maxOccurs="1" />
  </xs:sequence>

<!-- segmentLabelName is for future use -->

  <xs:attribute name="segmentLabelName" type="xs:string" use="optional" />

<!-- logicalDimTableName specifies the logical table to which the ADF VO is 
mapped. ADF database properties contain the mapping between the ADF VO 
("BIObject_'ADF VO Name'") and logical table mentioned here. -->

  <xs:attribute name="logicalDimTableName" type="xs:string" use="required" />

<!-- In role playing dimensions, the logical table specified in the
roleMasterLogicalTableName attribute is used as the master logical table. Whenever
the master logical table is mapped to a VO, the alias of this VO is created and
joined to the table referenced in the flattenedFlexVORoleAlias attribute. The
alias table name is "{ADF_VO_Name}_{Role_Playing_Logical_Table_Name}". Logical
columns are mapped to the columns of this alias table. -->

  <xs:attribute name="roleMasterLogicalTableName" type="xs:string"
  use="optional" />

<!-- flattenedFlexVORoleAlias specifies the flattened VO alias that needs to be
joined with the role playing VO alias table -->

  <xs:attribute name="flattenedFlexVORoleAlias" type="xs:string" use="optional" /> 
 </xs:complexType>

<!-- The root element for the mapping rule document -->

 <xs:element name="MappingRules">
  <xs:complexType>
   <xs:sequence>

<!-- GlobalColumnMappings is for future use -->

    <xs:element name="GlobalColumnMappings" type="columnMappingsList_t"
    minOccurs="0" maxOccurs="1" />

<!-- GlobalOTBISubjectAreas specifies the Oracle Transactional Business
Intelligence subject areas. The unqualified segment Logical Tables Dim - GL
Segment 1 - 10 are dragged to these subject areas. The rules specified here apply
to all logical tables. For other use cases, specify your own subject areas. -->

    <xs:element name="GlobalOTBISubjectAreas" type="subjectAreaList_t"
    minOccurs="0" maxOccurs="1" />

<!-- LabelToDimensionMappings specifies the rules for a logical table -->

    <xs:element name="LabelToDimensionMappings" type="labelToDimMap_t"
    minOccurs="0" maxOccurs="unbounded" />
   </xs:sequence>

<!-- appName is the ADF Module Name from where the ADF VOs are imported. It is
also used as a key for reading the properties from the ADF database. It is
sometimes known as the Category or Module Name. -->

   <xs:attribute name="appName" type="xs:string" use="required" />

<!-- businessModelName specifies the business model in the Business Model and
Mapping layer. The ADF VOs are mapped to the logical tables in this business
model. The default business model is "Core." -->

   <xs:attribute name="businessModelName" type="xs:string" default="Core"
   use="optional" />

<!-- flattenedFlexLogicalTable specifies the logical table to which the flattened
fact VO for the KFF needs to map -->

   <xs:attribute name="flattenedFlexLogicalTable" type="xs:string"
   use="optional" /> 
  </xs:complexType>
 </xs:element>
</xs:schema>

app_segment_rules_*.xml Example

This section provides an example of an app_segment_rules_*.xml file, based on the validation rules contained in app_segment_rules.xsd.

Example G-2 app_segment_rules_*.xml example

<?xml version="1.0" encoding="UTF-8" ?>
<MappingRules appName="FscmTopModelAM.AccountBIAM" businessModelName="Core"
flattenedFlexLogicalTable="Dim - GL Account">
 <GlobalOTBISubjectAreas>
  <OTBISubjectArea subjectAreaName="General Ledger - Balances Real Time" />
  <OTBISubjectArea subjectAreaName="General Ledger - Journals Real Time" />
  <OTBISubjectArea subjectAreaName="General Ledger - Transactional Balances Real
  Time" /> 
  <OTBISubjectArea subjectAreaName="Payables Invoices - Prepayment Invoice
  Distributions Real Time" /> 
  <OTBISubjectArea subjectAreaName="Payables Invoices - Transactions Real Time" /> 
  <OTBISubjectArea subjectAreaName="Payables Invoices - Trial Balance Real Time"
  /> 
  <OTBISubjectArea subjectAreaName="Payables Payments - Disbursements Real Time"
  /> 
  <OTBISubjectArea subjectAreaName="Project Costing - Actual Costs Real Time" /> 
  <OTBISubjectArea subjectAreaName="Project Billing - Revenue Real Time" /> 
  <OTBISubjectArea subjectAreaName="Receivables - Adjustments Real Time" /> 
  <OTBISubjectArea subjectAreaName="Receivables - Credit Memo Applications Real
  Time" /> 
  <OTBISubjectArea subjectAreaName="Receivables - Miscellaneous Receipts Real
  Time" /> 
  <OTBISubjectArea subjectAreaName="Receivables - Receipts History Real Time" /> 
  <OTBISubjectArea subjectAreaName="Receivables - Revenue Adjustments Real Time"
  /> 
  <OTBISubjectArea subjectAreaName="Receivables - Standard Receipts Real Time" /> 
  <OTBISubjectArea subjectAreaName="Receivables - Transactions Real Time" /> 
  <OTBISubjectArea subjectAreaName="Subledger Accounting - Journals Real Time" /> 
  <OTBISubjectArea subjectAreaName="Subledger Accounting - Supporting References
  Real Time" /> 
  <OTBISubjectArea subjectAreaName="Subledger Accounting - Payables Summary
  Reconciliation Real Time" /> 
  <OTBISubjectArea subjectAreaName="Subledger Accounting - Receivables Summary
  Reconciliation Real Time" /> 
  <OTBISubjectArea subjectAreaName="Cash Management - External Cash Transactions
  Real Time" /> 
 </GlobalOTBISubjectAreas>
 <LabelToDimensionMappings logicalDimTableName="Dim - Balancing Segment">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Balancing Segment Code"
   /> 
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Balancing Segment Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - Cost Center">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Cost Center Segment Code"
   /> 
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Cost Center Segment
   Value Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - Natural Account Segment">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Natural Account Segment
   Code" /> 
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Natural Account Segment
   Value Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - GL Segment1">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Account Segment1 Code" /> 
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Account Segment1 Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - GL Segment2">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Account Segment2 Code" /> 
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Account Segment2 Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - GL Segment3">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Account Segment3 Code" /> 
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Account Segment3 Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - GL Segment4">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Account Segment4 Code" /> 
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Account Segment4 Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - GL Segment5">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Account Segment5 Code" /> 
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Account Segment5 Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - GL Segment6">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Account Segment6 Code" /> 
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Account Segment6 Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - GL Segment7">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Account Segment7 Code" />
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Account Segment7 Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - GL Segment8">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Account Segment8 Code" />
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Account Segment8 Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - GL Segment9">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Account Segment9 Code" />
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Account Segment9 Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - GL Segment10">
  <FlattenedFlexVOColumnMappings>
   <ColumnMapping voColumnName="_" logicalDimColumnName="Account Segment10 Code"
   /> 
   <ColumnMapping voColumnName="_c" logicalDimColumnName="Account Segment10 Value
   Set Code" /> 
  </FlattenedFlexVOColumnMappings>
 </LabelToDimensionMappings>
 <LabelToDimensionMappings logicalDimTableName="Dim - AP Account Balancing
 Segment" roleMasterLogicalTableName="Dim - Balancing Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_APAccount" />
 <LabelToDimensionMappings logicalDimTableName="Dim - AP Account Cost Center"
 roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias="Dim_
 FLEX_BI_Account_VI_APAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - AP Account Natural Account
 Segment" roleMasterLogicalTableName="Dim - Natural Account Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_APAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - AP Asset Account Balancing
 Segment" roleMasterLogicalTableName="Dim - Balancing Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_APAssetAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - AP Asset Account Cost
 Center" roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias=
 "Dim_FLEX_BI_Account_VI_APAssetAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - AP Asset Account Natural
 Account Segment" roleMasterLogicalTableName="Dim - Natural Account Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_APAssetAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - AP Pay Account Balancing
 Segment" roleMasterLogicalTableName="Dim - Balancing Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_APPayAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - AP Pay Account Cost Center"
 roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias="Dim_
 FLEX_BI_Account_VI_APPayAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - AP Pay Account Natural
 Account Segment" roleMasterLogicalTableName="Dim - Natural Account Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_APPayAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Asset From Balancing
 Segment" roleMasterLogicalTableName="Dim - Balancing Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_AssetFromDeprnExpenseAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Asset From Cost Center"
 roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias="Dim_
 FLEX_BI_Account_VI_AssetFromDeprnExpenseAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Asset From Natural Account
 Segment" roleMasterLogicalTableName="Dim - Natural Account Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_AssetFromDeprnExpenseAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Asset Balancing Segment"
 roleMasterLogicalTableName="Dim - Balancing Segment" flattenedFlexVORoleAlias=
 "Dim_FLEX_BI_Account_VI_AssetDeprnExpenseAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Asset Cost Center"
  roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias="Dim_
FLEX_BI_Account_VI_AssetDeprnExpenseAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Asset Natural Account
 Segment" roleMasterLogicalTableName="Dim - Natural Account Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_AssetDeprnExpenseAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Asset To Balancing Segment"
 roleMasterLogicalTableName="Dim - Balancing Segment" flattenedFlexVORoleAlias=
 "Dim_FLEX_BI_Account_VI_AssetToDeprnExpenseAccount" />
 <LabelToDimensionMappings logicalDimTableName="Dim - Asset To Cost Center"
 roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias="Dim_
 FLEX_BI_Account_VI_AssetToDeprnExpenseAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Asset To Natural Account
 Segment" roleMasterLogicalTableName="Dim - Natural Account Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_AssetToDeprnExpenseAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Distribution Balancing
 Segment" roleMasterLogicalTableName="Dim - Balancing Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_ArAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Distribution Cost Center"
 roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias="Dim_
 FLEX_BI_Account_VI_ArAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - Distribution Natural Account
 Segment" roleMasterLogicalTableName="Dim - Natural Account Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_ArAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - SLA Balancing Segment"
 roleMasterLogicalTableName="Dim - Balancing Segment" flattenedFlexVORoleAlias=
 "Dim_FLEX_BI_Account_VI_SLA_Account" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - SLA Cost Center"
 roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias="Dim_
 FLEX_BI_Account_VI_SLA_Account" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - SLA Natural Account"
 roleMasterLogicalTableName="Dim - Natural Account Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_SLA_Account" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - CE Asset Balancing Segment
 Value" roleMasterLogicalTableName="Dim - Balancing Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_CEAssetAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - CE Asset Cost Center Value"
 roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias="Dim_
 FLEX_BI_Account_VI_CEAssetAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - CE Asset Natural Account
 Value" roleMasterLogicalTableName="Dim - Natural Account Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_CEAssetAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - CE Offset Balancing Segment
 Value" roleMasterLogicalTableName="Dim - Balancing Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_CEOffsetAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - CE Offset Cost Center Value"
 roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias="Dim_
 FLEX_BI_Account_VI_CEOffsetAccount" /> 
 <LabelToDimensionMappings logicalDimTableName="Dim - CE Offset Natural Account
 Value" roleMasterLogicalTableName="Dim - Natural Account Segment"
 flattenedFlexVORoleAlias="Dim_FLEX_BI_Account_VI_CEOffsetAccount" /> 
</MappingRules>

mapping_rules.xsd XML Schema File

The XML schema file mapping_rules.xsd contains mapping rules that define the physical column to logical column mapping. This section provides an annotated version of the mapping_rules.xsd XML schema file.

Example G-3 mapping_rules.xsd

<?xml version="1.0" encoding="utf-8" ?> 
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">

<!-- This XML validation schema defines rules that determine how physical columns
imported at the physical layer are mapped to the Business Model and Mapping
layer. -->

 <xs:simpleType name="yes_no_t">
  <xs:restriction base="xs:string">
   <xs:enumeration value="yes" /> 
   <xs:enumeration value="no" /> 
  </xs:restriction>
 </xs:simpleType>

<!-- Description of one mapping -->

 <xs:complexType name="mapping_t">

<!-- The source attribute specifies the physical ADF VO column -->

  <xs:attribute name="source" type="xs:string" use="required" />

<!-- The target attribute specifies the target logical column suffix or complete
name -->

  <xs:attribute name="target" type="xs:string" use="required" />

<!-- The addprefix attribute specifies whether or not the prefix specified in the
"rule" must be prefixed with the target to get the logical table column name
before performing the mapping -->

  <xs:attribute name="addprefix" type="yes_no_t" default="no" use="optional" /> 
 </xs:complexType>
 <xs:complexType name="rule_t">
  <xs:sequence>

<!-- List of mappings that define the rule -->

   <xs:element name="mapping" type="mapping_t" minOccurs="1" maxOccurs="unbounded"
   /> 
  </xs:sequence>

<!-- The name attribute specifies the rule name. This name is used by the instance
to specify which rule to apply. -->

  <xs:attribute name="name" type="xs:string" use="required" /> 
 </xs:complexType>
 <xs:complexType name="rules_t">
  <xs:sequence>

<!-- Each rule defines the source (physical) to target (logical) mapping. It
is used by the Import Metadata Wizard during the Physical to Logical Mapping
phase. Each mapping in a rule can specify whether the default prefix for an
instance should be added. -->

   <xs:element name="rule" type="rule_t" minOccurs="1" maxOccurs="unbounded" />
  </xs:sequence>
 </xs:complexType>
 <xs:complexType name="apply_t">

<!-- The rule attribute specifies which rule to apply for the logical table
mentioned in the instance -->

  <xs:attribute name="rule" type="xs:string" use="required" />

<!-- The prefix attribute specifies the string that might or might not be
prepended when performing the mapping between the ADF VO column and the logical
table column -->

  <xs:attribute name="prefix" type="xs:string" default="" use="optional" /> 
 </xs:complexType>
 <xs:complexType name="instance_t">
  <xs:sequence>

<!-- apply specifies what rule to apply to the logical table -->

   <xs:element name="apply" type="apply_t" minOccurs="1" maxOccurs="unbounded" /> 
  </xs:sequence>

<!-- The logicaltable attribute specifies the logical table to which the rule is
applied -->

  <xs:attribute name="logicaltable" type="xs:string" use="required" /> 
 </xs:complexType>
 <xs:complexType name="instances_t">
  <xs:sequence>

<!-- Each instance is associated with a single logical table. It applies any
number of rules, with an optional prefix. The rules are applied in order. Note
that the prefix includes a space at the end. It merely concatenates with the
target logical column to determine the right logical column to map to. -->

   <xs:element name="instance" type="instance_t" minOccurs="1" maxOccurs="unbounded" /> 
  </xs:sequence>
 </xs:complexType>

<!-- The document element is the element declaration for the entire document -->

 <xs:element name="document">
  <xs:complexType>
   <xs:sequence>

<!-- The rules element specifies the set of rules -->

    <xs:element name="rules" type="rules_t" minOccurs="1" maxOccurs="1" />

<!-- The instances element specifies the set of instances -->

    <xs:element name="instances" type="instances_t" minOccurs="1" maxOccurs="1" />
   </xs:sequence>

<!-- appName is the ADF Module Name from which ADF VOs are imported -->

   <xs:attribute name="appName" type="xs:string" /> 
  </xs:complexType>
 </xs:element>
</xs:schema>

mapping_rules_*.xml Example

This section provides an example of a mapping_rules_*.xml file, based on the validation rules contained in mapping_rules.xsd.

Example G-4 mapping_rules_*.xml

<?xml version="1.0" encoding="UTF-8" ?> 
<document appName="FscmTopModelAM.AccountBIAM">
 <rules>

<!-- Each Rule defines the source (physical) to target (logical) mapping. It is
used by the Import Metadata Wizard during the Physical to Logical Mapping phase.
Each mapping in a rule can specify whether it should add the default prefix for an
instance. -->

  <rule name="GL Segment Tree Rule">
   <mapping source="TreeCode" target="Tree Code" addprefix="no" />
   <mapping source="TreeVersionId" target="Tree Version ID" addprefix="no" />
   <mapping source="VersionName" target="Tree Version Name" addprefix="no" />
   <mapping source="Dep0Pk2Value" target="Segment Value Set Code" addprefix="yes"
   /> 
   <mapping source="Dep0Value" target="Segment Code" addprefix="yes" />
   <mapping source="Dep0Description" target="Segment Description" addprefix="yes"
   /> 
   <mapping source="Dep1Value" target="Level 1 Code" addprefix="yes" /> 
   <mapping source="Dep1Description" target="Level 1 Description" addprefix="yes"
   /> 
   <mapping source="Dep2Value" target="Level 2 Code" addprefix="yes" /> 
   <mapping source="Dep2Description" target="Level 2 Description" addprefix="yes"
   /> 
   <mapping source="Dep3Value" target="Level 3 Code" addprefix="yes" /> 
   <mapping source="Dep3Description" target="Level 3 Description" addprefix="yes"
   />
   <mapping source="Dep4Value" target="Level 4 Code" addprefix="yes" /> 
   <mapping source="Dep4Description" target="Level 4 Description" addprefix="yes"
   /> 
   <mapping source="Dep5Value" target="Level 5 Code" addprefix="yes" /> 
   <mapping source="Dep5Description" target="Level 5 Description" addprefix="yes"
   /> 
   <mapping source="Dep6Value" target="Level 6 Code" addprefix="yes" /> 
   <mapping source="Dep6Description" target="Level 6 Description" addprefix="yes"
   /> 
   <mapping source="Dep7Value" target="Level 7 Code" addprefix="yes" /> 
   <mapping source="Dep7Description" target="Level 7 Description" addprefix="yes"
   />
   <mapping source="Dep8Value" target="Level 8 Code" addprefix="yes" /> 
   <mapping source="Dep8Description" target="Level 8 Description" addprefix="yes"
   /> 
   <mapping source="Dep9Value" target="Level 9 Code" addprefix="yes" /> 
   <mapping source="Dep9Description" target="Level 9 Description" addprefix="yes"
   /> 
   <mapping source="Dep10Value" target="Level 10 Code" addprefix="yes" /> 
   <mapping source="Dep10Description" target="Level 10 Description"
   addprefix="yes" /> 
   <mapping source="Dep11Value" target="Level 11 Code" addprefix="yes" /> 
   <mapping source="Dep11Description" target="Level 11 Description"
   addprefix="yes" /> 
   <mapping source="Dep12Value" target="Level 12 Code" addprefix="yes" /> 
   <mapping source="Dep12Description" target="Level 12 Description"
   addprefix="yes" /> 
   <mapping source="Dep13Value" target="Level 13 Code" addprefix="yes" /> 
   <mapping source="Dep13Description" target="Level 13 Description"
   addprefix="yes" /> 
   <mapping source="Dep14Value" target="Level 14 Code" addprefix="yes" /> 
   <mapping source="Dep14Description" target="Level 14 Description"
   addprefix="yes" /> 
   <mapping source="Dep15Value" target="Level 15 Code" addprefix="yes" /> 
   <mapping source="Dep15Description" target="Level 15 Description"
   addprefix="yes" /> 
   <mapping source="Dep16Value" target="Level 16 Code" addprefix="yes" /> 
   <mapping source="Dep16Description" target="Level 16 Description"
   addprefix="yes" /> 
   <mapping source="Dep17Value" target="Level 17 Code" addprefix="yes" /> 
   <mapping source="Dep17Description" target="Level 17 Description"
   addprefix="yes" /> 
   <mapping source="Dep18Value" target="Level 18 Code" addprefix="yes" /> 
   <mapping source="Dep18Description" target="Level 18 Description"
   addprefix="yes" /> 
   <mapping source="Dep19Value" target="Level 19 Code" addprefix="yes" /> 
   <mapping source="Dep19Description" target="Level 19 Description"
   addprefix="yes" /> 
   <mapping source="Dep20Value" target="Level 20 Code" addprefix="yes" /> 
   <mapping source="Dep20Description" target="Level 20 Description"
   addprefix="yes" /> 
   <mapping source="Dep21Value" target="Level 21 Code" addprefix="yes" /> 
   <mapping source="Dep21Description" target="Level 21 Description"
   addprefix="yes" /> 
   <mapping source="Dep22Value" target="Level 22 Code" addprefix="yes" /> 
   <mapping source="Dep22Description" target="Level 22 Description"
   addprefix="yes" /> 
   <mapping source="Dep23Value" target="Level 23 Code" addprefix="yes" /> 
   <mapping source="Dep23Description" target="Level 23 Description"
   addprefix="yes" /> 
   <mapping source="Dep24Value" target="Level 24 Code" addprefix="yes" /> 
   <mapping source="Dep24Description" target="Level 24 Description"
   addprefix="yes" /> 
   <mapping source="Dep25Value" target="Level 25 Code" addprefix="yes" /> 
   <mapping source="Dep25Description" target="Level 25 Description"
   addprefix="yes" /> 
   <mapping source="Dep26Value" target="Level 26 Code" addprefix="yes" /> 
   <mapping source="Dep26Description" target="Level 26 Description"
   addprefix="yes" /> 
   <mapping source="Dep27Value" target="Level 27 Code" addprefix="yes" /> 
   <mapping source="Dep27Description" target="Level 27 Description"
   addprefix="yes" /> 
   <mapping source="Dep28Value" target="Level 28 Code" addprefix="yes" /> 
   <mapping source="Dep28Description" target="Level 28 Description"
   addprefix="yes" /> 
   <mapping source="Dep29Value" target="Level 29 Code" addprefix="yes" /> 
   <mapping source="Dep29Description" target="Level 29 Description"
   addprefix="yes" /> 
   <mapping source="Dep30Value" target="Level 30 Code" addprefix="yes" /> 
   <mapping source="Dep30Description" target="Level 30 Description"
   addprefix="yes" /> 
   <mapping source="Dep31Value" target="Level 31 Code" addprefix="yes" /> 
   <mapping source="Dep31Description" target="Level 31 Description"
   addprefix="yes" /> 
   <mapping source="Distance" target="Fixed Hierarchy Level" addprefix="no" /> 
   <mapping source="VersionEffectiveStartDate" target="Effective From"
   addprefix="no" /> 
   <mapping source="VersionEffectiveEndDate" target="Effective To" addprefix="no"
   /> 
  </rule>
  <rule name="GL Segment Non-Tree Rule">
   <mapping source="Value" target="Segment Code" addprefix="yes" /> 
   <mapping source="ValueSetCode" target="Segment Value Set Code" addprefix="yes"
   /> 
   <mapping source="Description" target="Segment Description" addprefix="yes" /> 
  </rule>
  <rule name="Qualified Segment Tree Rule">
   <mapping source="TreeCode" target="Tree Code" addprefix="no" /> 
   <mapping source="TreeVersionId" target="Tree Version ID" addprefix="no" /> 
   <mapping source="VersionName" target="Tree Version Name" addprefix="no" /> 
   <mapping source="Dep0Pk2Value" target="Value Set Code" addprefix="yes" /> 
   <mapping source="Dep0Value" target="Code" addprefix="yes" /> 
   <mapping source="Dep0Description" target="Description" addprefix="yes" /> 
   <mapping source="Dep1Value" target="Level 1 Code" addprefix="yes" /> 
   <mapping source="Dep1Description" target="Level 1 Description" addprefix="yes"
   /> 
   <mapping source="Dep2Value" target="Level 2 Code" addprefix="yes" /> 
   <mapping source="Dep2Description" target="Level 2 Description" addprefix="yes"
   /> 
   <mapping source="Dep3Value" target="Level 3 Code" addprefix="yes" /> 
   <mapping source="Dep3Description" target="Level 3 Description" addprefix="yes"
   /> 
   <mapping source="Dep4Value" target="Level 4 Code" addprefix="yes" /> 
   <mapping source="Dep4Description" target="Level 4 Description" addprefix="yes"
   /> 
   <mapping source="Dep5Value" target="Level 5 Code" addprefix="yes" /> 
   <mapping source="Dep5Description" target="Level 5 Description" addprefix="yes"
   /> 
   <mapping source="Dep6Value" target="Level 6 Code" addprefix="yes" /> 
   <mapping source="Dep6Description" target="Level 6 Description" addprefix="yes"
   /> 
   <mapping source="Dep7Value" target="Level 7 Code" addprefix="yes" /> 
   <mapping source="Dep7Description" target="Level 7 Description" addprefix="yes"
   /> 
   <mapping source="Dep8Value" target="Level 8 Code" addprefix="yes" /> 
   <mapping source="Dep8Description" target="Level 8 Description" addprefix="yes"
   /> 
   <mapping source="Dep9Value" target="Level 9 Code" addprefix="yes" /> 
   <mapping source="Dep9Description" target="Level 9 Description" addprefix="yes"
   /> 
   <mapping source="Dep10Value" target="Level 10 Code" addprefix="yes" /> 
   <mapping source="Dep10Description" target="Level 10 Description"
   addprefix="yes" /> 
   <mapping source="Dep11Value" target="Level 11 Code" addprefix="yes" /> 
   <mapping source="Dep11Description" target="Level 11 Description"
   addprefix="yes" /> 
   <mapping source="Dep12Value" target="Level 12 Code" addprefix="yes" /> 
   <mapping source="Dep12Description" target="Level 12 Description"
   addprefix="yes" /> 
   <mapping source="Dep13Value" target="Level 13 Code" addprefix="yes" /> 
   <mapping source="Dep13Description" target="Level 13 Description"
   addprefix="yes" /> 
   <mapping source="Dep14Value" target="Level 14 Code" addprefix="yes" /> 
   <mapping source="Dep14Description" target="Level 14 Description"
   addprefix="yes" /> 
   <mapping source="Dep15Value" target="Level 15 Code" addprefix="yes" /> 
   <mapping source="Dep15Description" target="Level 15 Description"
   addprefix="yes" /> 
   <mapping source="Dep16Value" target="Level 16 Code" addprefix="yes" /> 
   <mapping source="Dep16Description" target="Level 16 Description"
   addprefix="yes" /> 
   <mapping source="Dep17Value" target="Level 17 Code" addprefix="yes" /> 
   <mapping source="Dep17Description" target="Level 17 Description"
   addprefix="yes" /> 
   <mapping source="Dep18Value" target="Level 18 Code" addprefix="yes" /> 
   <mapping source="Dep18Description" target="Level 18 Description"
   addprefix="yes" /> 
   <mapping source="Dep19Value" target="Level 19 Code" addprefix="yes" /> 
   <mapping source="Dep19Description" target="Level 19 Description"
   addprefix="yes" /> 
   <mapping source="Dep20Value" target="Level 20 Code" addprefix="yes" /> 
   <mapping source="Dep20Description" target="Level 20 Description"
   addprefix="yes" /> 
   <mapping source="Dep21Value" target="Level 21 Code" addprefix="yes" /> 
   <mapping source="Dep21Description" target="Level 21 Description"
   addprefix="yes" /> 
   <mapping source="Dep22Value" target="Level 22 Code" addprefix="yes" /> 
   <mapping source="Dep22Description" target="Level 22 Description"
   addprefix="yes" /> 
   <mapping source="Dep23Value" target="Level 23 Code" addprefix="yes" /> 
   <mapping source="Dep23Description" target="Level 23 Description"
   addprefix="yes" /> 
   <mapping source="Dep24Value" target="Level 24 Code" addprefix="yes" /> 
   <mapping source="Dep24Description" target="Level 24 Description"
   addprefix="yes" /> 
   <mapping source="Dep25Value" target="Level 25 Code" addprefix="yes" /> 
   <mapping source="Dep25Description" target="Level 25 Description"
   addprefix="yes" /> 
   <mapping source="Dep26Value" target="Level 26 Code" addprefix="yes" /> 
   <mapping source="Dep26Description" target="Level 26 Description"
   addprefix="yes" /> 
   <mapping source="Dep27Value" target="Level 27 Code" addprefix="yes" /> 
   <mapping source="Dep27Description" target="Level 27 Description"
   addprefix="yes" /> 
   <mapping source="Dep28Value" target="Level 28 Code" addprefix="yes" /> 
   <mapping source="Dep28Description" target="Level 28 Description"
   addprefix="yes" /> 
   <mapping source="Dep29Value" target="Level 29 Code" addprefix="yes" /> 
   <mapping source="Dep29Description" target="Level 29 Description"
   addprefix="yes" /> 
   <mapping source="Dep30Value" target="Level 30 Code" addprefix="yes" /> 
   <mapping source="Dep30Description" target="Level 30 Description"
   addprefix="yes" /> 
   <mapping source="Dep31Value" target="Level 31 Code" addprefix="yes" /> 
   <mapping source="Dep31Description" target="Level 31 Description"
   addprefix="yes" /> 
   <mapping source="Distance" target="Fixed Hierarchy Level" addprefix="no" /> 
   <mapping source="VersionEffectiveStartDate" target="Effective From"
   addprefix="no" /> 
   <mapping source="VersionEffectiveEndDate" target="Effective To" addprefix="no"
   /> 
   <mapping source="Dep0FlexValueAttribute6" target="Group Account Number"
   addprefix="no" /> 
  </rule>
  <rule name="Qualified Segment Non-Tree Rule">
   <mapping source="Value" target="Code" addprefix="yes" /> 
   <mapping source="ValueSetCode" target="Value Set Code" addprefix="yes" />
   <mapping source="Description" target="Description" addprefix="yes" />
  </rule>
  <rule name="Role Playing KFF Tree Rule 1">
   <mapping source="TreeCode" target="Tree Code" addprefix="no" />
   <mapping source="TreeVersionId" target="Tree Version ID" addprefix="no" />
   <mapping source="Dep0Description" target="Description" addprefix="yes" />
   <mapping source="Dep0Pk2Value" target="Value Set Code" addprefix="yes" />
   <mapping source="Dep0Value" target="Code" addprefix="yes" />
   <mapping source="Value" target="Code" addprefix="yes" />
   <mapping source="ValueSetCode" target="Value Set Code" addprefix="yes" />
   <mapping source="Description" target="Description" addprefix="yes" />
  </rule>
  <rule name="Role Playing KFF Tree Rule 2">
   <mapping source="TreeCode" target="Tree Code" addprefix="no" />
   <mapping source="TreeVersionId" target="Tree Version ID" addprefix="no" />
   <mapping source="Dep0Description" target="Desscription" addprefix="yes" />
   <mapping source="Dep0Pk2Value" target="Value Set Code" addprefix="yes" />
   <mapping source="Dep0Value" target="Code" addprefix="yes" />
   <mapping source="Value" target="Code" addprefix="yes" />
   <mapping source="ValueSetCode" target="Value Set Code" addprefix="yes" />
   <mapping source="Description" target="Desscription" addprefix="yes" />
  </rule>
  <rule name="Role Playing KFF Tree Rule 3">
   <mapping source="TreeCode" target="Tree Code" addprefix="yes" />
   <mapping source="TreeVersionId" target="Tree Version ID" addprefix="yes" />
   <mapping source="Dep0Description" target="Description" addprefix="yes" />
   <mapping source="Dep0Pk2Value" target="Value Set Code" addprefix="yes" />
   <mapping source="Dep0Value" target="Code" addprefix="yes" />
   <mapping source="Value" target="Code" addprefix="yes" />
   <mapping source="ValueSetCode" target="Value Set Code" addprefix="yes" />
   <mapping source="Description" target="Description" addprefix="yes" />
  </rule>
  <rule name="Role Playing KFF Tree Rule 4">
   <mapping source="TreeCode" target="Tree Code" addprefix="no" /> 
   <mapping source="TreeVersionId" target="Tree Version ID" addprefix="no" /> 
   <mapping source="Dep0Description" target="Description" addprefix="yes" /> 
   <mapping source="Dep0Pk2Value" target="Natural Account Value Set Code"
 addprefix="no" /> 
   <mapping source="Dep0Value" target="Code" addprefix="yes" /> 
   <mapping source="Value" target="Code" addprefix="yes" /> 
   <mapping source="ValueSetCode" target="Natural Account Value Set Code"
   addprefix="no" /> 
   <mapping source="Description" target="Description" addprefix="yes" /> 
  </rule>
 </rules>
 <instances>

<!-- Each instance is associated with a single logical table. It applies any
number of rules, with an optional prefix. The rules are applied in order. Note
that the prefix includes a space at the end. It merely concatenates with the
target logical column to determine the right logical column to map to. -->

  <instance logicaltable="Dim - Balancing Segment">
   <apply rule="Qualified Segment Tree Rule" prefix="Balancing Segment" />
   <apply rule="Qualified Segment Non-Tree Rule" prefix="Balancing Segment" />
  </instance>
  <instance logicaltable="Dim - Cost Center">
   <apply rule="Qualified Segment Tree Rule" prefix="Cost Center" />
   <apply rule="Qualified Segment Non-Tree Rule" prefix="Cost Center" />
  </instance>
  <instance logicaltable="Dim - Natural Account Segment">
   <apply rule="Qualified Segment Tree Rule" prefix="Account" /> 
   <apply rule="Qualified Segment Non-Tree Rule" prefix="Account" /> 
  </instance>
  <instance logicaltable="Dim - GL Segment1">
   <apply rule="GL Segment Tree Rule" />
   <apply rule="GL Segment Non-Tree Rule" />
  </instance>
  <instance logicaltable="Dim - GL Segment2">
   <apply rule="GL Segment Tree Rule" />
   <apply rule="GL Segment Non-Tree Rule" />
   </instance>
  <instance logicaltable="Dim - GL Segment3">
   <apply rule="GL Segment Tree Rule" />
   <apply rule="GL Segment Non-Tree Rule" />
  </instance>
  <instance logicaltable="Dim - GL Segment4">
   <apply rule="GL Segment Tree Rule" />
   <apply rule="GL Segment Non-Tree Rule" />
  </instance>
  <instance logicaltable="Dim - GL Segment5">
   <apply rule="GL Segment Tree Rule" />
   <apply rule="GL Segment Non-Tree Rule" />
  </instance>
  <instance logicaltable="Dim - GL Segment6">
   <apply rule="GL Segment Tree Rule" />
   <apply rule="GL Segment Non-Tree Rule" />
  </instance>
  <instance logicaltable="Dim - GL Segment7">
   <apply rule="GL Segment Tree Rule" />
   <apply rule="GL Segment Non-Tree Rule" />
  </instance>
  <instance logicaltable="Dim - GL Segment8">
   <apply rule="GL Segment Tree Rule" />
   <apply rule="GL Segment Non-Tree Rule" />
  </instance>
  <instance logicaltable="Dim - GL Segment9">
   <apply rule="GL Segment Tree Rule" />
   <apply rule="GL Segment Non-Tree Rule" />
  </instance>
  <instance logicaltable="Dim - GL Segment10">
   <apply rule="GL Segment Tree Rule" />
   <apply rule="GL Segment Non-Tree Rule" />
  </instance>
  <instance logicaltable="Dim - AP Account Cost Center">
   <apply rule="Role Playing KFF Tree Rule 1" prefix="Cost Center" />
  </instance>
  <instance logicaltable="Dim - AP Asset Account Cost Center">
   <apply rule="Role Playing KFF Tree Rule 2" prefix="Cost Center" />
  </instance>
  <instance logicaltable="Dim - AP Pay Account Cost Center">
   <apply rule="Role Playing KFF Tree Rule 2" prefix="Cost Center" /> 
  </instance>
  <instance logicaltable="Dim - Asset From Cost Center">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Asset From Cost Center" /> 
  </instance>
  <instance logicaltable="Dim - Asset To Cost Center">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Asset To Cost Center" /> 
  </instance>
  <instance logicaltable="Dim - Asset Cost Center">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Asset Cost Center" /> 
  </instance>
  <instance logicaltable="Dim - Distribution Cost Center">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Distribution Cost Center" /> 
  </instance>
  <instance logicaltable="Dim - SLA Cost Center">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Cost Center" /> 
  </instance>
  <instance logicaltable="Dim - CE Asset Cost Center Value">
   <apply rule="Role Playing KFF Tree Rule 1" prefix="Cost Center" /> 
  </instance>
  <instance logicaltable="Dim - CE Offset Cost Center Value">
   <apply rule="Role Playing KFF Tree Rule 1" prefix="Cost Center" /> 
  </instance>
  <instance logicaltable="Dim - AP Account Balancing Segment">
   <apply rule="Role Playing KFF Tree Rule 1" prefix="Balancing Segment" /> 
  </instance>
  <instance logicaltable="Dim - AP Asset Account Balancing Segment">
   <apply rule="Role Playing KFF Tree Rule 1" prefix="Balancing Segment" /> 
  </instance>
  <instance logicaltable="Dim - AP Pay Account Balancing Segment">
   <apply rule="Role Playing KFF Tree Rule 1" prefix="Balancing Segment" /> 
  </instance>
  <instance logicaltable="Dim - Asset From Balancing Segment">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Asset From Balancing
   Segment" /> 
  </instance>
  <instance logicaltable="Dim - Asset To Balancing Segment">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Asset To Balancing Segment"
   /> 
  </instance>
  <instance logicaltable="Dim - Asset Balancing Segment">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Asset Balancing Segment" />
  </instance>
  <instance logicaltable="Dim - Distribution Balancing Segment">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Distribution Balancing
   Segment" /> 
  </instance>
  <instance logicaltable="Dim - SLA Balancing Segment">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Balancing Segment" /> 
  </instance>
  <instance logicaltable="Dim - CE Asset Balancing Segment Value">
   <apply rule="Role Playing KFF Tree Rule 1" prefix="Balancing Segment" /> 
  </instance>
  <instance logicaltable="Dim - CE Offset Balancing Segment Value">
   <apply rule="Role Playing KFF Tree Rule 1" prefix="Balancing Segment" /> 
  </instance>
  <instance logicaltable="Dim - AP Account Natural Account Segment">
   <apply rule="Role Playing KFF Tree Rule 4" prefix="Account" /> 
  </instance>
  <instance logicaltable="Dim - AP Asset Account Natural Account Segment">
   <apply rule="Role Playing KFF Tree Rule 4" prefix="Account" /> 
  </instance>
  <instance logicaltable="Dim - AP Pay Account Natural Account Segment">
   <apply rule="Role Playing KFF Tree Rule 4" prefix="Account" /> 
  </instance>
  <instance logicaltable="Dim - Asset From Natural Account Segment">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Asset From Natural Account"
   /> 
  </instance>
  <instance logicaltable="Dim - Asset Natural Account Segment">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Asset Natural Account" /> 
  </instance>
  <instance logicaltable="Dim - Asset To Natural Account Segment">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Asset To Natural Account" /> 
  </instance>
  <instance logicaltable="Dim - Distribution Natural Account Segment">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Distribution Natural
   Account" /> 
  </instance>
  <instance logicaltable="Dim - SLA Natural Account">
   <apply rule="Role Playing KFF Tree Rule 3" prefix="Account" /> 
  </instance>
  <instance logicaltable="Dim - CE Asset Natural Account Value">
   <apply rule="Role Playing KFF Tree Rule 4" prefix="Account" /> 
  </instance>
  <instance logicaltable="Dim - CE Offset Natural Account Value">
   <apply rule="Role Playing KFF Tree Rule 4" prefix="Account" /> 
  </instance>
 </instances>
</document>