When creating a member mapping for account Sales in Data Management, the following script is entered. UD5 refers to a Product custom dimension: WHEN UD5 LIKE 'CAR_%' THEN 'AUTO_SALES'ELSE 'SALES'Which statement is True?

• A. The script can be eliminated by using a multi-dim map on the Product dimension that also looks for the account Sales.
• B. The script will work if the script is referenced in the In mapping type with #SQL as the target.
• C. The script will not work since Data Management does not support scripting.
• D. The script will not work since the UD5 member referenced does not start with FCCS_

Answer: (B)

In Data Management, you can use SQL-style expressions in a member mapping by setting the target to #SQL. The script shown is a simple conditional expression: if UD5 matches the pattern CAR_%, the mapped product becomes AUTO_SALES; otherwise it becomes SALES. By referencing this script in an In mapping with #SQL as the target, Data Management evaluates the expression for each UD5 value and assigns the corresponding Product dimension member. That’s why this approach works—the mapping engine is designed to evaluate such SQL-like logic when the target is #SQL.

The other statements aren’t correct because Data Management does support scripting through #SQL, so claiming scripting isn’t supported is false; the idea of eliminating the script with a multi-dim map isn’t what the question tests; and there’s no requirement that UD5 values must start with FCCS_.