Related Dimension and Relation Enhancements

In Oracle 10g, enhancements have been made for working with related dimensions and relations:

• When two dimensions share more than one relation, you can explicitly specify a default relation that Oracle OLAP uses when performing a LIMIT based on related dimensions and performing calculations such as TOTAL.

  
  

  See: RELATION command, OBJ

  
  

• When limiting based on the values of a related dimension, you can explicitly specify the relation by which to perform the limit; and, if the relation is a multidimensional relation, you can specify what values of the relation to use.

  
  

  See: LIMIT command (using LEVELREL), LIMIT command (using related dimension), and LIMIT command (using parent relation)