Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
|
|
View PDF |
The ALLSTAT command sets the status of all dimensions in the current analytic workspace to all their values. ALLSTAT does not, however, set the status of the NAME dimension.
Syntax
ALLSTAT
Notes
Limiting One Dimension
You can set the status of a single dimension to all its values with the LIMIT command.
ALLSTAT and the LOCK_LANGUAGE_DIMS Option
When LOCK_LANGUAGE_DIMS is TRUE
, ALLSTAT ignores language dimensions. When LOCK_LANGUAGE_DIMS is FALSE
, ALLSTAT treats language dimensions the same way it treats other dimensions.
Examples
Example 7-28 Limiting to All Values
The following STATUS statement produces the current status of the dimensions of the variable UNITS.
status units
The current status of MONTH is: Jul96 TO Dec96 The current status of PRODUCT is: Tents TO Racquets The current status of DISTRICT is: DALLAS
After you execute an ALLSTAT statement the same STATUS statement produces this output.
The current status of MONTH is: ALL The current status of PRODUCT is: ALL The current status of DISTRICT is: ALL