Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
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
You can set the status of a single dimension to all its values with the LIMIT command.
Examples
Example 7-24 Limiting to All Values
The following STATUS stsatement 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