ORA-36180 (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
March 20th, 2009
Description:
ORA-36180 (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
Cause:
When using AGGREGATE, only simple permissions and permissions on base dimensions are valid.
Remove the permissions clause from the variable causing problems.