Match Tables

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 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.