This section describes how WebFOCUS report columns can be bound to a symbol using a replaceable parameter (for example, COLOR).

In the sample application being used in this tutorial, the Color by Predictive Sales Map FOCEXEC (mp_sales.fex) uses shades of color on the map to represent predicted sales across the region, which are identified by Federal Information Processing Standard (FIPS) codes.

The Color by Predictive Sales Map FOCEXEC (mp_sales.fex) has an outbound layer configured, which uses the following symbol:

symColorByBusiness

The following image shows the properties for this symbol (symColorByBusiness).

Notice that the Color property is set to the color variable.

The following image shows the properties for the outbound layer that is defined for the Color by Predictive Sales Map FOCEXEC (mp_sales.fex).

Notice that the Symbol property is set to symColorByBusiness and the Color property is set to COLOR.

The following image shows a snapshot of the syntax that is used for the Color by Predictive Sales Map FOCEXEC (mp_sales.fex).

Results of the following logic is used by the symColorByBusiness symbol (through the color variable) to determine the color of the shaded regions on the generated map based on predicted sales.

COMPUTE COLOR/A20 = IF MAX.RETAIL.RETAIL.PREDICTED_SALES GE 3500 THEN 'RED'
ELSE IF MAX.RETAIL.RETAIL.PREDICTED_SALES GE 3300 THEN '25,69,0'
ELSE IF MAX.RETAIL.RETAIL.PREDICTED_SALES GE 3200 THEN 'ORANGE'
ELSE IF MAX.RETAIL.RETAIL.PREDICTED_SALES GE 3100 THEN '255,215,0'
ELSE IF MAX.RETAIL.RETAIL.PREDICTED_SALES GE 3000 THEN '25,140,0'
ELSE IF MAX.RETAIL.RETAIL.PREDICTED_SALES GE 2800 THEN '205,105,57'
ELSE IF MAX.RETAIL.RETAIL.PREDICTED_SALES GE 2600 THEN '227,207,87'
ELSE IF MAX.RETAIL.RETAIL.PREDICTED_SALES GE 2200 THEN '85,47,107'
ELSE IF MAX.RETAIL.RETAIL.PREDICTED_SALES GE 2000 THEN '173,255,47'
ELSE '220,220,220';