Tuesday, 12 June 2012

ORA-36988: (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.

ORA-36988: (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.

Cause: The related dimension of the destination relation has the wrong data type.

Action: Redefine the destination relation or choose another relation whose related dimension is of type NUMBER.

ORA-36986: (XSRELGID05) Relation workspace object must be dimensioned by workspace object.

ORA-36986: (XSRELGID05) Relation workspace object must be dimensioned by workspace object.

Cause: The destination relation is not dimensioned by the dimension of the source relation.

Action: Redefine the destination relation or choose another relation with the correct dimensionality.

ORA-36982: (XSRELGID03) The grouping variable or relation workspace object must be dimensioned by all dimensions of the source relation workspace object that have more than one value in status.

ORA-36982: (XSRELGID03) The grouping variable or relation workspace object must be dimensioned by all dimensions of the source relation workspace object that have more than one value in status.

Cause: Destination variable or relation does not have enough dimensionality to hold the result from the multi-dimensional source relation.

Action: Either limit the status of hierarchy dimensions or redefine the destination variable or relation with the extended dimensionality

ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.

ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.

Cause: The destination variable does not have a numeric data type.

Action: Make sure the variable is numeric.

ORA-36978: (XSRELGID01) workspace object must be a self-relation.

ORA-36978: (XSRELGID01) workspace object must be a self-relation.

Cause: Source relation is not a self-relation.

Action: Specify a self-relation as the source relation.

ORA-36977: (XSRELGID17) The GROUPINGID command does not support hierarchies with more than 126 levels.

ORA-36977: (XSRELGID17) The GROUPINGID command does not support hierarchies with more than 126 levels.

Cause: The user specified a hierarchy with more than 126 levels.

Action: Decrease the number of levels in the hierarchy.

ORA-36976: (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID (relation1( INTO {variable | relation2 | surrogate} (USING levelrelation( (INHIERARCHY {inhvariable | valueset}( (LEVELORDER levelordervs( The source relation can be omitted only when using both surrogate gid and level order valueset.

ORA-36976: (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID (relation1( INTO {variable | relation2 | surrogate} (USING levelrelation( (INHIERARCHY {inhvariable | valueset}( (LEVELORDER levelordervs( The source relation can be omitted only when using both surrogate gid and level order valueset.

Cause: Command format is not correct.

Action: Check the object type and number, and give the correct format.