Oracle Error ORA-36180: (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.

Oracle Error Message

ORA-36180: (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.

Reason for the Error

When using AGGREGATE, only simple permissions and permissions on base dimensions are valid.

Solution

Remove the permissions clause from the variable causing problems.