Re: Oracle Model Operator - Question

From: DA Morgan <>
Date: Wed, 22 Oct 2008 06:25:05 -0700
Message-ID: <>

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.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Oct 22 2008 - 08:25:05 CDT

Original text of this message