LIMIT and QDR Enhancements

In Oracle 10g, the following changes have been made for managing dimension status:

• You can order the results of a LIMIT based on the order of the selection arguments rather than the current status order. Additionally, you can LIMIT to values of custom members; and, when you limit using a parent relation, you can specify that you only want the top or the bottom members of a hierarchy in status.

  
  

  See: LIMIT command, LIMIT function

  
  

• There is additional support for using CHGDIMS to manage dimension status.

  
  

  See: CHGDIMS, RANK

  
  

• There is support for nonexistent values in LIMIT statements and QDRs.

  
  

  See: LIMITSTRICT

  
  

• You can set the current status list of one or more base dimensions of a composite, conjoint dimension, concat dimension, or a partition template based on the selected values of that object. You can also assign a value to one or more valuesets for the base dimensions.

  
  

  See:: LIMIT BASEDIMS