When creating a member mapping for account Sales in Data Management, which statement is true regarding the use of a script?

• 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)

The statement regarding the use of a script in Data Management for account Sales being referenced in the In mapping type with #SQL as the target is accurate. In this context, the use of #SQL allows you to create a script that can manipulate or retrieve data during the mapping process. This capability is essential when there is a need to implement specific logic or conditions that are not covered by standard mapping functionalities.

Using #SQL in the In mapping type enhances the flexibility of data mappings by enabling complex queries or logic that can consider factors such as account balances, specific product attributes, or conditions that result in nuanced mapping scenarios. It gives the capability to define custom behaviors based on the data, making it a powerful tool in the Data Management process.

The other options either underestimate the utility of scripts in this context or misinterpret the requirements for member mapping with respect to Data Management capabilities. Scripts, particularly those using #SQL, are a legitimate method for achieving the desired data manipulation and mapping results.