Oracle Solution for Error ora-36608

ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite dimension in AGGREGATE caused a counter overflow.

What triggered the Error:

The depth of the hierarchies that are part of a composite exceeded 4 billion levels during the merge.

What should we do to fix it:

Reduce the number of levels in the hierarchies, reduce the number of dimensions in the composite, or do not aggregate over all dimensions at once.