Oracle Error ORA-36992: (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.

Oracle Error Message

ORA-36992: (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.

Reason for the Error

A level relation was not specified.

Solution

Specify a level relation.