Considerations for Target Selections

Note the following behavior of target selections:

• Data push and smart push are driven based on the source selections.

• The target selection for mapped dimensions is used for populating the target members for detailed member to member mappings.

• Based on the source selection and member mappings, data can be moved to target members outside the scope of the target section. For example, if the source selection in ILvl0Descendants(YearTotal) and target selection is ILvl0Descendants(YearTotal) with a target exclusion as Dec, the detailed mapping page populates Dec in the source with no member in the target. When you save the data map, the systems warns that Dec is not mapped and the data map may not work correctly. If Dec from the source is mapped to some other member in the target, then data is moved to that member instead on Dec.

• If you don't want to move data to a certain member in the target, then you must define this by either using an exclude member on the source selection or member mappings.

• The target clear region on the target is derived from the source selection and mapping.

• If you want to restrict selections in the target region to specific members and you can't achieve this by way of source selection, use the Use target selection to clear and restrict data option. This option enables you to exclude members in the target region.

• If needed, you can revert the target selections to the default option by using the Use target selection only for mapping option. In this case, the exclusion selection defined on the target selection for the mapping group is removed.

• When there are multiple dimensions in the target, then the data map can only be run with the clear option if the Use target selection to clear and restrict data option is selected for multiple dimensions.

• When the Use target selection to clear and restrict data is selected, then the selection for each of the target dimensions with this option is used "as is " to define the target region. Source selection and mappings are not considered for the clear.

• As the target selection is used "as is" without any changes, then the target selection has to be defined correctly to exclude dynamic calc members for an ASO cube.

• If the target selection is a dimension name, then the data of all its descendants is included. For example, when all months must participate in the clear, then the target selection should be ILvl0Descendants(YearTotal) or ILvl0Descendants(Period) based on the business use case, instead of Period.