Source System Matches

Mapping between two members of different source systems can be created that is used in the POV of reports. These mappings are required when members in different source systems have different names, but the same meaning (like shown in the example below). If the members have identical names, they will be automatically matched and no entry in the match table is required. Members from different versions are matched automatically when they have the same name, if there are two members with different names but the same meaning, then you would add it to a match table.

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 Tools → Source System Matches.

In the window select 'New Match'

Select the dimension that you want to create a match for.

 In the pop-up window select the source member, in this example "Feb" and the target member, in this example "February" and click on Save.

 You have now added a Match Table that is used in the POV of reports.