Oracle Error ORA-36184: (XSAGGR10) You do not have sufficient permissions for the variable workspace object.

Oracle Error Message

ORA-36184: (XSAGGR10) You do not have sufficient permissions for the variable workspace object.

Reason for the Error

The user lacked the permissions necessary for the aggregation variable.

Solution

Remove the restricting permissions from the variable or base dimension.