The AGGROPS function returns the keywords for all of the aggregation operators that you can specify in a RELATION (for aggregation) statement, listed one name on each line in a multiline text value.
Example 7-10 Displaying a List of the Aggregation Operators
When you issue an AGGROPS statement, Oracle OLAP returns a list of all of the aggregation operators.
SHOW AGGROPS SUM WSUM SSUM AND OR FIRST LAST HFIRST HLAST AVERAGE WAVERAGE HAVERAGE HWAVERAGE MIN MAX WFIRST WLAST HWFIRST HWLAST WMIN WMAX NOAGG