Conditional Mapping Example

Assume that the Account and Entity dimensions process prior to the ICP dimension and that the ICP dimension uses a conditional mapping rule. In this case, when the ICP dimension is processed, the varValues array contains the mapped values for Account and Entity, and the mapped values for all other dimensions are null.

The image depicts the Maps screen showing an example of a conditional mapping using a script.

The ICP conditional script evaluates the mapped value of the Account dimension and determines how to map ICP.

‘Check element 14 of the varValue array to get converted/mapped account
If varValues(14) = “InterCoAP” Then
	‘Mapped value = “InterCoAP” map to Michigan
	Result = “[Michigan]”
Else
	‘All others, map to none
	Result = “[ICP None]”
End If