Skip Headers

Oracle9i OLAP Developer's Guide to the OLAP DML
Release 2 (9.2)

Part Number A95298-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Selecting Data, 11 of 13


Limiting Concat Dimensions

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.

Example 6-9 Limiting Base Dimensions of a 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>>

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2001, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback