Oracle9i OLAP Developer's Guide to the OLAP DML Release 2 (9.2) Part Number A95298-01 |
|
Selecting Data, 11 of 13
The current status list of a concat dimension is separate from the current status lists of its base dimensions. However, you limit a concat dimension by specifying values of its base dimensions.
In Example 6-9, the base dimensions of the concat dimension reg.dist.cc
are the simple dimension region
and the conjoint dimension proddist
. The example limits the concat dimension to the WEST
region and proddist
to the conjoint values TENTS DENVER
and RACQUETS DENVER
and then reports the values of the concat dimension.
LIMIT reg.dist.ccdim TO region'WEST' LIMIT reg.proddist.ccdim ADD proddist <'TENTS' 'DENVER'> - <'RACQUETS', 'DENVER'> REPORT reg.proddist.ccdim REG.PRODDIST.CCDIM ------------------------------ <REGION: WEST> <PRODDIST: <TENTS, DENVER>> <PRODDIST: <RACQUETS, DENVER>>
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|