Introduction

Your CXO application may contain one or more Source Systems and you may want to create a report that comprises of data from two or more of these sources. The report may also be for a table only using either the Multi-Column template or a Table Control element within a generic template.

You will need to specify some special lists such as Match and Consolidated and ensure that the relevant source data from each source system is identified both within the relevant lists (both Row and Column) and within the report dimensions.

CONTENT

Schematic Overview of an Example Reconciliation Report from two Sources

This schematic shows data from two source systems both defined in one CXO application being combined into a single Multi Source Report.

Report Definition

The Multi Column Report or Table component will need 2 lists. One list will need to be of the type Match as defined in the maintain list dialog and one of the type Consolidated. These lists will then be used as the Row and Column content for the report.

All other functionality of a Multi Column report or Table control will be available.

Row List Definition

Will be defined as list type "Consolidated" and create the list by identifying the 2 source systems and the dimensions that you wish to consolidate on. In this case the Dimension "Account" is defined in both source systems and will be the only dimension to consolidate.

Define the List detail and identify in each individual line which dimension member you would like to include for that row, you must only specify one dimension member from one source system on any individual row.

Column List Definition

This will be defined as list type "Match" and will create the list by identifying the 2 source systems and the dimensions that you wish to consolidate on. In this case the dimension "Category" is defined in both source systems and will be the only dimension to Match against in each source system.

Define the List detail and identify in each individual row which dimension member or members you would like to include for that row, you must specify for each source system which dimension member you would like to match against from each source.

Report Dimensions

In addition to the normal report dimensions it will be necessary to specify the initialization dimensions for the second source system. These will be either Follow Primary, meaning they are the same as the first source system, or be Fixed and set uniquely for the second source system. This is set in Source System Defaults.

Multi Source Reports

The following reports are multi source capable.

Multi Column Report
Financial Statement Report
Multiple Bar and Line Charts Report
Value Tree Report

Multi Source Objects

The following objects which can be used in Free Format Reports or Templates are multi source capable.

Table Object
Bars and Lines Object
Bridge Object
Value Tree object