Mapping Analyst for Excel Guide

10.5
- 10.5.7
- 10.5.6
- 10.4.0

Back Next

Configuring the Rules Worksheet

Use the Rules worksheet to configure reusable rules that you can use as expressions on the Mappings worksheet.

Click

Metadata

Show and Hide

Max

to view all properties.

Enter the rule name in the Rule name column.

Select the source model name from the list of models defined on the Models worksheet.

Enter the name, datatype, and value of an input parameter.

If you defined domains on the Domains worksheet, you can select a domain name for the datatype.

Repeat step Configuring the Rules Worksheet to configure additional input parameters for the rule.

Select the target model name from the list of models defined on the Models worksheet.

Enter the name, datatype, and expression of an output result.

If you defined domains on the Domains worksheet, you can select a domain name for the datatype.

Repeat step Configuring the Rules Worksheet to configure additional output results for the rule.

Click

Metadata

Update and Check

Annotate

The mapping specification adds the business name, description, and datatypes for each model defined on the Models worksheet and each domain defined on the Domains worksheet.

After you configure the rule, enter the rule name as an expression on the Mappings worksheet for the appropriate source and target row. Use the following format: