Link to the source system from the Intercompany Matching Detail reports

If the drillback custom settings are configured in EPM Administration, you can jump to the source system, for example, Infor M3 or Infor LN from the Intercompany Matching Detail reports to verify the intercompany matching values in the source system.

To jump to the source system, click a value in the Group Currency (currency ISO code) column for a specific account and select the link to the source system. The appropriate report is displayed in the source system with the context parameters inherited from the Intercompany Matching Detail report.

Your administrator can configure the drillback custom settings by performing these steps:

  1. Select EPM Administration > Dashboards > Applications Administration > Custom Settings.
  2. Select EPM Business Applications in the Application field.
  3. Specify a value for each applicable drillback custom setting.

drillback_screen_mapping custom setting

The mapping between the Intercompany Matching Detail reports and the source system.

The .xml file has these characteristics:

  • Row names correspond to the REPORTUN column values of the Intercompany Matching Detail reports.
  • The number assigned to the value property name must be identical for both Intercompany Matching Detail reports. The number refers to the equivalent number (X) in the drillbackX_process and drillbackX_parameters custom settings. The value property represents a single drillback value.
  • The value_title property name refers to the label that is displayed as a link to select in the Intercompany Matching Detail reports.

The sample value for the drillback_screen_mapping custom setting is:

<Table>
  <Row name="co_Dashb_Reconc_ICMatchingDetail_Debts">
    <Property name="value" value="1" />
    <Property name="value_title" value="Drillback"/>
</Row>
  <Row name="co_Dashb_Reconc_ICMatchingDetail_Revenues">
    <Property name="value" value="1" />
    <Property name="value_title" value="Drillback"/>
  </Row>
</Table>

drillbackX_process custom setting

X stands for a number from 1 to 3. You can define up to three different drillback actions. Each action contains a pair of the drillbackX_process and drillbackX_parameters settings. The settings used for the same drillback action must contain the same number. For example, drillback1_process is used with drillback1_parameters.

The setting requires the name of the Application Engine process that is run to generate the drillback .xml file. The process must accept these string elements:

  • Data connection name
  • Cube name
  • XML slicers
  • Parameters

Currently, this setting has a fixed "DrillbackBasedOnTemplate" value. To view the value, select EPM Business Applications in Application Studio.

The drillback .xml file that is defined in the corresponding drillbackX_parameters setting is modified by the "DrillbackBasedOnTemplate" process based on the context selected in an Intercompany Matching Detail report. This results in an .xml output. In the output, the placeholders in drillbackX_parameters setting are replaced with the corresponding context data.

The sample value for the drillbackX_process custom setting is based on "DrillbackBasedOnTemplate".

drillbackX_parameters custom setting

A template with the logical ID, screen to which to jump, and parameters with placeholders that are replaced with the actual context from the report by the Application Engine process.

The placeholders within the curly brackets ({ }) are replaced with real values by the drillbackX_process setting. For example, the date format that is used by Infor EPM (MM.YYYY) is converted into the source system's date format indicated by the extension of the DTIME placeholder. Another example is the DCOMPC.CST placeholder that allows for mapping entities in Infor EPM to the source system. The DCOMPC.CST placeholder's extension determines whether the source system's company ID or division ID is displayed.

In drillbackX_parameters, X stands for a number from 1 to 3. You can define up to three different drillback actions. Each action contains a pair of the drillbackX_process and drillbackX_parameters settings. The settings used for the same drillback action must contain the same number. For example, drillback1_process is used with drillback1_parameters.

The drillback .xml varies depending on the source system configuration.

The sample value for the drillbackX_parameters custom setting for Infor M3 is:

<Table>
<Row name="LogicalId">
<Property name="value" value="lid://infor.m3.m3" />
</Row>
<Row name="program">
<Property name="value" value="GLS215" />
</Row>
<Row name="tableName">
<Property name="value" value="FBAKEY" />
</Row>
<Row name="keys">
<Property name="value" value="RKCONO,{DCOMPC.CST_M3CONO},RKDIVI,{DCOMPC.CST_M3DIVI},RKBAKY,1,RKBIT1,++++,RKBIT2,++++++++,RKBIT3,++++++++,RKBIT4,++++++++,RKBIT5,++++++++,RKBIT6,++++++++,RKBIT7,+++++++++" />
</Row>
  <Row name="parameters">
 <Property name="value" value="WWACPE,{DTIME:YYMM},WWCTPI,101" />
</Row>
  <Row name="fields">
    <Property name="value" value="WWACPE,{DTIME:YYMM},WWBAKY,1,WWCTPI,101,WWCUCD,{DGCURR},WWCRTP,1,W0BI1F,{DACOUNT.CST_M3FROM},W0BI1T,{DACOUNT.CST_M3TO}" />
  </Row>
</Table>

The sample value for the drillbackX_parameters custom setting for Infor LN is:

<Table>
<Row name="LogicalId">
<Property name="value" value="lid://infor.ln.ln01/{DCOMPC.CST_LNID}"/>
</Row>
<Row name="ViewID">
<Property name="value" value="GeneralLedgerWB_Transactions"/>
</Row>
<Row name="AccountingEntity">
<Property name="value" value="{DCOMPC.CST_LNID}"/>
</Row>
<Row name="CurrencyPosition">
<Property name="value" value="local"/>
</Row>
<Row name="AllCompanies">
<Property name="value" value="false"/>
</Row>
<Row name="Company">
<Property name="value" value="{DCOMPC.CST_LNID}"/>
</Row>
<Row name="PeriodType">
<Property name="value" value="fiscal"/>
</Row>
<Row name="SelectionYear">
<Property name="value" value="{DTIME:YYYY}"/>
</Row>
<Row name="SelectionPeriodFrom">
<Property name="value" value="{DTIME:MM}"/>
</Row>
<Row name="SelectionPeriodTo">
<Property name="value" value="{DTIME:MM}"/>
</Row>
<Row name="AccountingScheme">
<Property name="value" value="statutory"/>
</Row>
<Row name="IncludeNonFinalized">
<Property name="value" value="false"/>
</Row>
<Row name="ReportingCurrency">
<Property name="value" value="{DGCURR}"/>
</Row>
<Row name="TransactionCategory">
<Property name="value" value="movements"/>
</Row>
<Row name="DebitCredit">
<Property name="value" value="both"/>
</Row>
<Row name="LedgerAccount">{DACOUNT.CST_LN_List}"/>
</Row>
</Table>