This appendix provides reference information for the operators and functions that are allowed in server expressions.
This chapter covers the following topics:
You can use the following SQL functions in a Oracle server expression:
For details on these functions, consult the appropriate Oracle database documentation.
You can use the following operators in a Oracle server expression:
+
-
*
/
()
<
<=
<>
=
>
>=
And
Else
In
Not
Or
Then
When
Calculations follow standard algebraic rules of precedence.
You can use the following special-purpose tokens in a Oracle server expression:
Token | Allowed in | Automatically replaced by |
---|---|---|
#CONFIDENCE_LEVEL# | Server expressions | Confidence level associated with the forecast. Not supported in the Web user interfaces. |
#FDATE@<Version>@<Profile_id># | Series hint messages | Date of the specified engine profile’s forecast version*. For example,#FDATE@0@25# is replaced by the date on which current forecast for engine profile 25 was generated. |
#FORE@<Version>@<Profile_id># | Server expressions | The specified forecast version*. For example: #FORE@1@25# is replaced by the second most current forecast version generated using engine profile 25. |
#POST_EFFECT@<Version>@<Profile_id># | PE server expressions | The post-promotional effect associated with the specified forecast version generated using a specified engine profile. * |
#PRE_EFFECT@<Version>@<Profile_id># | PE server expressions | The pre-promotional effect associated with the specified forecast version generated using a specified engine profile. * |
#SIMULATION_TABLE# | Server expressions | . |
#SW_BRAND@<Version>@<Profile_id># | PE server expressions | The brand switching associated with the specified forecast version generated using a specified engine profile. * |
#SW_CHANNEL@<Version>@<Profile_id># | PE server expressions | The channel switching associated with the specified forecast version generated using a specified engine profile * |
#SW_PRODUCT@<Version>@<Profile_id># | PE server expressions | The product switching associated with the specified forecast version. * |
#SW_STORE@<Version>@<Profile_id># | PE server expressions | The store switching associated with the specified forecast version generated using a specified engine profile. *. |
#UNIT# | Server expressions | The unit conversion factor that corresponds to the unit used in the worksheet. See “Configuring Units, Indexes, and Update-Lock Expressions”. |
#UPLIFT@<Version>@<Profile_id># | PE server expressions | The uplift associated with the specified forecast version generated using a specified engine profile. * |
* The most recent forecast is 0, the previous forecast is 1, and so on. |