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

ERROR(XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
CAUSEWhen using AGGREGATE, only simple permissions and permissions on base dimensions are valid.
ACTIONRemove the permissions clause from the variable causing problems.