Using an OLAP DML Function: This screen capture shows the definition of a calculated measure using an OLAP DML function. The following fields and their values on the Create a Calculated Measure dialog box are shown:

• Calculation Type: OLAP DML Function

• Data Type: VARCHAR2

• Function Name: PRODUCT_ALERT_PRG

• Program Body: Code from the program listed previously

The Compile Function button is at the bottom.