Oracle Error ORA-36995: (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.

Oracle Error Message

ORA-36995: (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.

Reason for the Error

more than 1 hierarchies in the current computing scope.

Solution

use inhierarchy to limit