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.