The DERIVED_PROP element in the Derived_props.xml file specifies a derived property.
The attributes of the
DERIVED_PROP element are:
DERIVE_FROMspecifies the property or dimension from which the derived property will be calculated.FCNspecifies the function to be applied to theDERIVE_FROMproperties of the aggregated record. Valid functions areMIN,MAX,AVG, orSUM. Any dimension or property type can be used with theMINorMAXfunctions. OnlyINTEGERorFLOATproperties may be used inAVGandSUMfunctions.NAMEspecifies the name of the derived property. This name can be the same as theDERIVE_FROMattribute.
The following is an example of the XML element that defines the derived property described in the book example above:
<DERIVED_PROP DERIVE_FROM="PRICE" FCN="MIN" NAME="LOW_PRICE" />
Similarly, a derived property can derive from dimension values, if the
dimension name is specified in the
DERIVE_FROM attribute. In addition, the function
attribute (FCN) can be
MAX,
AVG, or
SUM, depending on the desired behavior.
Note
Developer Studio currently does not support configuring derived
properties. The workaround is to edit the
Derived_props.xml file to add the
DERIVED_PROP element. For information about
Derived_props.xml, refer to the
Oracle Commerce Guide Search Platform Services XML Guide.
