Nearly the same functionality is provided for creating expert options as for creating variables. The same SQL elements are supported with the following exceptions and additions:
- Aggregations — Aggregations can only be used in the Having Clause.
- Ordered Analytical Functions — Ordered Analytical functions can only be used in the Qualify Clause.
- Other - Expert — A number of SQL Elements are available for expert options that are not available for creating variables or dimensions.