Conditional Mapping

With conditional mapping, source members are mapped to script expressions rather than to hard-coded target members. Conditional mapping is valid only for rule-based mapping (Between, In, and Like). You can activate conditional mapping by placing #SCRIPT or #SQL in the Target value column. Use #SCRIPT for Jython Script and #SQL for SQL script. Conditional mapping, in conjunction with dimension processing order, enables mapping that is based on the results of dimension mappings. That is, dimension mappings that have already been processed. See Using Mapping Scripts.