app_segment_rules_*.xml Example
You can review an example of an app_segment_rules_*.xml file, based on the validation rules contained in app_segment_rules.xsd.
The app_segment_rules_*.xml file has been shortened for this example.
<?xml version="1.0" encoding="UTF-8" ?> <document> <!-- Begin Finance --> <MappingRules appName="FscmTopModelAM.AccountBIAM" businessModelName="Core" flattenedFlexLogicalTable="Dim - GL Account"> <GlobalOTBISubjectAreas> <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" /> ... </GlobalOTBISubjectAreas> <LabelToDimensionMappings logicalDimTableName="Dim - Balancing Segment"> <FlattenedFlexVOColumnMappings> <ColumnMapping voColumnName="_" logicalDimColumnName="Balancing Segment Code" /> <ColumnMapping voColumnName="_c" logicalDimColumnName="Balancing Segment Value Set Code" /> </FlattenedFlexVOColumnMappings> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="General Ledger - Journals Real Time" table="- Balancing Segment" /> <OTBISubjectArea subjectAreaName="General Ledger - Transactional Balances Real Time" table="Balancing Segment" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Prepayment Invoice Distributions Real Time" table="- Balancing Segment" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Transactions Real Time" table= "- Balancing Segment" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Trial Balance Real Time" table="Balancing Segment" /> ... </TableSpecificOTBISubjectAreas> </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> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="General Ledger - Journals Real Time" table="- Cost Center Segment" /> <OTBISubjectArea subjectAreaName="General Ledger - Transactional Balances Real Time" table="Cost Center Segment" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Prepayment Invoice Distributions Real Time" table="- Cost Center" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Transactions Real Time" table="- Cost Center" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Trial Balance Real Time" table="Cost Center" /> ... </TableSpecificOTBISubjectAreas> </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> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="General Ledger - Journals Real Time" table="- Natural Account Segment" /> <OTBISubjectArea subjectAreaName="General Ledger - Transactional Balances Real Time" table="Natural Account Segment" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Prepayment Invoice Distributions Real Time" table="- Natural Account" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Transactions Real Time" table= "- Natural Account" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Trial Balance Real Time" table="Natural Account" /> ... </TableSpecificOTBISubjectAreas> </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 - AP Account Balancing Segment" roleMasterLogicalTableName="Dim - Balancing Segment" flattenedFlexVORoleAlias="Dim_FLEX_BI_ Account_VI_APAccount"> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="Payables Invoices - Prepayment Invoice Distributions Real Time" table="- Distribution Balancing Segment Value" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Transactions Real Time" table="- Distribution Balancing Segment Value" /> </TableSpecificOTBISubjectAreas> </LabelToDimensionMappings> <LabelToDimensionMappings logicalDimTableName="Dim - AP Account Cost Center" roleMasterLogicalTableName="Dim - Cost Center" flattenedFlexVORoleAlias="Dim_FLEX_BI_ Account_VI_APAccount"> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="Payables Invoices - Prepayment Invoice Distributions Real Time" table="- Distribution Cost Center Segment Value" /> <OTBISubjectArea subjectAreaName="Payables Invoices - Transactions Real Time" table="- Distribution Cost Center Segment Value" /> </TableSpecificOTBISubjectAreas> </LabelToDimensionMappings> ... </MappingRules> <MappingRules appName="FscmTopModelAM.LocationBIAM" businessModelName="Core" flattenedFlexLogicalTable="Dim - Asset Location"> <LabelToDimensionMappings logicalDimTableName="Segment1"> <FlattenedFlexVOColumnMappings> <ColumnMapping voColumnName="_" logicalDimColumnName="Segment1" /> </FlattenedFlexVOColumnMappings> </LabelToDimensionMappings> <LabelToDimensionMappings logicalDimTableName="Segment2"> <FlattenedFlexVOColumnMappings> <ColumnMapping voColumnName="_" logicalDimColumnName="Segment2" /> </FlattenedFlexVOColumnMappings> </LabelToDimensionMappings> ... </MappingRules> <MappingRules appName="FscmTopModelAM.CategoryBIAM" businessModelName="Core" flattenedFlexLogicalTable="Dim - Asset Category"> <LabelToDimensionMappings logicalDimTableName="Segment1"> <FlattenedFlexVOColumnMappings> <ColumnMapping voColumnName="_" logicalDimColumnName="Segment1" /> </FlattenedFlexVOColumnMappings> </LabelToDimensionMappings> <LabelToDimensionMappings logicalDimTableName="Segment2"> <FlattenedFlexVOColumnMappings> <ColumnMapping voColumnName="_" logicalDimColumnName="Segment2" /> </FlattenedFlexVOColumnMappings> </LabelToDimensionMappings> ... <LabelToDimensionMappings logicalDimTableName="Major Category"> <FlattenedFlexVOColumnMappings> <ColumnMapping voColumnName="_" logicalDimColumnName="Major Category" /> </FlattenedFlexVOColumnMappings> </LabelToDimensionMappings> <LabelToDimensionMappings logicalDimTableName="Minor Category"> <FlattenedFlexVOColumnMappings> <ColumnMapping voColumnName="_" logicalDimColumnName="Minor Category" /> </FlattenedFlexVOColumnMappings> </LabelToDimensionMappings> </MappingRules> ... <MappingRules appName="FscmTopModelAM.ExternalTransactionBIAM" businessModelName="Core" flattenedFlexLogicalTable=""> <!-- Use the below tag if you want any one of the following use cases for the "base logical table" your DFF is mapped to in ATG --> <!-- (a) need to expose the base logical table DFF attributes to specific presentation subject area and table --> <!-- (b) you have additional VO aliases mapped to the base logical table in addition to the base VO itself --> <!-- (c) you have additional "related logical tables" that you want automapped when the base logical table is mapped in ATG --> <LabelToDimensionMappings logicalDimTableName="Dim - CE External Cash Transaction Details"> <!-- Use the below tag to indicate the presentation subject area and table where the DFF attributes need to be exposed --> <!-- Repeat the OTBISubjectArea tag to expose them in multiple subject areas or tables --> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="Cash Management - External Cash Transactions Real Time" table="External Cash Transaction Detail" /> </TableSpecificOTBISubjectAreas> <!-- Use the below tag to give the VO alias names, if any, that are mapped to the base logical table in addition to the base VO --> <!-- Repeat the AliasTable tag if you have multiple VO aliases --> <DFFBaseVOAliases> <AliasTable aliasTableName="Fact_ExternalTransactionsPVO_JournalEntryLine" /> </DFFBaseVOAliases> </LabelToDimensionMappings> </MappingRules> ... <MappingRules appName="FscmTopModelAM.CalendarTypeDFFBIAM" businessModelName="Core" flattenedFlexLogicalTable=""> ... <LabelToDimensionMappings logicalDimTableName="Dim - Date Fixed Assets Calendar"> ... <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="Fixed Assets - Asset Transactions Real Time" table="Transaction Effective Date" /> </TableSpecificOTBISubjectAreas> </LabelToDimensionMappings> <!-- Use the below tag if you have any "role-playing logical tables" for the base logical table. --> <LabelToDimensionMappings logicalDimTableName="Dim - Date Placed in Service Fixed Asset Calendar" roleMasterLogicalTableName="Dim - Date Fixed Assets Calendar" flattenedFlexVORoleAlias="Dim_CalendarDayPVO_DatePlacedInService"> <!-- Use the below tag to indicate the presentation subject area and table where the DFF attributes from the role-playig logical table need to be exposed --> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="Fixed Assets - Asset Financial Information Real Time" table="Date Placed in Service" /> </TableSpecificOTBISubjectAreas> </LabelToDimensionMappings> <LabelToDimensionMappings logicalDimTableName="Dim - Transaction Date Fixed Asset Calendar" roleMasterLogicalTableName="Dim - Date Fixed Assets Calendar" flattenedFlexVORoleAlias="Dim_ CalendarDayPVO_TransactionDate"> <!-- Use the below tag to indicate the presentation subject area and table where the DFF attributes from the role-playing logical table need to be exposed --> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="Fixed Assets - Asset Assignments Real Time" table="Transaction Date" /> <OTBISubjectArea subjectAreaName="Fixed Assets - Asset Financial Information Real Time" table="Transaction Date" /> <OTBISubjectArea subjectAreaName="Fixed Assets - Asset Retirements and Reinstatements Real Time" table="Transaction Date" /> <OTBISubjectArea subjectAreaName="Fixed Assets - Asset Transactions Real Time" table="Transaction Date" /> <OTBISubjectArea subjectAreaName="Fixed Assets - Asset Transfer Real Time" table="Transaction Date" /> </TableSpecificOTBISubjectAreas> </LabelToDimensionMappings> ... </MappingRules> ... <!-- Rule file for AP_TERMS_B --> <MappingRules appName="FscmTopModelAM.PaymentTermHeaderDffBIAM" businessModelName="Core" flattenedFlexLogicalTable=""> <LabelToDimensionMappings logicalDimTableName="Dim - AP Terms"> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="Payables Invoices - Transactions Real Time" table= "- Header Information" /> </TableSpecificOTBISubjectAreas> </LabelToDimensionMappings> </MappingRules> <!-- Rule file for AP_PAYMENT_SCHEDULES --> <MappingRules appName="FscmTopModelAM.InstallmentsDffBIAM" businessModelName="Core" flattenedFlexLogicalTable=""> <LabelToDimensionMappings logicalDimTableName="Dim - AP Payment Schedule Details"> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="Payables Invoices - Installments Real Time" table="Invoices Installment Details" /> </TableSpecificOTBISubjectAreas> <DFFBaseVOAliases> <AliasTable aliasTableName="Fact_InvoicePaymentSchedulePVO_Disbursement" /> </DFFBaseVOAliases> </LabelToDimensionMappings> </MappingRules> ... <!-- Rule file for DFF AP_HOLDS --> <MappingRules appName="FscmTopModelAM.HoldsDffBIAM" businessModelName="Core" flattenedFlexLogicalTable=""> <LabelToDimensionMappings logicalDimTableName="Dim - AP Hold Details"> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="Payables Invoices - Holds Real Time" table="Invoices Hold Details" /> </TableSpecificOTBISubjectAreas> </LabelToDimensionMappings> </MappingRules> <!-- End Finance --> <!-- Rule file for JobAM EFF --> </MappingRules> <MappingRules appName="HcmTopModelAnalyticsGlobalAM.JobAM.PER_JOBS_LEG_EFF" businessModelName="Core" flattenedFlexLogicalTable=""> <LabelToDimensionMappings logicalDimTableName="Dim - Job"> <TableSpecificOTBISubjectAreas> <OTBISubjectArea subjectAreaName="Workforce Management - Worker Assignment Real Time" table="Job" /> </TableSpecificOTBISubjectAreas> </LabelToDimensionMappings> </MappingRules> ... </document>