Edit Domain Member Mappings Dialog

Use this dialog to map source domain members to target domain members. You can also use this dialog to change the default member mappings to meet your business requirements.

For example, in a Country source domain, you might want 'AE United Arab Emirates' to map to the code value 'AE' in Oracle Business Analytics Warehouse.

For ranged (or banded) domains, you can use this dialog to edit and create ranges. For example, you might want to increase an existing performance range from 1 - 100 to 1 - 200. Or, you might want to create a new performance range called Performance_Range_6 and map values between 500 and 1000 to Performance_Range_6.

Tip:

If you start to add a new Range Member Mapping then click Cancel, before you can cancel the dialog you must specify a value in every field. In other words, if you specify a value in the Range Start field and Range End field but not the Code field, an error message is displayed when you click Cancel. To cancel the dialog, you must first specify a value in every field before you click Cancel.

Element	Description
Sync to Source	Use this option to synchronize the domain members in Oracle Business Analytics Warehouse with the domain members in the source system. This process automatically inserts target members from the source domain, and automatically generates 1:1 mappings for the currently selected domain. This option does not override existing member mappings. When you click Sync to Source, a Warning dialog is displayed that prompts you to either click OK to continue or click Cancel to stop the synchronization process. If you click OK to continue, then you commit changes to the target Domain members, even if you do not click Save or click Save and Close. This option becomes grayed out if you start to edit mappings (for example, if you select a value from the Code drop-down list), until you click Save, or you click Cancel then relaunch the dialog.
Batch Edit	Use this field (and the accompanying Change button) to update multiple Target Domain Member Mappings with the same value. Select one or more member mappings in the Source Domain Member list, select a value from the Batch Edit drop-down list, then click Change. All Target Domain Members will be updated with the value selected.
Change	Use this option to apply the value selected in the Batch Edit drop-down list to all target domains members currently selected. Note: If you click Change erroneously, then click Cancel to undo the changes and close the Edit Domain Member Mappings dialog.
Add Range Member Mapping (+ icon).	Use this option to add a new Domain Member Mapping. Click the + icon to display a new row in the table, containing blank fields, which you use to specify the details of the new range. Note: This option is only available for Domains for which you can specify ranges. For example, a Performance Percentile domain in a HR application might have the ranges: 0 - 100 as Performance Range 1, and 101 - 200 as Performance Range 2. If this option is grayed out, then the target Domain is non-extensible (contact your BI administrator). If you start to add a new Range Member Mapping then click Cancel, before you can cancel the dialog you must specify a value in every field. In other words, if you specify a value in the Range Start field and Range End field but not the Code field, an error message is displayed when you click Cancel. To cancel the dialog, you must first specify a value in every field, then click Cancel again. If you want to assign a new range to a new category (for example, to Performance Range 3), then before you create the new range you must first use the Add Warehouse Member option to create the new category.
Source Members	This option is only available for non-ranged Domain Member Mappings. Use this drop-down list to change the type of domains displayed. Select Unmapped to display only source domains that are not mapped to target domains. Select Mapped to display only source domains that are mapped to target domains. The default value All displays both mapped and unmapped domains. If you selected a value in the Source Members field on the Manage Domain Mappings and Hierarchies: Domain Mappings tab, then that selection does not persist to this dialog. For example, if you selected Not Mapped in the Source Members field, then by default this dialog displays both Mapped and Unmapped values.
Add Target Domain Member	Use this option to display the Add Warehouse Domain Member/Add Target Domain Member dialog, which enables you to create a new target mapping value. This dialog prompts you to specify a Code, Name, and Description (optional) for the new target mapping. For example, if you have a Performance Percentile domain in a HR application with the ranges: 0 - 100 as Performance Range 1, and 101 - 200 as Performance Range 2, then you might want to create a category (or Range) called Performance Range 3, to which you can map a new range. Or, you might want to create a new domain called Payment Method in a Financial application. If this option is grayed out, then the target Domain is non-extensible (contact your BI administrator).
Source Domain Member	The list of Source Domain Members for the Source Domain.
Target Domain Member	This column value displays the mapped Warehouse or Target member value for the Source Domain Member displayed in the Source Domain Member column. Use the lists in the Code column to change the target domain member to which the adjacent Source Domain Member value is mapped. For example, if you have used the Add Warehouse Member button to create a new target category (or Range) called '> 2000', you might want to select '> 2000' for the range that is specified with Range Start = 2000 and Range End =10,000.