RELATION command

The RELATION command default relation definitions for the dimensions of the current object definition; or removes default relation definitions from the current object. For more information on default relations, see "Using Related Dimensions in Expressions".


Tip:

The current object definition is the definition of the object that has been most recently defined or considered during the current session. To make an object definition the current definition, use a CONSIDER statement.

Syntax

RELATION {dimension-name relation-name }| DELETE { ALL | dimension-name}

Arguments

dimension-name

The name of the dimension of the currently considered object for which you want to specify or delete a default relation.

relation-name

The name of the relation that Oracle OLAP uses as the default relation for the dimension specified by dimension-name.

DELETE

Specifies removal of previously-specified default relation information.

ALL

Removes all previously-defined default relation information.

Notes

How Oracle OLAP Chooses Between Multiple Relations

When there is more than one relation between the two dimensions and you attempt to perform calculation on one of those dimension based on related dimensions, Oracle OLAP chooses the relation to use when executing the statement as follows:

  1. Uses the relation specified in the statement, if any.

  2. Uses the default relation for the dimension. You can specify a default relation for a dimension by using the RELATION command. If you do not specify a default relation in that manner, Oracle OLAP recognizes the first relation that you defined as the default dimension.

Identifying Default Relations

Use the OBJ function with the RELATION keyword to find out what the default relation is for an object and what default relation information has been specified for an object.

Multiple RELATION Commands Against the Same Object

Unlike other statements that operate against the most recently considered object (for example, an LD statement), a new RELATION command does not replace previously-issued RELATION commands. Instead, issuing multiple RELATION commands against the same object has a cumulative effect.