Oracle Error Message
ORA-37163: cannot delete or truncate AW with dependent CUBES or CUBE DIMENSIONS
Reason for the Error
User attempted to delete or truncate an AW which currently has a CUBE or CUBE DIMENSION defined over it
Solution
Drop the corresponding CUBE or CUBE DIMENSION before deleting the AW