Re: Oracle Model Operator - Question

NHM wrote:

> My problem, is that normally: not all cell combinations are defined...
> for example (person X, Year Y) may have no data registered in the
> database. (in olap you'd say in the fact table)
>
> Anyway, I don't care about it... I'd like the return table to give me
> all the cell combinations, even if they were null.

ANY can be used in cell references to include all dimension values including NULLs.
http://www.psoug.org/reference/model_clause.html

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org