Schematic Overview of an Example Reconciliation Report from
2two Sources
This schematic shows data from 2 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 of the other functionality for 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 and identify by identifying the 2 source systems and the dimensions that you wish to consolidate on in . In this case the Dimension "Account" is defined in both source systems and will be the only dimension to consolidate.
Select the appropriate dimension or dimensions from both Source systems
Define the List detail and identify in each individual line which dimension member you would like to include for that row, you must only speficy specify one dimension member from one source system on any individual row,.
Column List Definition
Will This will be defined as list type "Match" and will create the list and identify by identifying the 2 source systems and the dimensions that you wish to consolidate on in . In this case the Dimension dimension "Category" is defined in both source systems and will be the only dimension to Match against in each source system.
Select the Appropriate dimension or dimensions from both Source systems in this case Category exists in both source systems
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 system.
Report Dimensions
In addition to the normal report dimensions it will be necessary to specify the initialisation initialization dimensions for the second source system these . These will be either Follow Primary ie be the , meaning they are the same as the first source system, or be Fixed and set uniquely for the second source system
Set the Initialisation to either Follow Primary or Fixed for each dimension as appropriate for the report
Match Tables
Additionally a mapping between two members of different source systems can be created that is used in the POV of reports.
For instance, in case your first source system uses the Period member "Jan" for the month January and your second source system member "January", a mapping between these members results in a POV where selecting "Jan" will result in retreiving "Jan" data from the first source system and "January" data from the second source system.
To add a Match Table, go to System settings, select the tab of the source system that you want to map and select Match Tables.
In the pop-up window select the dimension of the members that you want to map, select the target source and click on add.
In the pop-up window select the source member, in this example "Jan" and the target member, in this example "January" and click on OK.
You have now added a Match Table that is used in the POV of reports.. 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