Oracle9i OLAP Services Developer's Guide to the OLAP DML Release 1 (9.0.1) Part Number A86720-01 |
|
Limiting an Application's View of the Data, 9 of 11
You cannot explicitly limit the values of a composite. Composites are not dimensions and, therefore, do not have any independent status. The values of a composite that are in status are determined by the values that are in status in the base dimensions of the composite. In general, when OLAP DML functions and commands deal with objects that are defined with composites, the default behavior is to treat those objects as if no SPARSE keyword or named composite had been used when the object was defined.
You can use the LIMIT command to set status for the dimensions of a variable that is defined with a composite in the same way you would when the variable is not defined with a composite.
Suppose your analytic workspace contains a variable named COUPONS that is dimensioned by MONTH and (using the PROD_MARKET composite) PRODUCT and MARKET as shown in the following definition.
DEFINE COUPONS VARIABLE INTEGER <MONTH PROD_MARKET <PRODUCT MARKET>>
The following commands display the default status of all of the base dimensions of the COUPONS variable.
status coupons The current status of MONTH is: ALL The current status of PRODUCT is: ALL The current status of MARKET is: ALL
Later, when you want to access only the values of COUPON that apply to sportswear, you limit the base dimension PRODUCT as shown below.
limit product to 'SPORTSWEAR' status coupons The current status of MONTH is: ALL The current status of PRODUCT is: SPORTSWEAR The current status of MARKET is: ALL
You can limit a conjoint dimension in either of the following ways:
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'
For more information, see the following table.
IF you want documentation about . . . | THEN see . . . |
---|---|
limiting dimensions, |
the entry for the LIMIT command in OLAP DML Reference |
conjoint dimensions, |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|