Oracle9i OLAP Developer's Guide to the OLAP DML Release 2 (9.2) Part Number A95298-01 |
|
Selecting Data, 10 of 13
You can limit a conjoint dimension in either of the following ways:
See Also:
"Defining Variables That Handle Sparse Data Efficiently" for more information about conjoint dimensions. |
To limit a conjoint dimension to a list of values, you can use the following constructions:
LIMIT proddist TO <'TENTS' 'BOSTON'> <'FOOTWEAR' 'DENVER'>
prodname = 'CANOES' distname = 'SEATTLE' LIMIT proddist TO <prodname distname>
\n
(the linefeed escape sequence).
namelist = mytext = '<\'TENTS\' \'BOSTON\'>\n <\'FOOTWEAR\' \'DENVER\'>' LIMIT proddist TO namelist
Because there is an implicit relation between a conjoint dimension and its base dimensions, you can limit the conjoint dimension by limiting the base dimensions.
For example, the following command limits a conjoint dimension named proddist
to all conjoint values having CANOES
as one of the values of the base dimension product
.
LIMIT proddist TO product 'CANOES'
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|